It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Master Data Services is a new product due for release with SQL Server 2008 R2. This presentation will explain why you may want to use it and what it will help you achieve and some of the challenges you may face.

A step-by-step demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star/snowflake schema Data Warehouse/Mart first.

So you heard about the new spatial functionality in SQL Server 2008, rushed back to your database and added geography and geometry columns to all your tables, eager to create the next Google Earth-beating application. You then click the Execute button and wait.
And wait.
And wait some more. (You get the idea).
Spatial data is a rather unique beast, and designing efficient spatial queries requires specific techniques when compared to other, more traditional types of data.
In this session, we look at how the SQL Server database engine satisfies spatial queries, the theory behind spatial indexes, demonstrate the effects of altering the bounding box, use the spatial system DMVs and stored procedures to your spatial database

The new compression features built into the Enterprise Edition of SQL Server 2008 should use less disk space and, perhaps even more important, speed up your system because of reduced disk IO.
In this session we will :
Take a look behind the scenes to see how it works.
Investigate what commands / tools we can use to set it up and maintain it.
Look into some examples of my own day to day experience that I collected so far.
I aim to give an overview of both data compression and backup compression AND some Lessons Learned.

Has the way you present your data become a bit bland? This session will take you through how combining
your location based data on a map using Bing Maps for Enterprise(previously Virtual Earth) can add an
interactive edge to the visualisation of your data.