sp_RestoreScript 1.2 is now available HERE and on GitHub Changes include Service Broker options and the ability to restore a database in stand by, along with a couple of bug fixes.
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 nonsense chit chat.
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 followed along with the first two parts, you should have a domain setup and a SQL Server joined to it. In this part, we're going to look at building a cluster and creating an Availability... Continue Reading →
Introducing: The SQLUndercover Inspector
Page Updated: 23/07/2021 Current changes:Inspector V2.6 changes (including V2.5)Previous changes: Inspector V2.4 changesInspector V2.3 changesInspector V2.2 changesInspector V2.1 changesInspector V2 changesInspector V1.4 changes. Inspector V1.3 changes.Inspector V1.2 changes.Custom modules:BlitzWaitsBlitzFileStatsCPU Introducing: The SQLUndercover Inspector! now available on GitHub but what exactly is it? The All new Inspector gives you the power to Create, configure and schedule... Continue Reading →
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 these pages actually look like and how can we go about looking at them and picking them apart. For this we're going to need a couple of undocumented DBCC commands, DBCC page and DBCC ind.... Continue Reading →
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 look at creating a domain user, joining a SQL Server to our domain and connecting to that server using our domain account. Other Posts in the Series Part One, Installing The Domain Controller Part Three,... Continue Reading →