How to Use SQL Server Features to Cut Web App Latency in Half
A customer taps “Buy Now” on your web app. Half a second passes. The screen hesitates before the confirmation appears. To the customer, it feels like a small delay. To your business, that hesitation can mean an abandoned cart, a lost sale, and at scale …
Power BI TMDL View: Benefits, Security Risks & Best Practices
The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.
Building a Simple SQL/AI Environment
Al is everywhere….almost. In my day-to-day role as a DBA, I don’t really have the opportunity or need to use AI in any meaningful way. I don’t need it to write code for me, or explain how SQL Server works. My AI use is limited to the summaries return …
We Hit 50,000 YouTube Subscribers! Let’s Run a Contest.
This is kinda amazing to me: our YouTube channel has broken the 50,000 subscriber mark! That’s wild to me because I don’t put “please like and subscribe” type stuff in the videos, and I don’t try to build viral content. I just show up every week and pu …
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. …