This topic is relevant only for databases under the full recovery model that contain multiple filegroups. In this example, a database named `adb` contains three filegroups. Filegroups `A` and `C` are ...

Logging of OFFLINE operation: The identity of the WSFC node where the OFFLINE operation was initiated is stored in both the WSFC cluster log and the SQL ERRORLOG. If you did not delete the ...

The APNC needed a way to collect these surveys while out in the neighborhood and then synchronize the data back to the SQL Server database. This type of scenario occurs at many businesses and ...

For in-market versions of SQL Server 2019 and 2017, we had added an improvement that allowed the Stretch Database feature to stretch a table to an Azure SQL Database. Effective July 9, 2024, the ...

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 ...

The APNC needed a way to collect these surveys while out in the neighborhood and then synchronize the data back to the SQL Server database. This type of scenario occurs at many businesses and ...