SQLCover Fixes and Download location

There have been a couple of fixes in SQLCover this week, kindly submitted by John Mclusky (https://github.com/jmclusky):
Code coverage not reported...

Step by Step: WHERE, GROUP BY, and HAVING

People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the...

ALTER INDEX….ABORT!

I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes...

How to get Power BI RLS to work with external users

Let me start by thanking Adam Saxton aka Guy in a Cube and Hope Foley for helping me with this...

May MVP – Bob Pusateri

Whoa. I’m way behind in my blogging.
For the month of May, my MVP choice is Bob Pusateri (B|T).
Bob is a...

Networking Dinner at the 2016 PASS Summit

Steve Jones & I are organizing our 7th annual networking dinner on Monday night, October 24th in Seattle. We’re changing the...

PowerShell -> Identify all SysAdmins in your SQL Server

No pressure. None whatsoever. There is just an Auditor standing behind you waiting for you to pull a list of...

Query Store and What Happened Earlier On Your Server

Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...

Sp_recompile doesn't recompile!!!!

Many of us use the stored procedure "sp_recompile" to mark the stored procedure for recompilation, so that next time it...

Synchronizing NOT NULL Columns

Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data
Compare v7.0.0 – v9.0.0

Description: Using
xSQL Schema Compare and xSQL Data Compare to keep the tables of two databases
in sync...