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 – Encrypting SQL Backups
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
Availability Groups and Redo Latency, Data Committed on a Primary isn’t Visible on a Synchronous Secondary
If you're running availability groups it may seem like a great idea to offload your read only reporting workloads to a secondary. There are a couple of ways that you could do that, you could use read only routing or simply just point those reports directly at a read only secondary (read only routing is... Continue Reading →
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 →
sp_LockDetails – Get Details of all Locks Taken Out Against a Database.
Be sure to get the latest version of this script from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox Have you ever wanted a quick and easy way to see who was holding (and waiting on) locks on a particular database? Perhaps you've got some blocking issues going on and you want to see exactly which rows the row level... Continue Reading →
