Just remember that you'll have to poke holes through the firewall on both sides to allow communication through whatever port you have SQL Server running on (1433 by default).

Alexander Suprun (2/9/2016)

---

Just use default template and put filters on duration and database name, and save result...

Sean,

Here's hoping it all works out great.

SQL!$@w$0ME (2/8/2016)

---

Thanks Grant!

The db has been designed/created to use a user defined file group as default for data and a separate index...

I haven't done this myself, but if I were going to do it, I'd use extended events. The trick is going to be filtering by a particular user. If you...

Nope. No file group support in Azure SQL Database. Azure SQL Database is a Platform as a Service (PaaS) offering for SQL Server databases. No options that require access to...

If you are trying to identify the longest running process, on a 2014 system, I wouldn't use Profiler (I wouldn't ever use Profiler to capture data, just consume already captured...

You must be missing the correct media. If you have the correct media, it just works.

Ha! Love you too!

I have to go back and tune his "fixes" later so...

Grumpy DBA (2/4/2016)

---

In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code review I would point out all...

Why do you think I'm working on that database?

Ha!

I'm pretty sure that's one of Steve's presentations.

Br. Kenneth Igiri (2/1/2016)

---

Grant Fritchey (1/28/2016)

---

To get data moving both directions you're probably looking at Merge Replication. But that requires quite a bit of redesign. You could use transactional replication,...

Well, just remember, I'm just some guy and my opinion isn't worth much more than others. If you're happy with it, use it. Plus, I keep getting rejected on PD...

What changed on the system? Something has to be different. Determine what that is and you may have your solution.

Ray K (1/29/2016)

---

Grant Fritchey (1/28/2016)

---

Great topic. I'd add one more sentence to the abstract. It feels short. I'd add two or three specific techniques that you're going to teach so...