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.
Steps for Installing AlwaysOn Availability Groups – SQL 2019
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing Alw …
Updated First Responder Kit and Consultant Toolkit for November 2025
This quarter’s release includes new checks for SQL Server 2025’s new memory pressure warnings, Azure SQL DB’s operations in progress, accurate CPU usage on Docker containers, warnings about not using partitioned statistics where appropriate, and much m …
SQL Server 2025 Build List
This is a list of the builds for SQL Server 2025. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlserve …
This Is It! Our Black Friday Sale Ends Sunday.
You work with Microsoft SQL Server, Azure SQL DB, and Amazon RDS SQL Server. When people call in saying the server is slow, you’re the one who has to take the call. It’s up to you to figure out the bottleneck, which queries are causing that bottleneck, …
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
When we talk about performance tuning in SQL Server, the first thing that comes to mind is indexes. Everyone knows clustered indexes, nonclustered indexes, and included columns. But very few people ever bother with a small, often overlooked gem introdu …
JSON Data Extract from SQL Server 2025
The post JSON Data Extract from SQL Server 2025 appeared first on SQLServerCentral.