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 …
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 arise, such as privileges, configuration, encryption, patching, and monitoring. This article outlines 15 practical, high-impact steps you can …
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 in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server …
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 tiny T-SQL. Today, I’m going to walk you through my thought process – the initial attempts I tried and failed with, and the discoveries I made along the …
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 Warehouse. Last time, we were using the Adventure Works schema which was deployed to an Azure SQL Database. Today, we are going to learn h …
SQL Declare Variable Code Examples
The post SQL Declare Variable Code Examples appeared first on SQLServerCentral.