Here's a strange one that I've recently come across. I had a customer report that their log shipping restore jobs were chock a block of errors. Now, the logs seem to have been restoring just fine but before every restore attempt, the job is reporting the error, Error: Failed to update database "DATABASE NAME" because... Continue Reading →
Getting started with the SQLUndercover Inspector
Post Updated: 23/07/2021 Here is a quick guide to getting started with the SQLUndercover Inspector. So you have ran through the installation of the Inspector and now you want to know what to do next, below we will guide you through some of the key steps to get you started and following on from that... Continue Reading →
T-SQL Tuesday #99 : Getting Decked Out in Rubber and Lycra, My Non-techy Passion #TSQL2sday
So this month's T-SQL Tuesday invitation comes from Aaron Bertrand. It's a non-technical post this month as he asks us to write about a non-SQL or tech related passion. For me, my passion is Triathlon. I first got hooked on the sport back in around 1998 when I got into it as a way of... Continue Reading →
The SQLUndercover Inspector is now available!
Updated: 28/11/2018: We've put together a sample report for you to play with. The SQLUndercover Inspector is now available on GitHub, a quick run down of what it does can be found here: Introducing: The SQLUndercover Inspector, a quick video introduction can be found here and upcoming video tutorials will be released on Undercover TV... Continue Reading →
sp_AGReconfigure 1.1 is now available
sp_AGReconfigure 1.1 is now available HERE and on GitHub V1.1 includes a new Parameter and some minor bug fixes: @Readable NULL - DEFAULT: Ignore Readable secondary check (acts as though you are using V1) 0 - Produce a statement to switch readable secondary off if switched on 1 - Produce a statement to switch readable... Continue Reading →
UNDERCOVER TOOLBOX: Get Details of All Open Transactions
It was 3am in the morning and I was asleep and enjoying a delightful dream (I knew it was a dream because I was surrounded by drifting clouds, singing angels and hundreds of softly humming SQL Servers where the hardware had been sensibly provisioned and all code carefully optimised) when I was rudely awoken by... Continue Reading →
Undercover TV – We’ve got a YouTube channel!
We've now got ourselves a shiny new YouTube channel at UndercoverTV. We'll be using this to host our monthly podcasts as well as the occasional tutorial video and anything else that we might decide to throw together, so pop over there, subscribe and watch out for new content as it gets added. A link can also... Continue Reading →