Isolation levels in SQL Server

Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with...

PASS Virtual Chapter August presentations

If you do not know by now, PASS has many virtual chapters that give free webcasts all month long. I...

Would You Listen To The Steve & Andy Radio Show?

My friend Steve Jones and I have talked every week for a long time, close to ten years now. On...

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