Handling Missing Instances when Looping with Pester

In my previous posts about writing your first Pester Test and looping through instances I described how you can start...

Using Common Table Expression (CTE) – Did you know…

Today I will write just a short blog post to do a quick reminder! I still hear a lot of...

SQL Server Data Tools 2017 and TFS Integration

I’ve blogged a while back on how SSIS 2017 was finally here. Not much has changed; there is still no...

Design Concepts For Better Power BI Reports – Part 2: Preattentive Attributes

Preattentive attributes are visual properties that we notice without using conscious effort to do so. Preattentive processes take place within 200ms...

Using Common Table Expression (CTE) - Did you know...

Today I will write just a short blog post to do a quick reminder!
I still hear a lot of people suggesting CTEs because they think it works like a...

Upgrading an expired SQL Server 2016 Evaluation Edition

It's happened to almost everyone. Someone installs Evaluation Edition and now you need to upgrade
it to a licensed copy using...

SSAS Tabular – Large Dimension Performance II

What are the limits?

What are the limits?
Of course, as a follow-up to my last article you might ask at least...

How to get started with Always Encrypted for Beginners Part 1

Encryption has always been intriguing to me but seemed like it could be a very complex process to set up....

Introducing SQL Operations Studio

Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...

Pluralsight for Another Year

One of the ways that I try to keep current and learn is through Pluralsight. I’m lucky to get a...