Patch your SQL Server instance today
On 14 February 2023, Microsoft released updates for all supported versions of SQL Server in the form of a General Distribution Release (GDR). A GDR… Read More »Patch your SQL Server instance today
Home »
SQL Server 2016
Zeroing out a transaction log file does not use zeroes
I’ve been doing SQLskills training recently, and Paul Randal (blog | Twitter) reminded our class that zeroing out a transaction log file does not use… Read More »Zeroing out a transaction log file does not use zeroes
Deprecated and discontinued features in SQL Server
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
When the buffer pool isn’t just in memory
Last time we looked at the four major components of a computer system, and then looked at the SQL Server buffer pool as a way… Read More »When the buffer pool isn’t just in memory
Max Server Memory and SQL Server 2016 Service Pack 1
(This post was last updated on 1 August 2022.) Everything changed for SQL Server Standard Edition on 16 November 2016, and how memory limits work.… Read More »Max Server Memory and SQL Server 2016 Service Pack 1
Temporal Tables and Hidden Period Columns
In my November 2015 post, An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean, I wrote: The HIDDEN property is optional and… Read More »Temporal Tables and Hidden Period Columns
A look back, and a look forward
Time flies. My father used to wear a t-shirt that claimed, “When you’re over the hill, you pick up speed.” I’m turning 40 in a… Read More »A look back, and a look forward
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… Read More »Wait For Service Pack 1
How to make your T-SQL thirty percent faster
Last week, I mentioned a feature in SQL Server, and now in Azure SQL Database, called Memory-Optimized Table-Valued Parameters, which makes use of In-Memory OLTP… Read More »How to make your T-SQL thirty percent faster
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… Read More »The Data Migration Assistant
Should I move my on-premises database to Azure SQL Database?
This week is a shorter post than last week, but it answers a very important question: Should I move my on-premises database to Azure SQL… Read More »Should I move my on-premises database to Azure SQL Database?
Basic Availability Groups in SQL Server 2016
One of the new features in SQL Server 2016 Standard Edition, which may appeal to users of the deprecated Database Mirroring feature, is Basic Availability… Read More »Basic Availability Groups in SQL Server 2016
Temporal Tables – When To Use Them
Last edited on 18 December 2019. This is the final part of my Temporal Table series. You can read parts one, two and three here.… Read More »Temporal Tables – When To Use Them
Modifying Temporal Tables – A Primer
This is part three of the Temporal Tables series. You can read parts one and two here. Last week I demonstrated how temporal tables in… Read More »Modifying Temporal Tables – A Primer
Temporal Tables Under The Covers
(This is a more technical post than last week. If you are not familiar with SQL Server internals, I will not be upset if you… Read More »Temporal Tables Under The Covers