What changed recently? Around the time that MSDB went Read Only or right before.

While you might be able to upgrade the packages directly to 2012, I wouldn't recommend it. Enough changed with SSIS between 2005 and 2008 that your incremental step approach is...

Thanks, all, for the reviews of the presentation.

While my class is now officially over, I'm debating on the possibility of redoing the presentation for a more real-world push of the...

As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you mind.

Steve Jones - SSC Editor (2/29/2016)

---

Alan.B (2/29/2016)

It's not a bad thing for a recruiter to work with the candidate to modify the resume for a position provided everyone is being...

Thanks for clarifying.

Grumpy DBA (2/26/2016)

---

Brandie Tarvin (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

Well, that's...

Grumpy DBA (2/26/2016)

---

Well, that's a good thing because...

Orlando Colamatteo (2/25/2016)

---

How many tables? I am thinking a simple Transactional Replication Publication on Server B subscribed to by Server...

TheSQLGuru (2/11/2016)

---

Whenever I am building out dynamic SQL I always use SET QUOTED_IDENFITIER OFF first and then use double quotes in the outer sections of text. Then I never have...

Lynn Pettis (2/25/2016)

---

I am so glad I don't have any experience, yet, with replication so that I have no idea what SS is trying to do or why he isn't...

I'll keep OPENQUERY in mind (and discuss it with the Devs) when we fix things, but it isn't going to help me now. My current sticking point is stored procedures...

Thanks, Grant. I'll look into that.

Was it indeed corrupted .mdf and .ldf files?

Regardless, I'm glad you resolved your issue.

TheSQLGuru (2/25/2016)

---

1) Make sure you configure linked servers optimally for your server scenario

2) Review the object accesses. Some linked-server queries can be refactored for HUGE perf gains depending on if...