Lins,

I think you misunderstand what Grant meant by cross-database querying.

If you separate out...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is...

Luis Cazares (10/20/2016)

---

mister.magoo (10/20/2016)

---

I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a small part...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data,...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

On a fun note, my past 24 hours has been taken up by an AG issue which has caused one secondary replica not to synchronize, which caused...

lindsayscott23 (10/20/2016)

---

...our workflow goes like this:

Build in Dev

Unit Test in Dev (this is done by the developers)

Add to appropriate folder in TFS (we have monthly releases and each release folder...

Jeff Moden (10/19/2016)

---

Steve Jones - SSC Editor (10/19/2016)

---

Jeff Moden (10/18/2016)

---

Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to...

Luis Cazares (10/19/2016)

---

Brandie Tarvin (10/19/2016)

---

Have you tried renaming the folders to use underlines instead of hyphens?

I think the hyphens are the problem. That powershell might see them literally as a...

On a fun note, my past 24 hours has been taken up by an AG issue which has caused one secondary replica not to synchronize, which caused the log files...

Gazareth (10/19/2016)

---

Gazareth (10/19/2016)

---

First line: "Version 4.2 also lets you nest triggers"

I didn't get any further due to blacking out; came to 10...

river1 (10/18/2016)

---

Separated sql tasks means that each species is executed inside is sql tasks. Task are connect through success arrows ( green arrows). So, exactly as the sp I...

Perry Whittle (10/19/2016)

---

you can offload log backups to...

patrickmcginnis59 10839 (10/19/2016)

---

Brandie Tarvin (10/19/2016)

---

patrickmcginnis59 10839 (10/19/2016)

---

Anything could cause the secondary to not be synchronized. Things like taking differential database backups of the primary, which will disrupt the flow of...

Have you tried renaming the folders to use underlines instead of hyphens?

I think the hyphens are the problem. That powershell might see them literally as a switch "notifier" kind of...

patrickmcginnis59 10839 (10/19/2016)

---

Anything could cause the secondary to not be synchronized. Things like taking differential database backups of the primary, which will disrupt the flow of data from primary to...