Summiting that Technical Challenge

Conquering Challenges

I really like the topic of the TSQLTuesday party today. Today we have been instructed in no uncertain terms...

Toolbox - Why is My Database So Big????

I have written previously (here)about how to tell which database files have free space in them when your drive starts...

tSQLt Tests for Advent of Code 2017 Day 4

This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start with...

Use Snippets in SSMS to insert blocks of code (Day 19)

Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...

Use Snippets in SSMS to insert blocks of code (Day 19)

Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...

What Does REPAIR_ALLOW_DATA_LOSS in SQL Server Signify?

REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL...

Advent of Code 2017 Day 4–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

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

Database Corruption and IO Errors

A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users...

Database Corruption and IO Errors

A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is...