Docker Containers and Persistent Data

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...

Is it true that editing a single row in Management Studio empties and reloads the entire table?

TL;DR: No. A customer recently brought up an interesting thesis, that if you edit a table’s values using SQL Server Management Studio (SSMS) using the edit feature, that the...

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