My Git CLI Cheat Sheet

I created a cheat sheet for the Git Command Line Interface to go along with my Git tutorial for SQL Change Automation video. I find the Git CLI to...

PASS Summit 2019 Wrap-Up

I’m home from PASS Summit 2019, recovered from the travel, and in the post-Summit “I miss #SQLFamily” funk. Time to recap the week, maybe a bit differently than it’s...

Using Visual Studio Code

I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...

Business Mum of the Year Finalist 2019

Here at gethynellis.com we are proud to announce that our Operations Director Sabrina Ellis is a finalist for the Business Mum of the Year award, taking place on Wednesday...

Business Mum of the Year Finalist 2019

Here at gethynellis.com we are proud to announce that our Operations Director Sabrina Ellis is a finalist for the Business Mum of the Year award, taking place on Wednesday...

Fixing the ‘Failed to generate the compressed file for module ‘C:Program Filesdotnetdotnet.exe’ error when deploying to the PowerShell Gallery using Azure DevOps

The PowerShell module for validating your SQL Server estate dbachecks is deployed via Azure DevOps, you can see how it is working (or not) via this link

Grrr Automation for...

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

If your organization uses a password policy (there are very good odds these days that it does) and, especially stricter password requirement for administrative users, your might have experienced...

How to Fix SQL Database Logical Consistency Based I/O Error

There can be several reasons that cause Database Logical Consistency based I/O error:
Unexpected system shutdown/crash or forced shutdown 
SQL administrator tries to query or modify SQL data

In both the circumstances,...

SQL Undercover TV – Encrypting SQL Backups

In this episode, David looks at how we can encrypt our SQL Server backup files

When a SQL UPDATE Statement DELETES Rows

Watch this week's video on YouTube
At first I wasn't going to write this post. I thought it would be too simple.
Then I watched two experienced SQL developers go through...