In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Most Common Wait Types in SQL Server and What They Mean. ASYNC_NETWORK_IO—The async_network_io wait types point to network-related issues. They are most-often caused by a client application not ...

There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...

The tool's Always Encrypted functionality was also improved, as described in another post published by Microsoft yesterday titled "Always Encrypted Assessment in SQL Server Management Studio 21." ...