SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained
When SQL Server 2025 was announced, Bob Ward mentioned that there would be some new commands for […]
Sites anglophones
[Video] Office Hours Aboard the Groove Cruise
On the world’s largest floating electronic dance music festival, I took your top-voted database questions from https://pollgab.com/room/brento. Here’s […]
Who’s Hiring Database People? February 2026 Edition
Is your company hiring for a database position as of February 2026? Do you wanna work with the […]
I’m Coming to #SQLBits! Here are My Sessions.
The annual SQLBits conference is April 22-25, and they just announced the session and speaker lineup. This year’s […]
[Video] Home Office Hours, Under Construction Edition
While in the midst of moving my home office into a new room in the house, I stopped […]
Automatic Stats Updates Don’t Always Invalidate Cached Plans
Normally, when SQL Server updates statistics on an object, it invalidates the cached plans that rely on that […]
Securing Your Databases in 2026: Best Practices for the Evolving ...
In 2026, your approach to both applications and databases must be focused on practical and technical real-world […]
Maybe You Shouldn’t Even Be Using Clustering or AGs.
Sandra Delany (LinkedIn) wrote a well-thought-out blog post called, “Should a SQL Server DBA Know Windows Clustering?” She’s […]
SQL Server 2025 CU1 is Off to a Rough Start
SQL Server 2025 Cumulative Update 1 came out last week, and I was kinda confused by the release […]
Thoughts on PASS’s Bankruptcy, Redgate’s Acquisition, and Private Equity
A private equity (PE) company recently acquired the majority of Redgate Software, the current owners of the PASS Data […]
SQL ConstantCare® Population Report: Winter 2026
It’s time for our quarterly update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks […]
Announcing the 2026 Data Professional Salary Survey Results, And They’re ...
The results are in! You can download the raw data in Excel for all 10 years and do […]
Common SQL Server Problems: Invalid Length
This is another part in my series designed to offer guidance around common issues in SQL Server. […]
SQLBits Session Voting is Open Now! Wanna See My Sessions ...
I’d love to come over and speak at SQLBits this April, but for that to happen, the organizers […]
Vibe Optimizing Power BI
Derrière ce titre accrocheur, cet article rapide explore comment optimiser Power BI à la fois en termes […]
Exploiting SQL Server Date Correlation Optimization: How Tampered Backups Enable ...
This article is a follow-up to SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data, […]
New Year’s Task: Quick, Easy Prep for a Raise
You’re busy, so I’ll keep this short. Several months from now, you’re gonna have a salary review. Your […]
Database Development with AI in 2026
This seems like the appropriate first BrentOzar.com blog post in the year 2026, eh? In the PollGab question […]
How to Create a SQL Server Linked Server to Oracle ...
Easily move data from SQL Server to Oracle 26ai Free with this step-by-step guide. Learn how to […]
SQL Server Regular Expression Performance and Guidelines
SQL Server 2025 introduces regular expression (regex) functions to the TSQL language. You could do this in […]
Are You Looking for Work? Underpaid? Overpaid? Let’s Find Out.
Every year, I run a salary survey to help folks have better discussions with their managers about salaries, […]
Your Favorite Posts From This Year
Reading is fundamental, and fundamentally, here are the 2025 blog posts that y’all read the most this year. […]
How to View SQL Server Object Code Easily with sp_showcode
sp_helptext has served SQL Server DBAs for years, but it has its very obvious – and many […]
Known Issues So Far in SQL Server 2025
Whenever a brand spankin’ new version of any software comes out, there are bugs, and SQL Server is […]
SQL Server Privilege Escalation via Replication Jobs
Privilege escalation in SQL Server isn’t just theory – it can happen through everyday maintenance jobs. This […]
Common SQL Server Problems: Invalid Object Name
This post is part of a series on common issues encountered in SQL Server. This time, we’ll […]
[Video] Office Hours at the Last Spike
I drove the Graffiti Gulf out to The Last Spike (video) outside of Las Vegas and took your […]
Identity Columns Can Have Gaps, and That’s Okay.
Say you’ve got a table with an identity column, something that’s supposed to start at 1 and go […]
Let’s Build a Better KILL. What Do We Need to ...
When there’s a performance emergency, a lot of us perform the same manual tasks over and over. We […]
How to Build an AI-Powered Semantic Search in PostgreSQL with ...
Learn how to build a sleek, AI-powered semantic search engine that lives inside your existing database. We’ll […]
Watch My Training Classes Offline with the Latest Teachable App
If you’re the kind of person who likes to learn on the go, my training provider Teachable just […]
[Video] Office Hours: Everything’s Gone Wrong Edition
I threw in the towel on my workday at 3PM when everything started going wrong in the Ozar […]
Evolving SQL Saturday
This is a guest editorial by Steve Jones (President of the SQL Saturday Corporation). The last four […]
Update: SQL Server 2025’s REGEX Performance Isn’t So Bad!
Back in March 2025 when Microsoft first announced that REGEX support was coming to SQL Server 2025 and […]
How’s the Job Market? Let’s Find Out Together.
Every year, I run a salary survey to help folks have better discussions with their managers about salaries, […]
10 Key Concepts Developers Should Know About the SQL Server model ...
When you create a new database in SQL Server, you might assume that the system starts with an empty […]
Act Fast: The Holiday Speed Round Sale Starting at $129
This holiday season, we’re running a sale specifically for fast learners. For record-low prices, get access to my […]
T-SQL in SQL Server 2025: The UNISTR Function
I am not much for working in languages other than English. That’s my native language and I know […]
Making AI Talk to Your Database: AI-Powered Database Queries Made ...
Nowadays, artificial intelligence is everywhere. It’s so prevalent that even universities are implementing it into their curriculums. […]
[Video] Office Hours: Fireside Chat Edition
It’s the perfect time of year in Las Vegas when we can chill outside by the fire, enjoy […]
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User ...
The post SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data appeared first on SQLServerCentral.
MySQL vs PostgreSQL JSON Data Types: Key Differences & Which ...
In this article, the latest in the MySQL vs PostgreSQL series, we’ll compare how they each handle […]
Get ChatGPT’s Advice On Your Queries with sp_BlitzCache.
First off, I understand if you read the headline and you have a knee-jerk reaction. I totally understand […]
Cyber Monday Sale: $49 Fundamentals, $295 Mastering Classes
You’ve been on the nice list, and Santa has a little something special for you under the tree […]
Random Number Generator in SQL using Marsaglia Polar
The post Random Number Generator in SQL using Marsaglia Polar appeared first on SQLServerCentral.
Troubleshooting Common SQL Server Errors: 823, and 824
SQL Server is designed to provide high reliability and data integrity. However, like any software, it can also […]
15 Practical Tips for Securing SQL Server
Securing SQL Server isn’t complicated, but it does require consistent attention to the areas where real risks […]
T-SQL in SQL Server 2025: The PRODUCT Function
Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts […]
Query Exercise Answer: Generating Big TempDB Spills
In last week’s Query Exercise, I challenged you to play some code golf to generate big spills with […]
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
This article continues the discussion of a meta data driven pipeline that move data from SQL Server into a Fabric […]