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

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

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

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

Rant: Applying Common Sense in IT

I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...

Restarting

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

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

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

Where’s My Certificate Backup?

If you’re like me, you take advantage of the default backup paths in SQL Server. It makes my code cleaner,...