Get Your Service Broker Messages in Order. Always.

Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.

dbWarden - Purge old data

helps you manage dbWarden history.
No warranty given it will do what you expect, so test it !

Regaining access to SQL server after changing the domain

If you changed your domain and have lost control over the SQL server or have been blocked from logging in , this article talks about it

PowerShell script to check last backup date for Databases

PowerShell script to check last full backup, transaction log backup date for SQL Server databases.

Calculate gregorian easter sunday using a table valued function

Calculate gregorian easter sunday using a table valued function.

Adding Custom Reports to SQL Server Management Studio

In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.

Fun with OVER

SQL Battleship

It's you versus the computer in the classic game of Battleship, completely playable from the SQL Server Management Studio interface!

Review Your BUCKET_COUNT Statistics with DMV

Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.

Function to count set bits in a signed integer

This function counts the number of 1's in the binary representation of an integer.