One other thing to note in my CREATE INDEX statement is that I set the index to use data compression. Since SQL Server 2016 SP1, compression is built into all editions of SQL Server, and reduces ...

I could then restore that data into my "containerized" SQL Server. This also positions me to load different datasets from different backups. After using SQL Server Management Studio to create the ...

SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals ...