The 2000 databases will have to be updated to 2005 or 2008 before you can make the jump to 2012.

Other than that, you have two ways of doing the upgrade....

Microsoft doesn't really support a direct mechanism of backup & restore through Azure. You can do an export/import through the Azure storage. I have a blog post about it here....

You wouldn't be connecting your source control directly to your production server anyway, so that's not a problem. It just needs a server on the side that you can pull...

The reason that functions are slower than stored procedures is not because of compilation. They're both compiled. It's how things get compiled that are the issue.

If you're talking about an...

Yeah, we'd at least need the execution plan to understand what's going on. Nothing jumped out as horribly egregious. The GROUP BY will put more load on tempdb depending on...

When I present I blow the font up large and I change it to Lucida Sans. It seems to work well for most people. I don't use that normally (maybe...

glamourth (6/13/2012)

---

Hi All,

I have used sys.dm_exec_query_stats and sys.sysprocesses to find long running queries particulary more than 60 minutes. But, as am not gud at sql scripting not able to join...

Steve Turner - SQL Managed (6/12/2012)

---

Actually, you can now host Windows Servers on Azure. This was in beta for a while but MS just announced the new Azure code...

Ah, missed that it was tempdb. Still, assuming my disks are going off, I'm running an extra backup. I may still run DBCC on the other databases too.

First thing you should do is run a set of full backups. Then save that somewhere on the side or, better still, off-site.

After that, you can try to identify the...

Windows Azure is just application hosting. It's not an entire OS. For that you'd want to look at Amazon or Google. Windows Azure is for applications and SQL Azure is...

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...