The difference between REVOKE and DENY

There was confusion recently with a poster that was moving permissions around and asked why I said they should revoke...

New Connect Item – TDE

Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the...

Why I’m raising my son to be a nerd

A good read, from ESPN and CNN columnist, LZ Granderson: Why I’m raising my son to be a nerd.
We need...

TDE and Filestream

A Lost Day

I’m not sure what happened, but I had some sort of stomach bug yesterday. I was up throughout the night...

HASHBYTES – A T-SQL Function

Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.....

Execution plans

Cost of the Cloud

The cloud should bring with it lower costs, and better efficiency, but that's not necessarily the way things are. Microsoft has a great internal project that costs out the cloud for their departments, and this would be a great addition to the public or private clouds.

Why Two Devices

I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and...

Five Lines of Code

An interesting story on how a database speeds up by changing some application code. Worth the read for sure.
I caught...