Microsoft Now Recommends You Set Max Memory to 75% and Min Memory to 0%.
Somehow I missed this a few years ago, and I bet a lot of y’all did too. Note the new “Recommended” column in the memory settings documentation: These recommendations are also set by the SQL Server 2022 setup wizard if you choose the recommended settin …
Side by Side Upgrade to SQL Server 2022
The post Side by Side Upgrade to SQL Server 2022 appeared first on SQLServerCentral.
Announcing Free Fundamentals Week 2025!
You’re a developer, analyst, database administrator, or anybody else working with SQL Server, Azure SQL DB, or Amazon RDS SQL Server. You want to learn how to make your databases go faster. Good news! In October 13-16, I’m teaching totally free half-da …
How Well Does the MSSQL Extension in VSCode Work?
With the retirement of ADS, I decided to take a look at the MSSQL extension for VSCode. This is an alternative to using SSMS for development work. This extension was updated in the fall of 2024, but I hadn’t had a reason to use it. I mostly use SSMS, a …
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.