Azure SQL Championship

There is no doubt that this is a time when we all have to be extra aware and work towards keeping our skills aligned with market needs. During this...

Checking your dumps!!!

No, No, not those dumps:  SQL Server Memory dumps!! Recently, I was on Slack and wondered into the #firstresponderkit channel. I am a big fan of all the First...

Daily Coping 13 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

T-SQL Tuesday #131 – Database Analogies

This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...

Daily Coping 12 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Renaming SQL Server Databases

Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh.  Most commonly when moving a copy from prod to dev. My Pluralsight courses for new...

Row Numbers in Azure Data Factory Data Flows

(2020-Oct-05) Adding a row number to your dataset could a trivial task. Both ANSI and Spark SQL have the row_number() window function that can enrich your data with a unique...

Video–Virtual Summit Speaker Portal

There’s a lot of stress in prepping for conferences and talks. I’m used to it, but whenever something is new, I get a little nervous. How are the AV...

Create HyperV VMs for Database server - Part 9

Setup Windows Server 2019 Domain Controller - Part 8