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: 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 →
@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 →
One of the most useful tools to the DBA when we need to test new features, recreate a fault that we've seen in production or just want to see 'what if...?' is a test lab. Other Posts In The Series Part Two, Creating a Domain Account and Joining a SQL Server to the Domain Part... Continue Reading →
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, I really hope that you found it useful 🙂
08 Jan 2018 - V1.1 released - Details here Most of the time the goto is to use the GUI which is a nice graphical way of doing it which can make configuring the settings somewhat easier , but this comes with a cost - the cost being time! I have lost count of the... Continue Reading →
Now I'm all for making my life easier and one thing that makes life easier for me is having a single process that I can run to install\update all my favourite utility stored procedures quickly and on all my SQL Servers. I've done this a few different ways in the past but this time I... Continue Reading →
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the World! In the red corner, we hate him, we loath him, I've even heard people say he should be deprecated, it's the Cursor!!! Facing him in the blue corner, loved on the forums, praised by... Continue Reading →
SQL Undercover 