SQL Server 2012 Diagnostic Information Queries (April 2012)

It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...

SSWUG Expo..I'm up!

I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...

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

UF Dissolves Computer Science Program, Increases Funding for “Future Jobs”

In a bold and decisive move earlier today, the University of Florida has decided to dissolve their computer science education...

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

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

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

Setup database mirroring and log shipping together

SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...

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

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