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 →
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
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
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 →
In this episode of the podcast, Adrian looks at the scripting options available in SSMS. https://www.youtube.com/watch?v=0LAVuOaWj2g
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 →
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
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 →
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 →
