Eirikur Eiriksson (11/9/2016)

---

Grant Fritchey (11/9/2016)

---

Beatrix Kiddo (11/9/2016)

---

Not quite true- if you work in a bank...

There's a chance with that kind of procedure that you're also dealing with ad hoc execution. If you have ad hoc T-SQL, you may find that you won't see all...

Beatrix Kiddo (11/9/2016)

---

Not quite true- if you work in a bank or other high security...

To a degree this is just piling on, but this is an important question.

You are much better off not using SSMS on the server for a number of reasons. Most...

I agree with Eirikur (I type that a lot).

You can easily script this install. It's quite small. My one addition to what has already been said is that you should...

xsevensinzx (11/8/2016)

---

Oh, I was referring to the Redgate Data Platform Studio. Wasn't sure if that's fully integrated into the same consumption based model or something else. The Redgate Data Platform...

Query hints? NOLOCK?

Whoa!

I'm with Gail. That brings up a WHOLE different discussion. First, you need all the information she has brought up.

For loading an Azure SQL Data Warehouse, currently, the...

I've been using DreamHost for several years now. It's been a very solid experience.

Chad Crawford (11/7/2016)

---

Grant - your blog gets a wide enough audience that you're going to always have someone who misreads it, misunderstands it, or deliberately maligns it for some...

I agree with Eirikur. Just a restore will get the job done. If you need it near real time, I'd suggest looking at Availability Groups.

I'm at the MVP Summit, so my responses are going to be slow & short for the rest of the week.

Sounds like real improvements have been made. Exploring the new...

Oh cross database? I didn't even notice that. Sorry. That's what happens when you don't drill down and pay careful attention. Yeah, no cross-database foreign keys.

You might, might, see a...

Get in touch if you have questions. Hopefully the book is helpful.

I do think you're looking at the variable causing average values instead of specific ones to get a less...

Are the DatabaseID columns enforced as foreign key constraints, or are they just indexes? Since they are being used as foreign keys, you want to ensure that they are enforced....