Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and ...
Working with dates in SQL Server is something almost every developer runs into. You might need to figure […]
Sites anglophones
Real-time Data Streaming in Snowflake
Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to […]
[Video] Office Hours: Speed Round!
Not all of y’all’s questions from https://pollgab.com/room/brento require long, thought-out answers. Let’s do a speed round: Here’s what […]
Don’t Let Your Kids Drop ACID.
We’re heading towards graduation time. In just a few short months, your high school kids are going to […]
Techniques to query Azure SQL’s new JSON Datatype
The new JSON field type and new functions in Azure SQL brings a new world of possibilities […]
SQL Server Cursor Example
The post SQL Server Cursor Example appeared first on SQLServerCentral.
Jacksonville SQL Saturday 2025 Roundup
Are SQL Saturdays finally back to the way they should be? This past weekend in Jacksonville Florida […]
Who’s Hiring in the Microsoft Data Platform Community? May 2025 ...
Is your company hiring for a database position as of May 2025? Do you wanna work with the […]
MySQL Index Overviews: Hash Indexes
Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as […]
Data-Based Movie Reviews: Moneyball
A while back, a friend of mine, who is big into baseball, tried to encourage me to […]
Free Webcast Tomorrow: Mastering Index Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
Understanding MERGE to Insert, Update, and Delete Data Simultaneously
Introduction In modern database management, data synchronization plays a critical role in processes like data warehousing and ETL […]
Query Lineage in Fabric Lakehouses
I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability […]
Return stored procedure parameter values to a calling stored procedure
The post Return stored procedure parameter values to a calling stored procedure appeared first on SQLServerCentral.
Modern Streaming Architecture Serverless Pool with Spark Streaming
Introduction Many high-volume data sources, including sensors, logs from mobile applications, and the Internet of Things, operate in […]
Announcing Our Anniversary Sale!
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. […]
Purging Data from a Large Table in SQL Server
Purging data from a table is a common database maintenance task to prevent it from growing too […]
[Video] Office Hours: Hot Dog Fingers Edition
I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, […]
SQL Server 2022 Finally Fixed a SQL Server 2008 Query ...
For yeeeeeears, when I’ve explained execution plans, part of my explanation has included the instructions, “Read the plan […]
Working with the MongoDB Database Tools
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Meta AI by Facebook: A New Contender in the AI ...
Introduction Meta AI from Facebook is one of the last big technology giants’ contenders in the AI battle. […]
Using try catch in SQL Server stored procedures
The post Using try catch in SQL Server stored procedures appeared first on SQLServerCentral.
Retrieving Data Using the REST API in Data API Builder
I wrote a piece on getting started with the Data API Builder (DAB), which looked at how this […]
[Video] Office Hours: Hello Kitty Porsche Edition
On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer […]
How to Load a Date Dimension in Microsoft Fabric using ...
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features […]
Introduction to SQL Commands, Part 3: Retrieving and Sorting Data
In the final part of this series, learn how to use SQL Server’s SELECT command to retrieve, filter, […]
Using the CASE expression instead of dynamic SQL in SQL ...
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
Building AI Calls into the First Responder Kit
No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your […]
Sponsoring PGDay Chicago this week
On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This […]
Exploring the SQL Server CHOOSE Function
I preface a lot of what I write with whether or not it is for a “practical” […]
It’s Time for Fundamentals Week! Register for Tomorrow’s Classes.
This is it! You’ve been watching my free live Spring Training classes over the last several weeks, and […]
Introduction to SQL Commands, Part 2: Adding, Updating Data
This installment of our three-part series on SQL commands explores essential SQL commands for inserting, modifying, and deleting […]
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]
SQL Saturday Richmond Roundup
On the weekend of April 5, 2025, I attended (and Redgate sponsored) SQL Saturday Richmond. Having lived […]
Using the Default Trace in SQL Server
The post Using the Default Trace in SQL Server appeared first on SQLServerCentral.
The Subtle Differences Between COALESCE and ISNULL
If you’ve written SQL for a while, you’ve likely bumped into COALESCE and ISNULL. Both are handy for […]
[Video] Office Hours in the Home Bar
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento. […]
An Introduction to SQL Commands, Part 1
This first installment of a three-part series introduces essential SQL commands for creating, modifying, and deleting tables within […]
A Method for Managing Hierarchies in PostgreSQL
The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational […]
Your SQL Server Needs Spring Cleaning, Too.
First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside […]
LLM Technical Editor Test – ChatGPT with a VERY wrong ...
As started in part 1 of this series, I have set out to test an LLMs ability […]
The Fabric Modern Data Platform
This is a short series on the Modern Data Platform in Microsoft Fabric. The articles in this series […]
Securing the DevOps Pipeline Part 1: Tools and Strategies for ...
The post Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments appeared first on SQLServerCentral.
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
To solve a complex business problem, one needs to break the process into smaller solvable steps. Today, we […]
Announcing Database Frontiers: a Database Conference You Haven’t Yet Heard ...
Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you […]
Oracle’s Limited Cloud Vendor Licensing
It’s nothing new for vendors to find ways to lock in customers to their products and cloud […]
Updated First Responder Kit and Consultant Toolkit for April 2025
This quarter’s release contains a few advanced warnings & tools, like table input for sp_BlitzLock, new warnings about […]
New Series – Testing LLMs as Technical Editors
I spend a lot of editing articles from various authors about a wide variety of topics. I […]
How to Remove Constraints from a SQL Server Table
The post How to Remove Constraints from a SQL Server Table appeared first on SQLServerCentral.
Creating a Date Dimension (Calendar Table) in SQL Server
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]