Getting Started with Bayesian Modeling
The post Getting Started with Bayesian Modeling appeared first on SQLServerCentral.
Build a Test Lab of SQL Server 2025 on Windows Server 2025 using Hyper-V Virtual Machines
Problem Now that public preview of SQL Server 2025 CTP 2.1 is out (Community Technical Preview), you have desire to test it in a lab. But don’t know where and how to start. You might think that Azure is the only place where it can be tested, or that yo …
[Video] Office Hours: Database Questions & Answers
In between clients, I hopped onto my Twitch channel to take your top-voted questions from https://pollgab.com/room/brento. If you’d like to get notified whenever I do one of those live streams, you can follow my channel for free and you’ll get email no …
Your Developers Need Cheap SQL Training.
Your developers haven’t ever been to formal Microsoft database training on SQL Server or Azure SQL DB. They’re struggling with trying to tune queries and indexes. Your apps keep getting slower as the data grows, and your queries keep getting more compl …
SQL Server 2025 Makes Memory Troubleshooting Easier.
SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots like Copilot to know if the SQL Server has been under memory pressure recently. To show how it works, let’s run a bunch of simultan …
Free Webcasts Tomorrow & Wednesday
I’m teaching my two most important 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 …
Parameter Sensitive Plan Optimization in SQL Server 2022
SQL Server 2022 has lot of improved and advanced features compared to its predecessor versions. This includes new Server roles, improved Query Store, TempDB performance, Intelligent Query Processing, Contained Availability Groups, Database Ledger, etc. …
Configure SQL Server Alerts for Azure SQL Managed Instance
The post Configure SQL Server Alerts for Azure SQL Managed Instance appeared first on SQLServerCentral.
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.