Everyone. But primarily Amazon. They're the other big player in hosted services.

I can't tell if Microsoft...

There are free trials available: https://azure.microsoft.com/en-us/pricing/free-trial/

If you have an MSDN license, you have up to $150 of credit, monthly, to experiment...

I've seen some, but none I...

There are a lot of moving parts here, especially with the introduction of VMs into the mix. You're going to have to go through the settings on the servers, look...

Agreed. COPY_ONLY is of use with DIFFERENTIAL backups. If you're not using DIFFERENTIAL, then there's no need to use COPY_ONLY. It won't do anything for you.

Instead, the QA process...

Yeah, I think this could make a good presentation. A DR process with little, or inadequate, documentation is going to fail.

This is going to be an utter disaster taking this approach.

Generated code is fine, to a point. However, it needs to be generated with actual logic behind it. I'd...

By and large, when creating a new index, I leave the default in place unless I know going in that I'm likely to see lots of fragmentation. Otherwise, I don't...

Two points on that answer. One, it's doing the same thing with trace that I outlined with extended...

sql-lover (3/10/2016)

---

Grant Fritchey (3/10/2016)

---

sql-lover (3/10/2016)

---

Grant,

I just tried that Extended Event session on my Dev box and it's not capturing anything 🙁 I tried a simple store procedure reading from...

sql-lover (3/10/2016)

---

Grant,

I just tried that Extended Event session on my Dev box and it's not capturing anything 🙁 I tried a simple store procedure reading from a simple table...

sql-lover (3/10/2016)

---

Grant Fritchey (3/10/2016)

---

This is easy and difficult at the same time. Tracking an individual table, I assume you want READ/UPDATE/DELETE/INSERT is not something normally done. It's very easy with...

This is easy and difficult at the same time. Tracking an individual table, I assume you want READ/UPDATE/DELETE/INSERT is not something normally done. It's very easy with a batch operation:

CREATE...

Take direct control of the restore process through scripts rather than relying on some GUI. You can certainly name the files any way you wish when using those products you...

There is no direct connection between SCOM and Maintenance Plans. You may need to go into SCOM and deselect databases that are not being backed up in order to remove...