JSON Data Extract from SQL Server 2025
The post JSON Data Extract from SQL Server 2025 appeared first on SQLServerCentral.
Sites anglophones
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.
Create and Read the Analysis Services Flight Recorder
One of the most important things in database administration is monitoring. For example, you want to know if […]
Next Week, Start My Mastering Classes for Free!
You’re a developer, database administrator, or DBRE who’s been working with SQL Server, Azure SQL DB, and Amazon […]
Black Friday Doorbusters End Today: Get In Before the Prices ...
Welcome to my annual Black Friday sale, and I’m running special doorbuster deals to sweet talking you into […]
Create an HTML Report on the Status of SQL Server ...
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set […]
Black Friday Doorbusters Are Open Now, Closing Monday!
You’ve been telling yourself, “One of these days, I’ll finally take Brent’s classes.” Get ready, because that day […]
Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets
The post Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets appeared first on SQLServerCentral.
Regular Expressions in SQL Server 2025
Microsoft is introducing Regular Expression(regex) functions in its upcoming SQL Server 2025 to enable pattern-based searching and manipulation. […]
[Video] Office Hours at Sea
This Office Hours episode comes to you from Virgin Voyages’ newest cruise ship, the Brilliant Lady, sailing through […]
SQL ConstantCare® Population Report: Fall 2025
In this quarter’s update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions […]
The Version Store Won’t Clear If ANY Database Has Open ...
Short story: what the title says. This is especially problematic for folks who merge multiple databases onto the […]
Docker Advice for SQL Server in Production
Introduction Nowadays, with the widespread adoption of microservices across major companies, using Windows Server to host SQL Server […]
Managing Underused Indexes in SQL Server Availability Groups – Part ...
The post Managing Underused Indexes in SQL Server Availability Groups – Part 2 appeared first on SQLServerCentral.
How Implicit Transactions Hurt SQL Server Performance Without You Knowing
Introduction In the world of SQL Server performance troubleshooting, developers and DBAs often chase the usual suspects: bad […]
Query Plan Pop Quiz Answers 2 and 3: I’ve Got ...
In the Query Plan Pop Quiz, questions 2 and 3 asked you about what the sizes of arrows […]
How to Build an AI-Powered T-SQL Assistant with Python & ...
If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, […]
SQL EXISTS Use Cases and Examples
The post SQL EXISTS Use Cases and Examples appeared first on SQLServerCentral.
TempDB Filling Up? Try Resource Governor.
TempDB is one of the banes of my existence. Anybody, anybody who can query your server can run a […]
Database Ledger in SQL Server 2022
Protecting data from unauthorized access is a major challenge for organizations today. SQL Server 2022 introduces Database Ledger, […]
T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, ...
The post T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, and A PowerShell Script appeared first […]
Query Plans Pop Quiz Answer #1: Costs are Garbage.
In last week’s Query Plans Pop Quiz, the first question was, someone hands you these two queries and […]
Announcing the 2025 Black Friday and Doorbusters Deals!
You’ve been telling yourself, “One of these days, I’ll finally take Brent’s classes.” Get ready, because that day […]
Announcing Free MASTERING Week 2025!
You’ve been working with SQL Server, Azure SQL DB, or Amazon RDS SQL Server for years. You’re jaded. […]
Schema Design Basics for Power BI
The post Schema Design Basics for Power BI appeared first on SQLServerCentral.
Migrate SSRS Reports to a New Server in Just a ...
Managing SSRS report migrations can be a time-consuming and error-prone process, especially when dealing with large enterprise report […]
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
The post Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices appeared first on SQLServerCentral.