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

I've been interested in PowerShell for a while now. I try to read every PowerShell article that comes along, unless it is a very long article, because I want...

My concern is with SSRS. Will installing SSMS for 2008 R2 Express change, in any way, our ability to work with SSRS for SQL Server 2005?

I think potential still rules, at least with a significant number of companies. I knew a gal who I worked with some years ago, that was brilliant at school....

t.brown 89142 (10/9/2012)

---

I tried this as I have SSMS 2005 and SSMS 2008 R2 installed on the same machine.

opening SSMS 2005, I CAN connect to the 2008 R2 database.

When I...

I've heard that triangle put differently: time, cost and features. We're embarking on a major re-write of a legacy app. Before we started on this I had plans...

No SQL Server t-shirts from any vendor or Microsoft. (I'm a developer first, and an accidental DBA second.)

Several MSDN t-shirts (I've no idea how many) and a couple of...

Good article, Steve, with a lot of interesting points. In my current job situation we're way too short staffed to be able to take much time off to do...

Thanks, Bob.