Another vote for that fine book.

I'm also going to pile on and say that you need to ensure your backups are in place. More than that, you need to ensure...

sqlfriends (10/21/2016)

---

From the two database ends I did a search cannot find any code that refer each other. No FK, no joins related to each other. In the main application...

sqlfriends (10/21/2016)

---

Grant Fritchey (10/21/2016)

---

. Most of the time, that just doesn't offset all the pain involved in maintaining the filestream info. I'd prefer to simply link to the file and...

I don't pardon the shameless plug. I actively encourage it! Ha!

Good...

No idea why someone would use two databases in this fashion unless the filestream was added as an afterthought and they just didn't want to modify the existing database.

In general,...

lindsayscott23 (10/21/2016)

---

Brandie: Ah yeah you're right, I think I did misunderstand the difference between Cross-Querying and Cross-chatter. (Both new terms to me tbh!). That makes me think that I should...

Brandie Tarvin (10/20/2016)

---

Lins,

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

If you separate out the data into individual databases, how many queries will have to touch these multiple databases...

Eric M Russell (10/20/2016)

---

Grant,

Has RedGate written any books on Continuous Integration and Lifecycle Management from the perspective of database development, or can you recommend a good book on the topic?...

Sorry, I don't see anything. What are you attempting to do? Describe your backup plan and how it meets your Recovery Point Objective and Recovery Time Objective worked out with...

mark 4643 (10/20/2016)

---

Thanks Grant, will checkout DLM. Would like to get to CI eventually

In interim we are moving to local dev DB's and in red-gate source control, we will change...

lindsayscott23 (10/20/2016)

---

I've mapped out how I think the dataflow will work from source to destination. Here's how it's looking for production in plain English:

Data Sources load into a single Staging...

The best way to do this is to give each developer their own local instance and their own local copy of the database. For this to work well, you have...

Jeff Moden (10/19/2016)

---

Deny Christian (10/18/2016)

---

Jeff Moden (10/18/2016)

---

FROM DATABASE is typically...

I've got an article I wrote on backup testing. You can see all the options available[/url]. As everyone says though, the one way to be sure is to do a...

Chad Crawford (10/18/2016)

---

Grant Fritchey (10/18/2016)

---

BLOB_EATER (10/18/2016)

---

Grant Fritchey (10/18/2016)

---

Wow, just read the comments on Reddit about a recent blog post... ouch.

Evidently stating the obvious when others are stating the opposite...