Finding the Default Path with dbatools

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...

Implementing SSL for Your Blog

With the announcement of the recent security issues, namely Meltdown and Spectre, we at Denny Cherry & Associates Consulting have been...

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...

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...

Friday Reading 2018-01-19

It’s been absolutely freezing here in Dublin this week. Been spending pretty much all time wrapped up indoors reading…
Discussing PASS...

Faster

In the human history, there was a huge drive (such an ambiguous meaning here) to get faster.

Maybe within our DNA...

Template Explorer (Day 18)

You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...

Template Explorer (Day 18)

You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...

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...

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...