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 →
Page Updated: 22/12/2019 Current changes:Inspector V2 changesPrevious 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? The All new Inspector gives you the power to Create, configure and schedule SQL modules, control when modules execute and control when reports are produced/emailed. It's... 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 →