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 …
Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes
The post Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes appeared first on SQLServerCentral.
TRY/CATCH Doesn’t Always Work.
If you’re using TRY/CATCH to do exception handling in T-SQL, you need to be aware that there are a lot of things it doesn’t catch. Here’s a quick example. Let’s set up two tables – bookmarks, and a process log to track whe …
Simple Talks at the PASS Summit
This year at Simple Talk has been exciting, after a slow start with me being more or less out for a few months. We have made changes to the website, which are still being evolved. We have started a podcast and as of this writing, we have 6 posted episo …
Rounding Numbers
I would hope by now everybody has figured out when you see a price like $39.99 that it might as well be forty bucks. Dropping that penny from the price is done is to fool the consumer! Since we read numbers left to right, the merchant hopes you will se …