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

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

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

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

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

VOTE!!! PASS Board of Director Elections

It is voting season again, and there is a great group of individuals running for the Board of Directors of...

ALTER INDEX….ABORT!

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

Notes about Postponing SQLSaturday Orlando Due to the Hurricane

We’ve been monitoring the weather all week, thinking that today was the day we had to decide. We didn’t want...

MOSL – Memory Optimised Scripts Library

SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in...

This Week In Data – Episode 7 (The Importance of Data Testing)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...