I wish I remember where I saw this posted. I owe mad props to someone but I can't remember who. If your server has lots of databases that you don't have access to and you connect using Enterprise Manager you may have noticed that it takes a loooong time to populate the Databases tab. This especially applies in the hosting world when you're dealing with a shared SQL Server.
MS released a fix that dramatically improves performance in this situation. I finally got to try it out when ORCSweb installed it. Wow! It's quick! And of course, this gives me another chance to...
This NAnt task will restore a database backup onto the target server...
Now that I have a blog and the SQLTeam.com homepage to post on I wonder which is more appropriate for each thing I'm posting. Anyway. I posted a blurb on the April CTP which is really the long awaited Beta 3 of SQL Server 2005.