Ray K (3/19/2012)

---

For those of you looking for an alternative to the Northwind database for testing, it looks like Sean Lahman has come up with a SQL version of his...

Are you saying you want to learn more about T-SQL?

The T-SQL Programmer's book is a good one as is SQL in a Nutshell.

http://www.amazon.com/SQL-Nutshell-In-OReilly/dp/0596518846/ref=sr_1_sc_1?ie=UTF8&qid=1332033816&sr=8-1-spell

http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/ref=sr_1_1?s=books&ie=UTF8&qid=1332033825&sr=1-1

I think so. I wasn't trying to specifically say this is 100% of the way to do things. Individual DBAs...

I'd agree on whole disk encryption. Doesn't make a lot of sense to not use that, but the backup argument seems pretty good to me, especially because backups aren't just...

This?

http://www.amazon.com/Star-Wars-Omnibus-Tales-Jedi/dp/1593078307

GilaMonster (3/14/2012)

---

[

It was part of a whole re-organisation of both the Republic and the Jedi Order after the New Sith Wars, the Republic Dark Age, the Brotherhood of Darkness and...

My apologies, Leo. I didn't realize you reinstalled SQL and then replaced master.

In that case, it appears this will work, which is good to know.

I thought that was pretty funny. As soon as I read that, I thought "this...

Leo.Miller (3/14/2012)

---

We didn't even backup and restore the database files, they actually migrated the LUNs from the old server to the new one. At one point there were issues because...

Nope, asked a few people, no one is sure.

Ultimately, I'd test it. Make a VM, set it up, copy the master.mdf over and see if it works.

+1. Go with release order. No matter how bad #1 is, it's part of the series. And part of numerous jokes...

I've never tried it, but I thought that the master db was aware of the cluster, and if you are trying to replace a non-clustered master with a clustered master,...

The background thread only runs to do the encryption. Once that is finished, it is not spawned again. All encryption/decryption is then part of the normal I/O read/write processes.

addieleman (3/14/2012)

---

The last sentence: However I think lots of management might prefer in-house infrastructure for a simple reason: it gives them a specific neck to choke, and possibly replace, when...

If you read the update and root cause analysis, this wasn't a redundancy issue. It was caused by a software bug, one that couldn't be fixed by more hardware. Developers...