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

Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2

Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is Adaptive Joins.Before we start Adaptive Joins, SQL Server's Query...

Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2

Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is Adaptive Joins.Before we start Adaptive Joins, SQL Server's Query...

SQL Puzzle – Word Scrambler

I’ve been writing crosswords for the last few months and to change things up I thought I would do a...

The One Piece of Career Advice I Wish I’d Gotten

Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started...

Server Roles and Azure Active Directory in an Azure SQL Database

This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login...

Checking SQL Configuration with Pester & Dbatools

I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing...