The Mentoring Experiment – Cycle 2

It’s been a long time, almost a year since Andy Warren and I kicked off The Mentoring Experiment. We had...

AlwaysOn Failover Bug

I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a...

See you at SQL Saturday 130 Jacksonville!

http://www.flickr.com/photos/rohicks/4788477593/
Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL!  The good people from the Jacksonville...

Beer, Cheese and SQL Saturday 118 Madison

This past weekend I (w|t) headed up to Madison, WI to attend and present at SQL Saturday 118. The MADPASS...

Offset without OFFSET

A while ago Robert Cary posted an article on SQL Server Central entitled 2005 Paging – The Holy Grail which is,...

Enterprise Data Warehouse Architecture Options

Enterprise Data Warehouse Architecture Options
Of course, your architecture depends on your business requirements along with technical, historical, and political factors....

Creating a Symmetric Key in SQL Server

Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and...

2012 (2011) Data Breach Report

I had a chance over the weekend to finish reading the Verizon 2012 Data Breach Investigations Report. It’s a compilation...

SQL Azure Federation

 What is Federation?

Federation is a database object like other objects such as tables, views, stored procedures or triggers.
It is also known as Sharding.
There can be multiple federations in a database.
It is...

Identity Crisis

I’m sure most people have identity values lurking somewhere in their databases.  In fact I would guess that most people...