[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 […]
Sites anglophones
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 […]
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 […]
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 […]
SQL Server 2025 Build List
This is a list of the builds for SQL Server 2025. There are other build lists available here. […]
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 […]
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. […]
JSON Data Extract from SQL Server 2025
The post JSON Data Extract from SQL Server 2025 appeared first on SQLServerCentral.
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Introduction Every relational database lives and dies by its transaction log. In SQL Server, that’s the transaction log […]
Functions in the WHERE Clause Are Bad… Right?
Nah, not necessarily. SQL Server’s query optimizer behavior keeps changing with every freakin’ version. Let’s illustrate it with […]
T-SQL Query Exercise: Generate Big Spills
When I was testing SQL Server 2025’s new ability to limit TempDB usage with Resource Governor, I wrote […]
How to Monitor and Optimize Batched Deletion Processes in SQL ...
Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, […]
How to Build an AI-Powered T-SQL Assistant with Python & ...
The post How to Build an AI-Powered T-SQL Assistant with Python & SQL Server appeared first on SQLServerCentral.
SQL Server 2025 Is Out, and Standard Goes Up to ...
Today marks the official birthday of Microsoft SQL Server 2025. Here’s where to download the evaluation version. Here […]
SQL Server 2025 has arrived!
The wait is over. Today we announced the General Availability of SQL Server 2025, the AI-ready enterprise database. […]
How to Create Uber-Fast Maps With Oracle 23ai Vector Tiles ...
Since this article was written, Oracle AI Database 26ai has been released. Oracle Database 23ai added 300+ […]
The DBScan algorithm tutorial
Introduction to the DBScan algorithm In this example, we are going to learn how to use DBScan. DBScan […]
T-SQL in SQL Server 2025: Concatenating Strings
Like many of you, I have often put strings together (concatenation) with a simple arithmetical operator: +. We […]
I Wish SQL Server Had These Four Innovations.
I love SQL Server, and I’m excited for the release of 2025. I think the query processing keeps […]
How to Query JSON Data Quickly in SQL Server, Part ...
SQL Server 2025 and .NET 10 bring several new improvements to storing JSON natively in the database and […]
5 Strategies to Refactor SQL Code
Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality […]
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
Overview Real-time logging and monitoring are essential for modern applications to track events, detect issues, and gain insights […]
JSON_CONTAINS Function in SQL Server 2025
The post JSON_CONTAINS Function in SQL Server 2025 appeared first on SQLServerCentral.
How to Query JSON Data Quickly in SQL Server, Part ...
Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL […]
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, ...
The post Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples appeared first […]
SQL Server CROSS APPLY and OUTER APPLY Helpful Examples
The post SQL Server CROSS APPLY and OUTER APPLY Helpful Examples appeared first on SQLServerCentral.
T-SQL in SQL Server 2025: Substring Changes
The SUBSTRING() function has been one of my most often used tools over the years, often to massage […]
[Video] Office Hours in Roatan, Honduras
My cruise ship took a detour to Honduras to avoid the hurricane. Let’s hang out on the beach […]
Who’s Hiring Microsoft Data People? November 2025 Edition
Is your company hiring for a database position as of November 2025? Do you wanna work with the […]
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User ...
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, […]
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User ...
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.