I have worked at places where an employee's desk always looked like it was up for sale every afternoon. It kind of gave management the image that the person was...

This is where the DBA can live...

It may be "widgets" that are stored in the database, but as long as the company is in the business of making them, or selling them, and thus tracking those...

Although using INCLUDE columns in an Index is not practical in all situations, using them to eliminate a Bookmark Lookup (RID) in an execution plan in a lot of situations...

Malcolm Daughtree (2/10/2010)

---

The more I read on this thread the more worried I become... do you actually believe this ...?

RUNNING OUT OF DISK SPACE WILL NOT SEND YOUR DATABASES...

BTW, you can write some T-SQL code with little effort that will check disk space on all fixed drives on your db server via a daily job and notify you...

True sir, and that is why I said "virtually", not "completely". The definition of "virtually" means "for the most part; or just about:" according to http://www.dictionary.com. I fully realize...

Ben,

Restoring backups or copying and attaching files as a way of gaining access to someone's data has been virtually eliminated through TDE. If you attempt either operations on an encrypted...

Paul Randal (2/9/2010)

---

There's also a video recording of my Corruption Survival Techniqes session from TechEd Europe in 2008 which shows me doing all of this live on stage: TechEd: 80...

K. Brian Kelley (2/9/2010)

---

TravisDBA (2/9/2010)

---

Copying database files with the service down and possibly attaching the database files to another machine is useless if the data and log files are encrytped...

paul.knibbs (2/9/2010)

---

Steve Jones - Editor (2/9/2010)

---

However here's an easy way for them to anonymous add themselves, and with clear text, plain text files as the error log, restart SQL Server...

I agree, which is why I recommended Pauls site. He covers this topic in the kind of detail it deserves. His "In Recovery" series is outstanding as well as a...

Paul S. Randal is the definitive source on Database Corruption and recovering corrupt databases. Check him out at http://www.sqlskills.com/BLOGS/PAUL/category/CHECKDB-From-Every-Angle.aspx He wrote DBCC CHECKDB for Mircosoft. A lot of things in...

My point is it would have been a lot simpler if Mickeysoft would have just included the user column in the Change table while they were constructing CDC. It...

Thanks Grumpy,

I did start thinking yesterday why would Mickeysoft go to all the trouble of tracking historically changed data on SQL Server including what rows got inserted, deleted, changed, and...