Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples
The post Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples appeared first on SQLServerCentral.
Set MAXDOP in Azure SQL DB or You’ll Get This Cryptic Error.
Max Degrees of Parallelism (MAXDOP) tells the database engine, “If you decide to parallelize a query, go parallel with this many worker threads.” (It’s a little more complex than that – there is also a coordinating thread, plus a single plan might have …
Memories of Andrew Clarke, by Simon Galbraith
Simon Galbraith is the co-founder of Redgate and one of the creators of Simple Talk. Here, he pays tribute to Andrew Clarke. You can also read Tony Davis’ memories of Andrew here. His eyes have been darting towards the door sporadically since I bumped …
Here Are the YouTube Channels We Both Loved.
Last week, I announced that we’ve hit 50,000 YouTube subscribers, and I celebrated by letting y’all submit your favorite YouTube channels in the comments, and 5 of you would win my Fundamentals & Mastering Class Bundle. You did not disappoint. Firs …
Building a Dynamic Countdown Timer in Power BI
The post Building a Dynamic Countdown Timer in Power BI appeared first on SQLServerCentral.
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 …