[Video] Office Hours in Haines, Alaska: No Bears Here
While in beautiful Haines, Alaska along the Chilkoot River, I stopped to take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:26 James L: When you were an employee, how did you decide whether …
Microsoft Fabric et Google BigQuery
Dans le monde actuel axé sur les données, les organisations se retrouvent souvent avec d’énormes quantités de données dispersées sur de nombreuses platesformes. Ce paysage de données fragmentées pose des défis importants, car des informations pré …
Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star
The post Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star appeared first on SQLServerCentral.
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 …