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+ […]
Archives de l’année : 2025
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, […]
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 […]
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 […]
Innovation spotlight: How 3 customers are driving change with migration ...
Organizations are under constant pressure to modernize their estate. Legacy infrastructure, manual processes, and increasing data volumes in […]
Database Ledger in SQL Server 2022
Protecting data from unauthorized access is a major challenge for organizations today. SQL Server 2022 introduces Database Ledger, […]
Fonction de conversion spatiale OGC vers GeoJSON pour SQL Server
Avec l’arrivée de SQL Server 2025 et son type JSON — ce n’est plus un simple « texte », mais bien […]
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.
Distributed Availability Group Health: T-SQL and Zabbix
After creating a distributed availability group using the steps described in my article, SQL Server 2022 Clusterless Distributed […]
Updated First Responder Kit and Consultant Toolkit for October 2025
This quarter’s release includes new checks for SQL Server 2025’s new memory pressure warnings, Azure SQL DB’s operations […]
Use SQL to Find a String in Database Tables, Stored ...
The post Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions appeared […]
Query Plans Pop Quiz: Three Simple Questions
Question 1: Pick the Problematic Plan: someone hands you a pair of queries, and you get the estimated […]
Free Fundamentals Classes Are Coming Next Week! Register Now.
You’re a developer, analyst, database administrator, or anybody else working with SQL Server, Azure SQL DB, or Amazon […]
Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, […]
Natural Language Query for SQL Server
The post Natural Language Query for SQL Server appeared first on SQLServerCentral.