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 […]
Working with dates in SQL Server is something almost every developer runs into. You might need to figure […]
Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to […]
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 […]
We’re heading towards graduation time. In just a few short months, your high school kids are going to […]
The new JSON field type and new functions in Azure SQL brings a new world of possibilities […]
The post SQL Server Cursor Example appeared first on SQLServerCentral.
Are SQL Saturdays finally back to the way they should be? This past weekend in Jacksonville Florida […]
Is your company hiring for a database position as of May 2025? Do you wanna work with the […]
Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as […]
A while back, a friend of mine, who is big into baseball, tried to encourage me to […]
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
Introduction In modern database management, data synchronization plays a critical role in processes like data warehousing and ETL […]
I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability […]
The post Return stored procedure parameter values to a calling stored procedure appeared first on SQLServerCentral.
Introduction Many high-volume data sources, including sensors, logs from mobile applications, and the Internet of Things, operate in […]
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. […]
Purging data from a table is a common database maintenance task to prevent it from growing too […]
I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, […]
For yeeeeeears, when I’ve explained execution plans, part of my explanation has included the instructions, “Read the plan […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Introduction Meta AI from Facebook is one of the last big technology giants’ contenders in the AI battle. […]
The post Using try catch in SQL Server stored procedures appeared first on SQLServerCentral.
I wrote a piece on getting started with the Data API Builder (DAB), which looked at how this […]
On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer […]
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features […]
In the final part of this series, learn how to use SQL Server’s SELECT command to retrieve, filter, […]
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your […]
On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This […]
I preface a lot of what I write with whether or not it is for a “practical” […]
This is it! You’ve been watching my free live Spring Training classes over the last several weeks, and […]
This installment of our three-part series on SQL commands explores essential SQL commands for inserting, modifying, and deleting […]
Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]
On the weekend of April 5, 2025, I attended (and Redgate sponsored) SQL Saturday Richmond. Having lived […]
The post Using the Default Trace in SQL Server appeared first on SQLServerCentral.
If you’ve written SQL for a while, you’ve likely bumped into COALESCE and ISNULL. Both are handy for […]
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento. […]
This first installment of a three-part series introduces essential SQL commands for creating, modifying, and deleting tables within […]
The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational […]
First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside […]
As started in part 1 of this series, I have set out to test an LLMs ability […]
This is a short series on the Modern Data Platform in Microsoft Fabric. The articles in this series […]
The post Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments appeared first on SQLServerCentral.
To solve a complex business problem, one needs to break the process into smaller solvable steps. Today, we […]
Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you […]
It’s nothing new for vendors to find ways to lock in customers to their products and cloud […]
This quarter’s release contains a few advanced warnings & tools, like table input for sp_BlitzLock, new warnings about […]
I spend a lot of editing articles from various authors about a wide variety of topics. I […]
The post How to Remove Constraints from a SQL Server Table appeared first on SQLServerCentral.
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]