Antique telephone callbox

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 was released I wanted to see which versions of SQL Server I could run on it, testing more the unwritten
-> Continue reading Unsupported but working versions of SQL Server on Windows Server 2019

turned off vintage black television

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 a small note about deprecated and discontinued features, and this post expands on that section. The following statements are true:
-> Continue reading Deprecated and discontinued features in SQL Server

A steel padlock

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 automatically hiding these connections from the logs. Such a backdoor could allow an attacker to stealthily copy, modify or delete
-> Continue reading When security and news collide

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?