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

I've been chosen to speak at SQL Saturday Guatemala

I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that...

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

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