Watch my PASS Summit Session on PASS TV

I’m just returning from an amazing week at PASS Summit where I meet many of you while working our Pragmatic...

Building Open Source PowerShell

Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell...

Building Open Source PowerShell

Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell to function on these various systems we need to...

CISL 1.4.0 is released

Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0!
This release is focusing...

Comparing xSQL Schema Snapshots

Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...

Comparing xSQL Schema Snapshots

Applies to: xSQL Schema
Compare v7.0.0 – 9.0.2

Before I develop a scenario where
xSQL Schema Compare snapshot comparison is necessary let’s explain what xSQL
Schema snapshots are. An xSQL Schema snapshot is...

Copying your SQL Database

If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...

Finding Deprecated Uses in SQL Server

How well do you know your environment? You probably know all of the jobs that are running, the frequency that...

Finding Deprecated Uses in SQL Server

Do you know that your Server logs 300 million deprecation events a week? Do you know if code needs to be updated or how to find deprecated uses in...

Implementing Fuzzy Sets in SQL Server, Part 5: The Mystery of the Missing Left Join

By Steve Bolton
…………Information on set operations like complements, intersections and unions is plentiful in the literature on fuzzy sets, which...