Parent – Child Task Automation in Snowflake via Task Graph
In the fast-paced world of business, fast, effective data management is crucial. One of the places where […]
Archives du mois : mai 2025
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 […]
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 […]