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

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

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

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

UNDERCOVER TOOLBOX: sp_AGReconfigure – Manage Always on Sync & Failover settings from a single stored procedure.

From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes...

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

GroupBy Slides and Demo Script is Now On GitHub

The slides and demo scripts from today’s GroupBy session are now available on our GitHub repository
https://github.com/SQLUndercover/UndercoverToolbox/tree/master/GroupBy
Many thanks again for watching,...

Using PowerShell To Deploy Scripts From GitHub to Multiple SQL Servers

Now I’m all for making my life easier and one thing that makes life easier for me is having a...

SQL Smackdown!!! Cursors VS Loops

Ladies and Gentlemen, welcome to the main event of the evening.  The SQL Undercover Smackdown Heavy Weight Championship of the...