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

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

Building an Azure Sandbox – Part 1 – The Basics

I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...

Building an Azure Sandbox – Part 1 – The Basics

I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...

Building an Azure Sandbox – Part 1 – The Basics

I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...

Monday Morning Module Maintenance Monoliners

Or: Andy Authors An Amazing Alliteration
Do enough work with PowerShell and you’ll build up a decent collection of modules installed from the gallery into either your computer or your...