Creating a User without a Login – Contained Databases

In SQL Server 2012, we have a new feature: partially contained databases. In a previous post, I showed how to...

Key Storage

Today Steve Jones asks about how you secure the keys that secure your other data. Is there a good way that you've found to handle this?

Be Extra Careful When Packing

Over the last couple of years I’ve gotten myself down to two small, carry-on bags for most of my trips....

Transfer Times in the Cloud

Today Steve Jones talks about a problem in the cloud computing world: getting your data back.

Contained Database users

Hashing Collisions

One of the problems with hashing is that you can have collisions from values that are not very similar. This...

Wasting Time

Focusing in one area for long periods of time is hard. Steve Jones thinks that people taking a little time at work to recharge is a good idea, and something companies might want to encourage.

Certificates Everywhere

Today Steve Jones talks about security and his desire to have certificates be the primary means of securing communications and verifying authenticity.

Using 2008 Features in a 2000 Compatibility Database

I saw a note recently from someone asking if they could use CROSS APPLY on a SQL Server 2008 instance...

Enabling Contained Databases in SQL Server 2012

One of the new features in SQL Server 2012 is the Partially Contained Database feature. I gave a talk on...