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 explain what xSQL
Schema snapshots are. An xSQL Schema snapshot is...

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

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

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

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

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

Knowledge vs Ability

Knowledge and ability, they are very inter-related. We born with only survival ability, ability to eat and drink, that’s pretty...

Mastering Index – Index on Computed Columns

This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...

Monday Morning SQL Break – November 7, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch...