Revisiting SQL Server Window Functions- A Practical Walkthrough
Introduction Sometimes we just want SQL to be a bit smarter. Maybe we need to figure out who’s performing best in a team, find someone’s very first sale, or compare today’s numbers with yesterday’s. We might want to group customers into spending tiers, …
[Video] Office Hours on the Beach in Cancun
In retrospect, I should have put on sunscreen – even for just a 20-minute Office Hours session on the beach! Dang, that sun is powerful. Let’s go through your top-voted questions from https://pollgab.com/room/brento. This is a 360-degree video, so if y …
A Rolling Filtered Index in SQL Server
The post A Rolling Filtered Index in SQL Server appeared first on SQLServerCentral.
Home Office Studio Tour
Ever wonder what it takes to do this stuff behind the scenes? I’ll show you. If you’re thinking about getting started with live streaming or training videos, don’t be intimidated by this setup. There’s a lot of gear involved, but it’s because I’ve been …
A Tribute to Andrew Clarke (a.k.a. Phil Factor)
We are deeply saddened to share the news that Andrew Clarke, better known to Simple-Talk readers as Phil Factor, recently passed away. He was the site’s editor for several years and continued writing for Redgate long after. Many readers will have learn …
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Introduction In this example, we will show patterns between items stored in SQL Server using Python. We will use the FP-Growth algorithm to find common elements in the data that appear together in the transactions. For example, if we go to the supermar …
SQL Server Triggers for Business Rules Automation
The post SQL Server Triggers for Business Rules Automation appeared first on SQLServerCentral.
Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric
When you create a semantic model in Power BI desktop, you typically connect to one or more data sources (regardless of which mode you use, Import or DirectQuery). And naturally, you need to authenticate against those sources. In Power BI Desktop, you c …
[Video] Office Hours Back at Home in Vegas
I’m back in Vegas, at least for the moment, so let’s hang out in my home office and talk through your top-voted questions from https://pollgab.com/room/brento. There’s a lot of good questions this week! Here’s what we covered: 00:00 Start 02:26 Eric M: …
Who’s Hiring in the Microsoft Database Community? September 2025 Edition
Is your company hiring for a database position as of September 2025? Do you wanna work with the kinds of people who read this blog? Let’s make a love connection. If your company is hiring, leave a comment. The rules: Your comment must include the job t …
Free Live SQL Server Classes This Month!
This month, I’m teaching two of my classes live, online, completely free! These are the two fundamentals classes that I think everybody should start with, regardless of their experience with SQL Server or Azure SQL DB. I’ll teach you the most important …
Picking the ON or WHERE Clause for the SQL Predicate
The post Picking the ON or WHERE Clause for the SQL Predicate appeared first on SQLServerCentral.
What is Delayed Durability in SQL Server — And Should You Turn It On?
Introduction When SQL Server commits a transaction, it doesn’t just update data in memory. It also writes a record to the transaction log on disk. Only after this log is flushed does SQL Server confirm the commit to the client. This extra step ensures …
DevOps vs. SRE: Bridging the Gap, Not Building Walls
The post DevOps vs. SRE: Bridging the Gap, Not Building Walls appeared first on SQLServerCentral.
[Video] Office Hours in Icy Strait Point, Alaska
For the last couple of months, I’ve been trying to get my on-location Office Hours episodes filmed with an Insta360 so you can pan the camera around to see the sights. Folks, I’ve finally pulled it off! You can move the camera around with your clicker: …