[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 home office, so I switched to answering your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 03:59 MyTeaGotCold: How …
Evolving SQL Saturday
This is a guest editorial by Steve Jones (President of the SQL Saturday Corporation). The last four years have seen a successful reboot of the SQL Saturday franchise. After Redgate Software donated the brand to a new independent nonprofit corporation i …
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 Azure SQL DB, I gave it a quick test, and the performance was horrific. It was bad in 3 different ways: The CPU usage was terrible, burning 60 second …
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, benefits, and career progression. This year, the survey is for unemployed folks, too! The first question has a new option for “Unemployed (and l …
10 Key Concepts Developers Should Know About the SQL Server model Database
When you create a new database in SQL Server, you might assume that the system starts with an empty template and builds from scratch. In reality, every new database begins as a copy of model, one of the system databases. Understanding how model works, …
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 SQL Server and Azure SQL DB training classes – but only for 3 months. If you’re confident you can get your learn on quick, this is for you …
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 little about others. However, the last few years I find myself using emojis more and more in quick communications as they seem to add some fun to the intera …
Making AI Talk to Your Database: AI-Powered Database Queries Made Simple
Nowadays, artificial intelligence is everywhere. It’s so prevalent that even universities are implementing it into their curriculums. That’s the case because on its face, AI really is immensely powerful – we can find pretty much any information on anyt …
[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 a glass of wine, and go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:54 iliyan Rashev: Hello Brent, …
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data
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 is Best?
In this article, the latest in the MySQL vs PostgreSQL series, we’ll compare how they each handle JSON (JavaScript Object Notation) data, how they store, query, and manage it, and which offers more flexibility or better performance depending on your ne …
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 that there are a lot of people out there who hate AI, and believe me, I hate most uses of it. Lots of its advice can be misleading at best, and abs …
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 this Christmas. And by Santa, I mean me. SQL Server 2025, 2022, and 2019 all dramatically changed the game for performance tuning. We have more and better too …
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 face I/O-related issues because it interacts with the storage subsystem. The most critical errors we might face are 823 and 824. These errors …