Whenever I restore a database — especially one I obtained outside of my regular environment (for example a customer database, a development database, or even a sample database like WideWorldImporters) — there are a few…
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server, was decoupled from the server product for SQL Server 2016. For the last 18 months…
This week we will actually move a database into Azure SQL Database, using the first of two of Microsoft’s recommended methods. The main thing to keep in mind is that SQL Server (on-premises, or “earthed”)…