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

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

To implement SQL Server database synchronization between SQL Server editions (including SQL Server Compact Edition), simply reference the SyncSQL2008_Standard_Express_Compact35 project in your Visual ...