How SQL 2016's JSON Functionality Will Make You Want To Use JSON

This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users to share ideas about...

Server level database permissions

Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...

Power BI Custom Visuals Class (Module 38 – Mekko Chart)

In this module you will learn how to use the Mekko Chart Power BI Custom Visual.  The Mekko Chart visual...

It is possible to run scripts inside SSMS on multiple instances without using CMS? Yes, it is!

Today I will write about an option that is less known/used in the SSMS tool. The ‘SQLCMD Mode’ option.

What is...

Valentine's day love from Learning Tree...

The latest course offer is in from Learning Tree!! And It's Valentine's Day!
Learning Tree are showing you the love with...

Open Source Power BI Desktop Workshop

I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired...

Implementing Fuzzy Sets in SQL Server, Part 8: Possibility Theory and Alpha Cuts

By Steve Bolton
…………To get the point across that fuzzy sets require membership grades of some sort, throughout this series I’ve...

Altering a Job Step on Hundreds of SQL Servers with PowerShell

I flew to Utrecht last week to present with Chrissy LeMaire and Sander Stad to present to the joint Dutch...

Export All Plans From Cache to a .SQLPLAN File

I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file....

Monday Coffee 2017-02-13

Man, if there was an award for procrastinating I’d definitely be in with a shout for today (I write these...