Steve Jones - SSC Editor (11/29/2012)

---

Custom encryption should use industry standard algorithms. You can search for blowfish, AES, etc. or use the implementations that are build into Windows. As Miles...

Miles Neale (11/29/2012)

---

I have no IPod, do not kick the old or take candy from babies, but I do encrypt data. Not all data but that in the sensitive...

Good admonition, Steve. I'm one who tends to give too much detail to managers. I do this for a variety of reasons, like thinking that I've got to prove to...

I should add, this does work with AD 2003, correct? Our servers are kind of old; we're running 2003 R2 AD.

Thank you, Lowell, I've got to explore this. I've never worked with linked servers before, but I think this is worth checking out.

Thank you very much, Gail and Steve. That's what I thought, but I figured it didn't hurt to double check.

Well, Paul, that was it. I had only downloaded and installed Management Studio Express. Man, I feel so stupid. I'm sorry everyone, my bad.

Good question, Paul. I think I may have gotten the wrong download. I just checked and the name of the download is SQLManagementStudio_x86_ENU.exe, and it's about 156MB in...

I've run the installer again. It gets to the Feature Selection page, and there I'm stopped.

As you can (I hope) see, the features are all selected, and disabled. ...

Great, then I must have missed it. OK, so how do I now add a named instance?

WOW, lots of great feedback here, thank you everyone!

1 production SQL Server instance; 4 production databases.

1 test SQL Server instance and the same 4 test databases.

I'm an accidental DBA; the only DBA we have here.

jasona.work (10/22/2012)

---

While you can install both (I've got SQL2012 Enterprise and SQL2008R2 Express on my work PC,) one of them will have to be a named instance.

IE if you install...

I like what you've brought up, Steve, but I wonder how well it works in large environments? Where I work, after layoffs and people jumping ship, we're down to...

Mad Hacker, I appreciate the mention of the book on PowerShell you found useful. I should look it up. Often the PowerShell tips I see are how to...