Database Corruption, Transparent Data Encryption, and Trace Flag 5004

This one comes straight from the email bag.  A friend recently had a problem, they were placing TDE on a...

Different ways to audit SQL Server security

Today, my first article (ie. Different ways to audit SQL Server security) published on SearchSQLServer.com. In this article, I discussed...

Home Backup for the DBA

I’ve been giving a Prepare for When Disaster Strikes talk at SQL in the City this year, and it’s designed...

RAID (Redundant Array Independent Disk)

RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk...

Restarting

Well, it’s been awhile since I’ve written anything.  I have lots of excuses for not writing, but none of them...

Restarting

Well, it’s been awhile since I’ve written anything.  I have lots of excuses for not writing, but none of them are rally valid.  There are 2 real reasons for...

Actual Emails: The Customer Doesn't Want Full Recovery Mode

Got this question in an email.  I'll paraphrase.

William Hoping you can advise me on best way to handle this. My client doesn’t...

Coming to Your Town

I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...

Free Tools for Testing SQL Sever

You Need To Test Your SQL Server!
Its like screaming “TEST THE BREAKS ON YOUR CAR!” If you don’t have the...

I couldn’t help myself…