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 […]
Archives du mois : novembre 2025
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, […]
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 […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.
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 […]