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...

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...

sp_RestoreScript 1.2 is now available

sp_RestoreScript 1.2 is now available HERE and on GitHub
Changes include Service Broker options and the ability to restore a database in...

SQL Undercover Podcast – Feb 2018

The first SQL Undercover podcast where Adrian introduces the Undercover Inspector, David releases sp_restorescript 1.2 along with a bit of...

Creating a SQL Server Test Lab On Your Workstation – Part Three, Creating a Windows Failover Cluster and a SQL Server Availability Group

Welcome along to the third part of our series ‘Creating a SQL Server Test Lab On Your Workstation’.  If you’ve...

Introducing: The SQLUndercover Inspector

Introducing: The SQLUndercover Inspector! Finally we have a V1 almost ready to hit our GitHub but what exactly is it?
 

Just another...

All Scripts Now On Github

@adedba Adrian Buckman has been working hard and has put all of our scripts up on Github https://github.com/SQLUndercover/UndercoverToolbox

Dissecting SQL Server, The Internal Structure of a Row

I’m sure that most of us know that SQL Server stores all it’s data in 8Kb pages.  But what do...

Creating a SQL Server Test Lab On Your Workstation – Part Two, Creating a Domain Account and Joining a SQL Server to the Domain

In the second part of our series on creating a SQL Server test lab on your workstation, I’m going to...

Creating a SQL Server Test Lab On Your Workstation – Part One, Installing The Domain Controller

One of the most useful tools to the DBA when we need to test new features, recreate a fault that...