Breaking News: Hold Off on SSMS 22.11.0
There's a new SQL Server Management Studio update out today.
I'd hold off on it for now.
Live online · Registration open through Nov 30
Four live class weeks of SQL Server performance tuning, with me answering questions as we go. Registration closes Nov 30; after that, it’s recordings only until next year.
18d 11h 23m Until the live classes start · Nov 2, 9 AM Pacific
$4,395
$995
Black Friday price
Live Class Season Pass 2027 · Save $3,400
Plus a Monday roundup of my favorite database news from around the web.
Find out free with sp_Blitz and the First Responder Kit — trusted by DBAs everywhere.
Download the kitNeed hands-on help? SQL Critical Care® — my 2-day server assessment that finds the root cause and hands you the fix.
See consultingThere's a new SQL Server Management Studio update out today.
I'd hold off on it for now.
Microsoft has started a series of blog posts helping Postgres developers who are "upgrading" to Microsoft SQL. (Microsoft's been using that generic "SQL" term to refer to its collection of database products: Azure SQL DB, Hyperscale, Managed Instances, and SQL Server.)
I let the first blog post slide, but the second post explained why Microsoft is so much better than Postgres at handling connections, and it's so egregiously misleading that I'm gonna have to step in.
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In my new totally free How to Think Like the Engines class, you’ll learn how the SQL Server and Postgres database engines look at your indexes and build your query results.
Tick tock.
SQL Server 2017 extended support ends on October 12, 2027.