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

Assuming Good Intentions

With all the stuff going on around the world over the last year, maintaining some degree of mental stability can be quite a challenge. Speaking only for myself, while...

Daily Coping 9 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...