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

Exporting Environment Variables out of the SSIS Catalog

Sometimes when you’ve created a SSIS catalog, along with folders, environments and environment variables, you want this content on another server. Unfortunately, you can only script out these objects...

New Presentation - The SQLFamily

A couple months ago I delivered a short (15 minute) presentation at work about the importance of having a good professional network and how I’d found mine. As I...

Getting Your Employer to Pay for the PASS Summit

It’s just over 30 days to the 2020 PASS Summit and that is plenty of time to get the boss to say yes, but you have to ask! I...

A Database Playlist for Your Mom

Recently someone asked me if I had a video explaining what a database was. I didn’t, but was curious. Apparently, this person wanted to learn a bit about databases...

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

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

Configure Windows Server 2019 Parent VHD - Part 6

VMworld 2020 SQL Server Session Open Q&A – Oct 15

If you were fortunate enough to catch our VMworld 2020 conference session on architecting SQL Server performance for hybrid cloud architectures, you’ll notice that there were no opportunities for...