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 …
How to Query JSON Data Quickly in SQL Server, Part 2: SQL Server 2025
SQL Server 2025 and .NET 10 bring several new improvements to storing JSON natively in the database and querying it quickly. On the SQL Server 2025 side, the two big ones are the new native JSON indexes and the new JSON_CONTAINS function. Let’s see the …
5 Strategies to Refactor SQL Code
Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality code – yet somehow often gets overlooked in SQL. In this article, we’ll explain what refactoring is, how it helps, and give concrete …
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 into system behavior. By integrating PostgreSQL with Python, we can build a powerful and efficient logging system that sto …