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.

Dang, that is sweet. I guess I'll have to develop some logic to filter on the largest media_set_id for the backups I'm interested in. Before I go too...

WOW, good explanation, Celko! I hope that one day we'll be able to upgrade to SQL 2008 R2 or SQL 2012. Fortunately for me, this was an ad...

GSquared (8/27/2012)

---

UPDATE/DELETE FROM work in all versions of SQL Server that I've worked with, including SQL 2000, 2005, 2008, and 2012. MS isn't planning on removing them. If...