Execution Plans: Statistics

Watch this week’s Statistics video on YouTube. Last week we looked at what execution plans are and how you can view them. This week I want to discuss what data...

Information Measurement with SQL Server Part 4.6: The Jaccard Distance and Its Relatives

By Steve Bolton …………Over the course of this inexpert exploration of the distance measures used for such data mining applications as clustering, we’ve gradually introduced a system of classification...

sp_RestoreScript 1.5 Release

We’ve released sp_RestoreScript 1.5. This is only a minor release but adds the type of the backup file to the output. You can grab the latest version from our...

Azure SQL Database Elastic Scale Part 1 - What is Sharding?

Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015

This week, Microsoft introduced an update to Azure SQL...

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...

Dynamic Data Masking

Dynamic Data MaskingFEBRUARY 26, 2015

Have you ever wanted to only show parts of a field to certain sets of users...

Fantasy Football - A League of Our Own - Want to Play?

It feels daft me saying the football season is only 9 days away, when in fact The Ashes cricket series is only starting today at Edgbaston. The Ashes are...

Index Fragmentation in Azure SQL Database

Index Fragmentation in Azure SQL DatabaseFEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentationand When Does...

Life Support 2008 – Audit Logons

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...

Salaries in Job Ads

Hiring at Basecamp is interesting. I caught this interview and think it’s a good look at a process most of us have gone through, but perhaps not thought about....