It’s 2016 RLS for T-SQL Tuesday #79

It’s T-SQL Tuesday time again. I missed last month, being busy with travel, though I should go ahead and write...

Comparing two query plans

This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server....

TSQL Tuesday #79 -SQL Server 2016 Launch Discovery Day (aka Hackathon)

The host for T-SQL Tuesday #79 is Michael J. Swart (b|t), and his topic of choice is to write about...

Two new authentication options in SSMS 2016

Until SSMS 2014 there were the two standard authentication options for connecting to a SQL Server instance: Windows Authentication and...

We Must Wait for SP1 before Upgrading to SQL Server 2016

This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016

I’ve been...

T-SQL Tuesday 79 - It's SQL Server 2016 - stupid

Well, today is a busy T-SQL Tuesday no. 79, (it's also Flag Day in the U.S, and also a clerical...

The CHECK constraints unlike behaviours

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...

The CHECK constraints unlike behaviours

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...

The CHECK constraints unlike behaviours

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...

Implementing Fuzzy Sets in SQL Server, Part 0: The Buzz About Fuzz

By Steve Bolton
…………I originally planned to post a long-delayed series titled Information Measurement with SQL Server next, in which I’d...