SQL Server Wait Stats
Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...
2025-04-16
19 reads
Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...
2025-04-16
19 reads
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access to Lakehouses, SQL Endpoints, or Semantic Models.
2025-04-16 (first published: 2025-04-03)
326 reads
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data platform. This platform integrates various data sources into a single, cohesive system. This integration breaks...
2025-04-16 (first published: 2025-04-03)
269 reads
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best way). It was incredible to see so many folks in Redmond for the MVP Summit,...
2025-04-15
6 reads
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This comes off of the back of my last post looking at using a distributed availability...
2025-04-14 (first published: 2025-04-01)
240 reads
We value your privacy. This policy explains what personal data we collect and why.
What We Collect
Cookies (for analytics, only after consent)
IP addresses (stored anonymously by our hosting provider)
Contact form...
2025-04-14
4 reads
Does skipping a DBA save money? Wait until your system grinds to a halt, your backups fail, or your cloud bill skyrockets. The “DBA? We Don’t Need No Stinkin’...
2025-04-14 (first published: 2025-04-02)
519 reads
When in doubt, overtip – from Excellent Advice for Living This is close to my heart, since I spent a lot of time in college and after working as...
2025-04-11
9 reads
A while back I wrote about using AI to explore why people are not using Extended Events. You can read all about it here, but a short summary of...
2025-04-11 (first published: 2025-03-31)
270 reads
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and Cross Fitters, we tend to be shy and withdrawn about our predilections. BWA-HA-HA! Ok, like...
2025-04-11
10 reads
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
We value your privacy. This policy explains what personal data we collect and why. What...
Why would using variables in place of hard coded numbers impact a query's performance? ...
Hello SSC! I have been tasked with optimizing a stored procedure the imports data...
Hey everyone, I'm trying to access an XML file download from a government website...
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers