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.
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 file; in PostgreSQL, it’s the WAL (Write-Ahead Log). It’s the beating heart that guarantees durability, recovery, and replication. W …
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 a simple query against the Stack Overflow Users table: CREATE INDEX Location ON dbo.Users(Location); GO SELECT COUNT(*) FRO …
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 a few fun diabolical demos. One of them was to generate giant spills to TempDB, quickly. When you’re looking at an actual (not estimated) query plan, …
How to Monitor and Optimize Batched Deletion Processes in SQL Server
Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned deletes can cause blocking, long-running transactions, and heavy log usage. Learn how to monitor and optimize these processe …
How to Build an AI-Powered T-SQL Assistant with Python & SQL Server
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 256GB RAM, 32 Cores!
Today marks the official birthday of Microsoft SQL Server 2025. Here’s where to download the evaluation version. Here are the top things you wanna consider as you talk to your managers, developers, and end users. The feature differences between 2025 En …
SQL Server 2025 has arrived!
The wait is over. Today we announced the General Availability of SQL Server 2025, the AI-ready enterprise database. SQL Server 2025 is now available for download or purchase through your normal licensing models. Download it today from https://aka.ms/ge …
How to Create Uber-Fast Maps With Oracle 23ai Vector Tiles and H3 Indexes (Part 2)
Since this article was written, Oracle AI Database 26ai has been released. Oracle Database 23ai added 300+ new features like the new VECTOR datatype that get most of the attention, but often overlooked are two additions that dramatically expand support …
The DBScan algorithm tutorial
Introduction to the DBScan algorithm In this example, we are going to learn how to use DBScan. DBScan is a clustering algorithm used to find patterns. We are going to use it to analyze SQL Server data and find patterns about customers. In this tutorial …
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 have a few other ways to put strings together, but in SQL Server 2025, we have a new operator that allows us to put strings together. This i …
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 getting better, which means your apps are gonna go faster, with less code changes. The AI stuff is a little fluffy, and I don’t think time will be kind to it …