SQL Server 2016 end of support: how to choose your ...
SQL Server 2016 reached the end of extended support in July 2026, which means it no longer […]
Archives du mois : octobre 2026
[Video] Talking Pronouns in Alaska
This episode is entirely dedicated to just one question, and it’s not a technical one. MidwestDBA asked, “When […]
Why’s This Query So Slow in Prod? Check sp_BlitzPlanCompare.
You’re testing a query, and you’re just not getting the same performance between the development and production servers. […]
How to fix “too many connections” in PostgreSQL (step-by-step guide)
Getting the “too many connections” error in PostgreSQL? You’ve hit the database’s max_connections limit — and it’s […]
I’m Probably Not Supposed To Show You Microsoft’s Auto-Indexing Tool.
This needs to just stay between you and me, okay? Microsoft’s been working on automatically indexing SQL Server […]
Why your schema shouldn’t mirror your database (and what to ...
Tony’s Pizza looks simple from the outside. A customer orders a pizza, the pizza is prepared, and […]
Thoughts on AI After My Panel Discussion
Today at Day of Data Orlando, I moderated a panel discussion with Bob Ward, Celia Brusatori, Kevin Feasel, […]
What I learned after a weekend of AI troubleshooting gone ...
Grant Fritchey walks through a real troubleshooting saga – using Wine, a shim DLL, a misconfigured registry […]
[Video] Office Hours on the Last Alaskan Cruise of the ...
It’s a cold, gloomy day on the very last Alaskan cruise of the season. Yes, I picked this […]
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. I […]
Fact-Checking Microsoft’s “PostgreSQL to SQL Field Notes: Connections”
Microsoft has started a series of blog posts helping Postgres developers who are “upgrading” to Microsoft SQL. (Microsoft’s […]
How to create roles, databases and tables in PostgreSQL (getting ...
Setting up PostgreSQL the right way starts long before your first table exists. In this guide, you’ll […]
Free Webcast: How to Think Like the SQL Server & ...
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re […]
SQLite 3.54.0 : : CLI enrichie, fin de Windows XP
SQLite 3.54.0 est disponible depuis septembre dernier. Elle introduit de nouveautés dans la CLI. Le prompt peut afficher des […]
Heads Up: SQL Server 2017 Support Ends One Year From ...
Tick tock. SQL Server 2017 extended support ends on October 12, 2027. That means today, you need to […]
How to make database schema changes without downtime in MySQL: ...
Every growing application eventually faces the same challenge: your database schema needs to change, but your users […]
How to secure temporary objects, metadata visibility, and audit assurance in ...
SQL Server environments that are patched, firewalled, and configured to best practice can still carry hidden risk. […]
[Video] A Very Special Episode of Office Hours
When we were kids, we knew we were in for something heavy whenever a TV series began an […]
Who’s Hiring Database People? October 2026 Edition
Is your company hiring for a database position as of October 2026? Do you wanna work with the […]
Why test data management is essential for SOC 2 compliance
Using live data outside production is one of the fastest ways to create compliance risk. It becomes […]
Your queries are slow. Let’s make your training request fast.
You wanna take my SQL Server classes. Your boss wants to know what they cost, when you’ll be […]
The future of data leadership: key strategies, challenges, and emerging ...
Data is one of the most valuable assets an organisation can hold — but only if it’s […]
When You Work with AI, You’re a Middle Manager.
I got my start in hotels & restaurants, worked my way up to being a hotel general manager, […]
How to secure MCP (Model Context Protocol) servers connected to ...
AI agents don’t ask permission before every query. Instead, they themselves decide which tools to call and […]
What really happens when you let AI design your database ...
AI coding assistants have become a fixture in most developers’ workflows, but when it comes to databases, […]
Registration Is Open Now! $995 for a 2027 Live Class ...
I teach Microsoft SQL Server performance tuning in a 4-class rotation. The winter rotation is getting ready to […]
Why PostgreSQL shouldn’t be your app’s answer to everything
PostgreSQL is one of the most capable relational databases available, but capability isn’t the same as suitability. […]