Opening your SQL Backup Folder using Powershell

Sometimes I find remembering where a particular server sends its backups to a nightmare. You might have servers backing up to different locations, you might have different locations for individual databases and different locations for your fulls, diffs and logs. You might be trying to get your head around a customer's set up, where the... Continue Reading →

Which Processes are waiting on a Spinlock?

Spinlock contention is always a real headache to deal with. I recently saw an issue when spinlock contention on SOS_CACHESTORE was making the server virtually unresponsive. The issue was very intermittent with no obvious pattern but the assumption is that it was caused by a particular process in the application. Finding what that process was... Continue Reading →

Generate a Random Number for Each Row in a Query {a better way}

A couple of years ago I wrote a post on how to generate a random number in SQL Server. https://sqlundercover.com/2017/06/22/generating-random-numbers-for-each-row-over-a-specified-range-and-other-funky-stuff-you-can-do-with-them/ It's ok and it works, it's also a method that I used for quite a while. Why not use RAND() I've heard people say, well the issue with RAND() is that it will generate the... Continue Reading →

Create a website or blog at WordPress.com

Up ↑