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 […]
Archives de l’année : 2026
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. […]
I’m Just Gonna Leave This Here
Sometimes my value as a blogger is to make complex topics simple, or to deliver industry news to […]
Power BI Project (PBIP) is now generally available. Here’s why ...
Do you know where you were on June 15, 2023? Do not fret, neither do I. But […]
So, What’s New Lately in My SQL Server Training Classes?
On Wednesday, registration opens for the next round of my live training classes, and you can get access […]
How to close SQL Server operational blind spots (linked servers, ...
The SQL Server attack pattern is consistent: attackers do not always need a spectacular vulnerability. They often […]
[Video] Office Hours Off the Coast of Long Beach
A couple times a year, I go away for a week to think about what’s working well, what […]
Announcing a New Way to Reinforce Your Resume: My Alumni ...
I hope you never have to look for another job. However, if you do, I wanna give you […]
How to run PostgreSQL in Docker (getting started with PostgreSQL, ...
The goal of this guide is simple: get PostgreSQL up and running in the fastest, easiest way. […]
Database Animations: Stop Using Page Splits to Justify Lowering Fill ...
You’re looking at page split numbers in a monitoring tool or Perfmon, and you’ve heard that page splits […]
The one big difference between MySQL and MariaDB you may ...
The big difference between MySQL and MariaDB largely revolves around database storage engines and anything related to […]
How test data management helps meet DORA’s resilience testing requirements
DORA requires financial institutions to run tests that prove their systems can withstand operational disruption without exposing […]
Join Me at Day of Data Orlando Next Month
Next month on Saturday, October 17, I’ll be speaking at the free Day of Data Orlando. Registration is […]
What happens when your AI coding agent starts a database ...
At the end of the previous article in my series on building an app and database almost […]
[Video] Office Hours: Open Q&A for Microsoft Databases
Today I’m back in the home office, finishing up teaching Mastering Index Tuning and getting ready to head […]
Live Class Enrollment Opens Soon – For Just $995!
I teach Microsoft SQL Server performance tuning in a 4-class rotation. The winter rotation is getting ready to […]
Should your SQL Server database use foreign key constraints?
Foreign key constraints exist to stop bad data before it happens, yet plenty of production SQL Server […]
“But NOLOCK won’t hurt me if I’m using an index!”
NOLOCK is bad and you probably shouldn’t use it, but every time I mention that publicly, the pushback […]
How a Microsoft-signed SQL Server stored procedure lets sysadmins bypass ...
SQL injection inside Microsoft-signed system stored procedures is not supposed to happen. Yet, as I’ve been documenting […]
How to delete personal data for GDPR & CCPA compliance
Deleting a customer’s personal data under GDPR or CCPA means erasing it everywhere it’s stored — not […]
Détecter des opérations spécifiques sur une capacité Microsoft Fabric
« Nous avons créé une capacité Copilot dédiée. Mais comment savoir que Copilot s’exécute réellement dessus, et […]
[Video] Office Hours on Mount Charleston
For this episode, I’m up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the […]
How to avoid demo fails when presenting at tech conferences
Roughly two out of every three tech conference session demos fail — that’s according to experienced attendee […]
Database Animations: How SQL Server’s JSON Indexes Work
By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to […]
Bi-directional logical replication in PostgreSQL: a practical guide
Logical replication has long been a feature of many database management systems. It’s the simple process of […]
Set Your Application Names Before You Wish You Had.
When you run monitoring queries like sp_BlitzWho and sp_WhoIsActive, you wanna see the program names that are running […]
How to mirror data from SQL Server to Microsoft Fabric: ...
Mirroring in Microsoft Fabric is useful when you need to make SQL Server data available in Fabric. […]
[Video] Office Hours: Stoicism in the Home Office
I’m back in the home office this week, covering your top-voted questions from https://pollgab.com/room/brento, and we finish up […]
Learning PostgreSQL with Grant: Preparing for the PostgreSQL certification
I want to be up front and honest: I suspect I’ll fail this. However, I’m going to […]
Who’s Hiring Database People? September 2026 Edition
Is your company hiring for a database position as of September 2026? Do you wanna work with the […]
SQL Server login failures: how to monitor, report, and alert ...
Failed logins are one of the clearest early-warning signs of trouble on a SQL Server – whether […]
Free Webcast: You Shouldn’t Use SQL Agent for Batch Processes.
SQL Server Agent is a solid scheduler for database administration and simple, database-local automation. In a small to […]
Is AI already learning from our old, poor-quality code?
In this Simple Talk opinion piece, Greg Low unpacks how AI models actually filter and weigh training […]
Why SQL Server’s default trigger execution model is a security ...
In my previous article, I described a privilege escalation scenario involving Azure Arc-enabled SQL Server and a […]
What is cloud database vendor lock-in? The 3 types explained ...
Cloud database vendor lock-in is one of the most expensive surprises in enterprise infrastructure — not because […]
How to Download the Stack Overflow Database for Postgres
You wanna learn PostgreSQL, and you wanna use a sample database with big real-world data, the same kinds […]
What your AI strategy is missing (according to the people ...
AI is everywhere, and the pressure to adopt it is relentless. But what does responsible, practical AI […]