In our Christmas Special, David picks his top 5 features of Azure Data Studio. https://youtu.be/-7rF_g2v-rI
SQL Undercover TV Christmas Special – David’s Top 5 Azure Data Studio Features
Troubleshooting Resource Semaphore and Memory Grants
Memory grants, now here's a fun thing that can pretty much take your SQL Server to its knees. The Symptoms The first thing that you're going to notice is that your SQL Server is going to be running slowly and I mean, slooooooow! When I've got a server on a serious go slow, the first... Continue Reading →
Inspector V2.00 now available
The SQL Installation file can be found here.The new Powershell installer can be found here.If you are running the powershell collection you will need to grab the latest revision.The latest powerBI template can be found here.As more features are documented they will be updated on the Inspector V2 page. New Features Schedule report windows and... Continue Reading →
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup files https://www.youtube.com/watch?v=Q0UdX04fHQo&feature=youtu.be
SQL Undercover TV – Using Excel to Visualise SQL Performance Data
Adrian looks at how you can use Excel to visualise SQL performance data, specifically data collected by the Blitz First Responder Kit https://www.youtube.com/watch?v=63HkWalXdRk
Getting table row counts with sp_Tablecount
Sometimes you just want to get a quick row count for a specific table - other times you may want to see a list of tables order by size or row count or perhaps you are monitoring table row counts, whatever it is the chances are you have a script or various scripts stashed away... Continue Reading →
Finding the Primary Replica of an Availability Group
This is going to be a bit of a quick post but one about something that I see coming up time and time again on SQL Undercover's search terms. How do I find an availability group's primary server? A while back, Adrian put together a bunch of queries for Always On Availability Groups, 7 ways... Continue Reading →
Undercover TV Podcast – Scripting Options in SSMS
In this episode of the podcast, Adrian looks at the scripting options available in SSMS. https://www.youtube.com/watch?v=0LAVuOaWj2g
Undercover TV Podcast – Intent Locks
The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is. https://www.youtube.com/watch?v=44vNrHJR984
We Thought That Sean McCown’s SMO Tutorial Was So Good, It Needed To Be A Video In It’s Own Right
Back in February, Sean McCown joined us on the Undercover podcast and presented a brilliant tutorial on the SMO. We thought that it was so good that we've decided to make it into a video in it's own right. https://www.youtube.com/watch?v=v3rk8wTmkVY The podcasts are going to be revived very soon with a whole new format and... Continue Reading →
SQL Undercover 