My co-authors and I recently wrapped up the book SQL Server 2019 Administration Inside Out, which should be hitting the shelves in the next week… Read More »Deprecated and discontinued features in SQL Server
SQL Server 2017
SQL Server 2017 Administration Inside Out was the first technical book I contributed to, and all its authors were very happy with how it turned… Read More »Did you know we have another SQL Server book coming out?
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL Server with media that includes… Read More »Create a slipstream installer for SQL Server on Windows
On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017. From today onward, we can… Read More »Changes to the SQL Server servicing model (Cumulative Updates)
SQL Server 2017 is supported on Ubuntu 16.04 LTS (Long-Term Support), however that version of Ubuntu Linux is now more than two years old, so… Read More »Repair SQL Server on Linux after an Ubuntu distribution upgrade
In November 2017, during the PASS Summit keynote, Microsoft’s Bob Ward (Principal Architect) demonstrated a “diskless database” running on Hewlett-Packard Enterprise (HPE) hardware. The storage… Read More »No moving parts, the story of persistent memory
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,… Read More »SQL Server 2017 Administration Inside Out
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… Read More »Changes to Service Packs and Cumulative Updates for SQL Server 2017
[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… Read More »Should I upgrade SQL Server 2012, or migrate to Azure?