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 is an out-of-band update that usually includes bug fixes and/or…
Unsupported but working versions of SQL Server on Windows Server 2019
One of my hobbies is trying to break technology so that you don’t have to. I don’t consider myself a professional or hobbyist hacker, though if the shoe fits… Last year when Windows Server 2019…
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 or two. At the end of Chapter 1 I have…
When security and news collide
Behold! There’s a scary monster called skip‑2.0, announced by ESET: This backdoor targets MSSQL Server 11 and 12, allowing the attacker to connect stealthily to any MSSQL account by using a magic password – while…
Time to upgrade your SQL Server 2005 instance
Last edited on 17 November 2016. As you know, SQL Server 2005 is now over ten years old. Microsoft has helpfully provided a list of ten reasons why you should be upgrading from SQL Server 2005. The…
dbi_ContianmentState
I was perusing the headers of some databases on my SQL Server 2012 instance, and came across an interesting typo after running DBCC DBINFO: dbi_ContianmentState In my CTP of SQL Server 2014, it has been…