Note: This event has a max capacity of 102 - this event is now full; we are operating a reserve list - feel free to register as I will be sending reminders out a few days before the event to make sure if you have registered you are still coming.
Come and socialise and learn from your peers; these physical meetings are great places to expand your network, get answers and find out how other people are using SQL Server and what is going on. This is the last meeting this year for London and for those who can we should do drinks after the meeting to continue the SQL chat in an even more informal environment.
If you want to twitter please make sure you use the tag #uksqlug so it is shown on the site.
Your host for the evening will be Ashwani Roy, SQL Server MVP.
Agenda
18:00 - 18:15 Meet & Greet
Meet up and socialise with your friends, meet new people, find out what other people are doing with SQL Server.
18:15 - 19:00 SQL Server 2008 Data Warehousing Features
Vincent Rainardi;
http://www.datawarehouse.org.uk
In this session I will explain about 2008 Data Warehousing features such as merge, CDC, data compression, backup compression, star join query, minimally logged insert, parallel query on partition tables, partitioned aligned indexed views, resource governor, grouping sets. I will pick some of them and show implementation example in the form of a demo.
So this session will be particularly useful for people/companies who already have a data warehouse on SQL Server 2005, as it explains to them the benefits of upgrading their warehouse to 2008. It will also be useful for companies who don't currently have a data warehouse on SQL Server (perhaps they have it on other platform), and are currently deciding whether to use SQL Server 2008 for their warehousing platform. And of course this will benefit Microsoft, as it draws people's attention to using SQL Server 2008 for their data warehousing platform.
19:00 - 19:15 Using Indexed Views & Computed Columns for Performance
Neil Hambly, http://sqlblogcasts.com/blogs/NeilHambly
One of the key elements of any DW / OLTP system is performance, alas no matter how good it's design or how powerful it's hardware there are times when the performance of a Query operation / function is JUST NOT adequate, even if properly tuned these times generally we are likely to be dealing with lots of data or complex calculations SQL Server has ways to help deal with those scenarios, some of these include the use of Indexes Views or Computed Columns I will spend a few minutes explaining their usage, Pro's & Con's and demo some examples.
19:15 - 19:35 Break for Pizza sponsored by Microsoft