Is It Possible To Conditionally Index JSON Data?

Watch this week's video on YouTube
Recently I received a great question from an attendee to one of my sessions on JSON (what's up Nam!):

At first glance it sounds like...

PoshSSDTBuildDeploy Updated - Now With Install .NET!

Hello!
I’m currently working on a project that requires building and deploying SSDT-based projects. So it’s been a great opportunity of making use of PoshSSDTBuildDeploy and work through any issues....

Power BI Custom Visuals Class (Module 99 – Drill-Down Donut Chart

In this module you will learn how to use the Drill-Down Donut Chart. The Drill-Down Donut Chart allows you to...

Ready for Houston Tech Fest 2018

Houston Tech Fest is this weekend!In 2016, there was a wedding. In 2017, rescheduled at the last minute because of Harvey, I couldn't reschedule. But prior to 2016, I...

Rotating encryption keys for Always Encrypted

In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...

Rotating encryption keys for Always Encrypted

In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...

Rotating encryption keys for Always Encrypted

In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...

Rotating encryption keys for Always Encrypted

In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...

Speaking at Idera’s Live Virtual Conference

Have you heard about Idera’s Live Virtual Conference? It is being held on May 16, from 9 AM to 3...

SQL Server Advanced Aggregations Part 3 GROUPING/GROUPING_ID

This post is part 3 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...