How to Delete Large Amounts of Data in Microsoft SQL Server
Deleting large volumes of data in Microsoft SQL Server can be a challenging task. If not done correctly, it can lead to performance issues, excessive log growth, and even system outages. This article explores various techniques and best practices for e …
[Video] Office Hours: Icy Strait Point, Alaska
I’m on a boat! We took an Alaska cruise with some friends aboard the Norwegian Jewel. En route to Icy Strait Point, Alaska, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:40 Roll …
Why customers love SQL Prompt
The post Why customers love SQL Prompt appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? October 2024 Edition
Is your company hiring for a database position as of October 2024? 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 in …
Announcing the Winners of the Biggest Database Regret Contest
I recently asked you to leave a comment with your biggest database regret, and the comments were great! Here were my favorites: Runners-Up These 5 folks each won a Fundamentals Bundle lifetime access valued at $695: Thirster42: writing code to help a t …
Exploring Time Travel and Row Level Concurrency: Data Engineering with Fabric
The Delta file format supports ACID properties by storing data in parquet files and actions in JSON files. This storage format allows the developer to time travel to a given version number or timestamp. However, it means the files keep on growing unt …
Casino night is back at PASS Summit 2024!
The post Casino night is back at PASS Summit 2024! appeared first on SQLServerCentral.
The 2024 Black Friday Sale is Coming Next Month.
Your accounting office Every year during November, we run a big sale all month long. And every year, right after the sale ends, we get a bunch of panicked emails from people screaming, “I HAD NO IDEA YOU WERE RUNNING A SALE, I NEED MORE TIME, YOU …
SQL Index Rebuild vs Reorganize Comparison
The post SQL Index Rebuild vs Reorganize Comparison appeared first on SQLServerCentral.
Converting Old Running Total Code to Window Functions
I ran across an article that showed calculating a running total with a twist. In this case, the total is the sum of the previous 5 rows. I decided this could be done more efficiently by converting the code to a more modern, window function approach. Th …
[Video] Office Hours: Open Q&A on Microsoft Databases
I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying. Here’s what we covered: 00:00 Start 01:00 VegasDBA: Loved the Always-On Availability Group Episode! You mentioned how awful the d …
Diving Deeper into the Import Extension in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, and this one continues the series, taking a deeper look at the Import extension. The other articles in this series on ADS works …
The PASS Data Community Summit Session Schedule is LIVE!
The post The PASS Data Community Summit Session Schedule is LIVE! appeared first on SQLServerCentral.
Free Webcast: How to Think Like the Engine, Big Data Edition
Brent, Big Coat Edition You’ve watched my free How to Think Like the Engine class that focuses on the small 1GB Users table. Let’s take things up a notch by using the ~164GB Posts table full of questions & answers. You’ll learn: W …
Yes, Cardinality Estimation Keeps Changing After SQL Server 2014.
About 10 years ago, Microsoft made changes to the Cardinality Estimator (CE) which caused some problems for SQL Server upgrades. When folks upgraded to SQL Server 2014, they also casually switched their databases’ compatibility level to the lates …