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

I Want PASS to Survive

I want PASS to survive. I can say that unequivocally, because this organization has been a part of my career, my job, and my life for twenty years. Many...

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

Microsoft Ignite Announcements 2020

Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related...