Skip to main content

SQL Server 2005 June CTP Released

Today sees Microsoft release the June Community Technology Preview (CTP) of SQL Server 2005. It’s a public preview and can be downloaded by anyone (you don’t need a MSDN subscription for this one) By the same note, Microsoft also announced at Tech.Ed that they will be shipping SQL Server 2005 and Visual Studio 2005 in […]

Setting your default database to tempdb

Personally I like to set the default database for all logins to tempdb. It helps people remember to select the correct database before they start doing things. If someone forgets to change their database, i’d rather them attempting to do crazy things in tempdb instead of master. There are some programs / install scripts that […]

Go home early with WAITFOR

It’s late at night, you’re still at work, waiting for long running task to complete so you can go home. Well why not make SQL Server 2005 wait for you? Well gather your things and make use of the new WAITFOR statement, thats been introduced as part of Service Broker. You can ask SQL Server […]