SQL Server 2017 Administration Inside Out

For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind, which is hopefully going to culminate in an actual technical book that I can point to and say “Yes, that’s the name I invented for myself when we moved to
-> Continue reading SQL Server 2017 Administration Inside Out

Changes to Service Packs and Cumulative Updates for SQL Server 2017

Edited on 10 October 2018: Please note that this model has changed. See Changes to the SQL Server servicing model (Cumulative Updates) for more. The updated information is below. For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update model, in order to get bug
-> Continue reading Changes to Service Packs and Cumulative Updates for SQL Server 2017

Post image

SQL Server Management Studio v17.0

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 or so, we have been receiving semi-regular updates to SSMS (which we can download from Microsoft, for free), which is
-> Continue reading SQL Server Management Studio v17.0

Post image

Max Server Memory and SQL Server 2016 Service Pack 1

Everything changed for SQL Server Standard Edition on 16 November 2016, and how memory limits work. On that day, a slew of Enterprise Edition features made their way into editions across the board, including Express Edition and LocalDB. The memory limit of 128GB RAM applies only to the buffer pool (the 8KB data pages that
-> Continue reading Max Server Memory and SQL Server 2016 Service Pack 1

Post image

Configuration Manager Shortcut on Windows 10 and Server 2016

(Last updated 2020-01-07) This is more for my own reference than anything. On newer versions of Windows desktop and Windows Server, we may find that the shortcut to SQL Server Configuration Manager is missing. According to Microsoft Docs, the reason for this change is that Configuration Manager is a Management Console snap-in: Because SQL Server
-> Continue reading Configuration Manager Shortcut on Windows 10 and Server 2016

Post image

Wait For Service Pack 1

Conventional wisdom tells us that when Microsoft releases a new version of any server product, we should wait until Service Pack 1 before deploying it to production. This hasn’t been true for a while now, since Microsoft recommended that Cumulative Updates for SQL Server carry the same confidence: SQL Server CUs are certified to the same levels
-> Continue reading Wait For Service Pack 1

Post image

Should I upgrade SQL Server 2012, or migrate to Azure?

[Last updated February 27, 2020] Brent Ozar Unlimited runs a website called SQL Server Updates which comes in really handy for keeping your on-premises SQL Server up to date. Of interest is that extended support for SQL Server 2012 ends on 12 July 2022, just two years from now. As we know, SQL Server 2019
-> Continue reading Should I upgrade SQL Server 2012, or migrate to Azure?

Post image

Database Throughput Units

Last time we briefly touched on the metric that Microsoft uses to keep your Azure SQL Database in check: the DTU, or database throughput unit. It uses a combination of CPU, I/O and log flushes/second, using a special algorithm, to calculate a single unit. The reason for this is simple: Our databases don’t use the same resources
-> Continue reading Database Throughput Units

Post image

The Data Migration Assistant

I’ve written quite a lot about Azure SQL Database recently, but that doesn’t mean I’ve forgotten about the on-premises version of SQL Server. What could be better than Microsoft announcing a new tool for upgrading to SQL Server 2016? The Data Migration Assistant (DMA) for SQL Server was announced on 26 August 2016. Data Migration Assistant
-> Continue reading The Data Migration Assistant