Manda QoP

As with my other TechEd 09 notes, this will be a list of notes that I made during the presentation. These will give a start point to find out further information. Virtualization - presented by Rob Reinauer at Code Camp on the 13th September. Find out more info on how anti-virus software works with VMs and are the AV companies planning any new methods to handle VMs? Demo of Hyper-V Live Migration in SQL Server 2008 R2 (Kilimanjaro): Copies pages to memory Copies delta changes Repeats copying delta changes down to smallest change found Freezes environment Copies everything to destination child partition Takes down source child partition Brings up destination child partition Freeze downtime is generally 2-4 seconds Connections are maintained throughout process Users will not notice the change of child partition due to maintained connections, they will most likely not even realise they have been moved In SQL11 the bulk of false failovers will be removed System Centre Virtual Machine Manag

As with my other TechEd 09 notes, this will be a list of notes that I made during the presentation. These will give a start point to find out further information. Orinoco: Search online for 'stream insights' as this is the alternative name for project Orinoco Streaming data without persistence Continuous and incremental processing of event streams from multiple sources based on declarative query and pattern specs with near zero latency Process real-time in a flow flow before it even gets to the database to speed up result processing time CEP engine - mine & design Queries look for warnings in events that come across CEP engine can sit anywhere in the process

As with my other TechEd 09 notes, this will be a list of notes that I made during the presentation. These will give a start point to find out further information. Project Madision: 100's of terabytes FastTrack reference architecture - guarantees consistent throughput for high scale data warehouses Massive scale out to 100's TB Developed by DatAllegro, MS bought them a year ago and are now incorporating their software into Kilimanjaro Large tables are hash distributed Small tables and dimension tables are replicated Create DB is now a simple script for DBAs. This script triggers a system script that will set up an optimally created database. Create table/partition is now combined in one statement

Kilimanjaro is the code name for SQL Server 2008 R2. This version of SQL Server 2008 contains 6 major new components: Gemini - self service business intelligence Synthesis - application and multi-server management Madison - High end scale out for data warehousing Orinoco - Complex Event Processing (CET) - streaming data without persistence SSRS - Report builder enhancements and Sharepoint integration > 64 core support Kilimanjaro should be available in the 1st half of CY10.

I'm currently at TechEd and thought it may be useful to blog session notes, both for myself as notes to refer back to, and just in case anyone else out there is interested in any of the topics. The notes are just that, notes... some of these I need to drill down in to when I get back to work to find out more information, but hopefully if this is a topic you are interested in the notes will give you a start point to drill down further as well. There may be some repetition of notes if I've picked up on an idea again later in the talk. There are a lot of notes, so I'll split the blog posts by subject. This one is about project Gemini. This is the new self service BI tool that will be included with Kilimanjaro. These notes are combined from the Code Camp presentation on Sunday 13th and from Mark Souza's presentation at TechEd on the 14th. Gemini Notes: Slides should soon be available at www.aucklandsql.com (give Dave a few days to get these uploaded). http://blogs.msdn

YAY! My funky office floor plan map is working a treat. Now to add some dynamic interaction features. :-)

For those who don't know, Fronde are the sole NZ partner for Google apps until at least the New Year 2010. Most of the Google work so far has been undertaken by the team down in Wellington, apart from the very shiny Track-U application for the Blackberry created by the Java devs here in Auckland. We wanted to get more people involved up here in Auckland so we're assigning ourselves internal projects. We're all taking a specific area to make that our specialist subject as there are a large variety of Google apps, most of which are quite large when you start to really get into them to see what you can do with them. I'm currently looking into the maps API and it's proving quite interesting. Three of us are creating an interactive floor plan for both floors of the office, we're then going to hook it into MOSS. I've created the tiles for both floors, that was the easy part and they did show up beautifully, then came a bit more of a challenge with settin