Bad Idea Cowboy Hat: BEGIN TRANSACTION; GO 1000;

One of my favorite presentations is Revenge the SQL by Rob Volk (blog|twitter). It’s a demonstration of a lot of ... Continue reading

How Serverless is Working in Azure SQL Database

When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...

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

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

Install ALL Things SQL Server… What?

Does your server look like this? Many of us have inherited a SQL Server instance that has all SQL Services installed. Someone, maybe even you, went through the SQL...

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

When a SQL UPDATE Statement DELETES Rows

Watch this week’s episode 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...

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