No, you don't have to have HyperV running in more than one location. If you're using a server to train on, use it on the server.

Extended Events will only work in 2008 or greater.

I haven't tried connecting to 2005 from 2014 Profiler, so I'm not sure what the issue might be.

Instead of using the Profiler...

Should work fine.

Also, there's this from Microsoft.

I also recognize that some guy responding to your question on the internet is not going to be exactly compelling evidence on your side. So, I did a quick search...

Service Oriented Architectures are great. No question.

But this idea that a persons name has to be broken into multiple tables because part of it might be updated independently from the...

Unfortunately, the devil is in the details on the tech. There's not a single winning piece of tech on the Microsoft side. I think the only winning piece of tech...

And I'm with Perry. I'd use .bak for all sorts of backup files, but differentiate them in the name.

Nah. You can call your backup files .doc if you want to. They'll still work fine.

Don't do that though.

sqlmunkee (1/8/2015)

---

+1 - I always SET OFFLINE, never SINGLE_USER, as you can't be...

It's basically a message telling you that you're running SQL Server on a grossly underpowered machine. 2gb is just the bare minimum to get the server started. You need more...

Here you go.

OK. Not a problem. The link I provided should do what you need then.

I don't understand what you're trying to do.

Your first post said:

SQL Server 2014 Upgrade Advisor to be run on a...

Alexander Suprun (1/7/2015)

---

Grant Fritchey (1/7/2015)

---

The transaction thing I just don't understand. That's because, actually, every query within the system is already within a transaction all on it's own. So not...

Alexander Suprun (1/7/2015)

---

Grant Fritchey (1/7/2015)

---

syquil (1/7/2015)

---

That was a good chuckle. Thank you for that.

Can you expand on any 'gotchas' or 'no-nos' with the edit window for my own benefit?...