blogs.conchango.com

SQL Server 2008 is out! All editions are on MSDN now except for Express, which should hopefully follow soon. Enjoy!

As you may be aware we recently hosted a meeting of the UK SQL Server User Group featuring Michael Rys. For those of you who weren't able to jot down the resources he mentioned in his presentation I have copied and pasted them in below. Thanks to Michael for posting them through - I didn't have time either! :o) Spatial Site: . ...

In an earlier post I mentioned that the 4th July had been set as the deadline for submission of session abstracts.  This deadline has now been extended till July 11th as there are still a number of people who we are waiting to hear from.  For those of you still mulling over your session submissions you now have exactly a week to get your ...

In an earlier post I mentioned the new visualisation functionality for spatial data.  Michael Rys kindly pointed me in the direction of Isaac's blog that has some pictures of the new "Spatial Data" tab and resulting visualisation.  As confirmed in the comments below the blog this is using some of the Dundas controls that ...

Monday 30th June 2008. On Monday evening we were very fortunate to have Michael Rys present to the UK SQL Server User Group hosted at Conchango's offices here in London.  Michael has one of the longest job titles I have ever seen.  He's the "Principal Program Manager Lead for SQL Server's Beyond Relational Team".  I take ...

Not a lot more to say about this other than... HURRY.  You only have till the 4th July to get those abstracts written and your sessions submitted. SQLBits is a really great community event and this one is going to be the biggest ever.  We are aiming for 450 delegates this time and expect those sessions to be as wide and varied as ...

I have been working on a POC using SQL Server 2008 and Google Maps.  The POC was to use Geo Spatial technology to illustrate our Geo Spatial data easily.   I will talk about this in more detail in another blog post as I would like talk about a problem I faced while creating this POC.  The problem I faced was how could I get ...

The MERGE syntax I used here has changed. In 2008 RC0 the ''WHEN SOURCE NOT MATCHED'' clause is replaced with ''WHEN NOT MATCHED BY SOURCE'' which is supposed to make the meaning clearer. Although MERGE is part of standard SQL 2003 it's worth noting that the SOURCE NOT MATCHED / NOT MATCHED BY SOURCE clause is not part of the standard. ...

SQL Server 2008 Release Candidate 0 (build 10.0.1442.32) was released to MSDN and TechNet subscribers on Friday. It should be available to everyone else very soon via the Connect site. http://msdn.microsoft.com/en-us/subscriptions/default.aspx http://technet.microsoft.com/en-us/subscriptions/default.aspx   Apart from the new branding ...

SQL Server 2008 is introducing some interesting querying and storage enhancements such as the introduction of spatial data and the FILESTREAM attribute on VARBINARY(MAX) columns and my thoughts have recently turned to what querying enhancements we are going to see in future versions. I was chatting to Rob Farley recently and we started to wonder ...