I’m speaking at the Scottish SQL Server UG on Wednesday 13th February.
My talk is on the new Spatial features of SQL Server 2008 (previously code named Katmai)
It is reckoned that 80-90% of data has a spatial component to it. But what do we do with it now? At best, we constrain it to postcodes. Well, that would be great if we were delivering letters, but the majority of us aren’t. In this session we look at Spatial Queries in SQL Server to see how it works and what can be done with it.
At the same meeting Martin Bell will be talking about DMVs:
Dynamic Management views were introduced in SQL Server 2005 and have made management and troubleshooting of SQL Server significantly easier than in previous versions. Even if you do not write your own queries against these DMVs you may be using them in Performance Dashboard Reports or other performance reporting applications. In this talk I will go through my TOP favorite DMVs and show how and when they can be used and why I like them!
You can find registration details here: http://www.sqlserverfaq.com/?eid=104
The Blog of Colin Mackay 