Just a suggestion, start rewriting all the code now. You might be able to limp along on one version with compatibility support, but that's extremely limiting and, in the long...

I have not done this, but I've heard it's possible to set up a traditional HA cluster and then add that cluster to an Availability Group cluster. It's important to...

Because CHECKDB will place additional load on the system and can affect transactions, while you do not need down time, I would schedule it during off-peak periods. Even better, if...

I've started using the code snippet manager built into SQL Prompt. Not only does it make it easy to store the things, but I can put a quick key on...

Maybe you need to do a refresh of the Object Explorer?

You might want to check out SQL Cop. I wrote a review of it here[/url].

Try getting a look at the execution plan when it's running slow. Compare that to the execution plan when it's running fast. If they're different, that's a pretty good indication...

Koen Verbeeck (6/12/2012)

---

Wow wow wow. Hold on!

SSIS has a working undo button and you...

Grant Fritchey (6/5/2012)

---

I wouldn't say that SQL Server 2012 introduces anything like a new job role or new job opportunities. It expands on existing jobs and provides a few new...

But if you're unsure, you can check the header information on the full backup and the log backup and compare the begin and end log sequence numbers (LSN). These will...

You can also take a look at the free Red Gate utility SQL Search[/url]. It'll hit all the databases at the same time.

jasona.work (6/7/2012)

---

Thanks for the information Steve!

If / when I go to the SQL in the City, it'll only be the second such event I've been too. I do (when...

anthony.green (6/7/2012)

---

GSquared (6/7/2012)

---

anthony.green (6/7/2012)

---

GSquared (6/7/2012)

---

Again, this is just my take on the whole mess:

You might be better off on a per-processor license. 2012, if I understand the licensing correctly,...

There's nothing in SQL Server that tracks who is making changes automatically. You have to set something up ahead of time. There are lots of ways to do that, so...

I trust these guys, but you know what, don't listen to them. If you want answers on licensing, go to Microsoft. That's the single best source of information and it's...