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.
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.
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 →
Inspector V2 changes Inspector V1.4 changes. Inspector V1.3 changes. Inspector V1.2 changes. Introducing: The SQLUndercover Inspector! now available on GitHub but what exactly is it? Just another Monitoring tool? well not quite, the SQLUndercover Inspector is not really a Monitoring tool as such, parts of the Inspector can be used in this way if you... Continue Reading →
@adedba Adrian Buckman has been working hard and has put all of our scripts up on Github https://github.com/SQLUndercover/UndercoverToolbox
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 →
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 →