Jacksonville SQL Saturday 2025 Roundup
Are SQL Saturdays finally back to the way they should be? This past weekend in Jacksonville Florida things sure felt like they are. There was an energy that comes with an event that matches just right to the space allocated, and that energy grows even …
Who’s Hiring in the Microsoft Data Platform Community? May 2025 Edition
Is your company hiring for a database position as of May 2025? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the …
MySQL Index Overviews: Hash Indexes
Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as well as walked you through B-tree indexes. MySQL, however, has many other index types it can offer for your use case, and one of those indexes …
Data-Based Movie Reviews: Moneyball
A while back, a friend of mine, who is big into baseball, tried to encourage me to watch the movie: Moneyball, which is based on the true story of Billy Beane. I generally enjoyed the film, and how it portrayed data for the most part. Since this movie …
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 60-90 minutes of my most popular classes for free this spring, and now it’s time for the Mastering classes. Tomorrow I’m covering Mastering Index Tuning. …
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 (Extract, Transform, Load). MERGE in SQL Server is designed to streamline this process by consolidating multiple operation …
Query Lineage in Fabric Lakehouses
I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability to track the queries back to a semantic model, report and visual in a report, identifying the query lineage. If you check the text of the que …
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 real time. As organizations have gotten better at capturing this data, they also want to process it in real time, wheth …
Announcing Our Anniversary Sale!
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. I couldn’t have imagined that decades later, the site would be home to: Over 3,500 blog posts with over 10,000 comments About 1,000 pages of content …
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 large or to stay in compliance with data retention. When dealing with small amounts of data, this can be accomplished by a simple delete with no issues; howe …
[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, and… it’s still pretty weird. Let’s go through your top-voted questions from https://pollgab.com/room/brento and have a laugh at my hot dog fingers. I …
SQL Server 2022 Finally Fixed a SQL Server 2008 Query Plan Bug!
For yeeeeeears, when I’ve explained execution plans, part of my explanation has included the instructions, “Read the plan from right to left, top to bottom, looking for the place where the estimates vs actuals are suddenly way off.” Here’s an example: …
Working with the MongoDB Database Tools
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. The MongoDB Database Tools are a set of command-line utilities for working with MongoDB instances and their data. You can use the …
Meta AI by Facebook: A New Contender in the AI Battle
Introduction Meta AI from Facebook is one of the last big technology giants’ contenders in the AI battle. In our first article, we created a demo about ChatGPT. Secondly, we talked about Bing from Microsoft, who is now Copilot. Thirdly, we mentioned Ba …