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

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

SQL Backup 7

What more could you add to a SQL Server backup product? It seems that many software products, including Red Gate’s...

Automatic page repair with SQL Server Mirroring

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...

Oracle Tips for MSBI Devs #3: Choosing Drivers

When working with Oracle, drivers are truly a pain to get working correctly.  I will discuss my preferred choice and...