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

Containers: Upgrading SQL Server from 2017 to 2019 RTM

Throughout the pre-release of SQL Server 2019, I was demoing an effectively instant, and magical, container upgrade from 2017 to 2019. However, when I finally downloaded the release bits...

#PowershellBasics: Working with arrays

I mentioned arrays in a previous post so I figured I should talk about what they are and how to ... Continue reading

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

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

SQLSaturday Orlando Notes – Cupcakes & Ice Cream

For the past few years we’ve had a a local sponsor provide cupcakes as the “sweet treat”. We started with mid afternoon but found it worked well if we...

Cleaning up the [NOT] NULL for Columns with SQL Prompt 10

SQL Prompt 10 is out and there are a few interesting things that have changed in the product. One of these is the Quick Fixes, inspired by some other...

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