Scottish SQL Server UG: (1) Spatial Queries in SQL Server 2008 (2) Dynamic Management Views

Organiser
Scottish SQL Server User Group
Date
Wed, 13 Feb 2008, 18:30 - 21:00 (Add to calendar) GMT
Venue
HBOS (Bankhead Crossway North) , Edinburgh, GB
Cost
FREE

Scottish Area SQL Server User Group on conjunction with Scottish Developers: Wednesday 13th February 18:30 - 21:00 : Edinburgh

Speaker: Colin Angus Mackay Where’s my data? An introduction to Spatial Queries in SQL Server 2008


Colin Angus Mackay is a software developer specialising in Microsoft technologies located in Glasgow, Scotland. He is a Member of the British Computer Society, a Microsoft MVP (C#), a Microsoft Certified Solutions Developer, a Core Member of Scottish Developers, Code Project MVP for three years running and while not involved in software related pursuits is an amateur photographer, cyclist, map maker and is also the Vice President of Education for South Side Speakers, the Glasgow South Side Branch of Toastmasters International. And if all that wasn’t enough he is also organising Developer Day Scotland

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.

Speaker: Martin Bell "SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking"
Martin has been a freelance computer consultant in the UK for over 23 years. He has worked on many relational database systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003. Currently he organises the Scottish Area Meetings and is a founding organizer of the SQLBits Community Conferences.

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!

This event will be held at the HBOS's Sighthill office. For security reasons we need to submit a list of deligates in advance. If you wish to attend you MUST email Martin Bell before 12:00 on 11/2.

The event will start at 18:30 and go on till 21:00

Sandwiches and refreshments will be provided for attendees.

You might also like...

Comments

Other nearby events

Map

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Anyone who considers arithmetic methods of producing random digits is, of course, in a state of sin.” - John von Neumann