One of the new features in CTP3 is the merge command. This was introduced in the ISO SQL:2003 revision of the SQL language definition. Some readers may be familiar with the term upsert which provides similar functionality in other databases.
A common...

The Visual Studio for Database deveopers team have just released their PowerTools. Rather than list the details in my blog jomp over to Gert's blog posting at http://blogs.msdn.com/gertd/archive/2007/08/07/it-is-august-6th.aspx to get all the details...

I've been looking at the June CTP build for a few days now. Only a small number of the promised features are actually available in this early build. One of the features that is available is DMF (Declaritive Management Framework). This allows organisations...

A few days ago at the Worldwide Partner Conference we announced that we will launch Windows Server ® 2008, Visual Studio ® 2008 and Microsoft SQL Server™ 2008 together at an event in Los Angeles on Feb. 27, 2008. This is great news. However I've already...

Cameron Skinner is doing a joint webcast with CA showing a demo of VSDBPro and ERWin working together. To participate in the webcast have a look at Cameron's blog post where he supplies all the details
http://blogs.msdn.com/camerons/archive/2007/08...

There are two livemeeting webcasts scheduled which you might be interested. The first on the new datetime datatype is scheduled for 9pm GMT tomorrow and the second, on Ordpath, at 9pm on the 28th. To participate I've posted the links below but if these...

Hi. I've avoided creating a blog for several years now. However with the launch of the first public CTP of SQL Server 2008 I thought this would be a good time to begin.
I've worked at Microsoft since 1993 and although I've had a variety of roles within...

I been planning what sort of SQL Server 2008 awareness events we should be running for UK ISV's over the next 6 months or so. If you work for a UK ISV I'd be interested in your views on what would work best for you. Send me an email with your thoughts...

A new July CTP of SQL Server 2008 was released this week. Its available from http://connect.microsoft.com Once you register there is an excellent graphic which show exactly what new features were introduced in both the June and July CTP's. Of the ten...