Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
6.00pm – 6:15 Registration and networking + refreshments.
Meet and greet, take your seat.
6:15pm – 6:30pm Round Table discussion and Nuggets - ALL
Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.
It's also a great opportunity to share your knowledge and gain exposure in the industry by giving a short 1 - 5 minute "nugget" demo/tip.
6:30pm – 7:30pm Business Intelligence in SQL Server 2012 Duncan Sutcliffe
A look at the new features coming to business intelligence with the next release, covering tabular models in SSAS and how they can be used in reports, Excel, PerformancePoint and Power View.
7:30pm - 7:50 Food Break and Networking
7:50pm – 8:20 Loading Data Warehouse Dimensions in SSIS, Alex Whittles (Purple Frog)
There are many different ways of using SSIS to load dimension data into a data warehouse. For small data volumes the method may not have much impact on the performance, but for high volumes making the right choice could be critical.
This session looks at some of the different methods available to load type 2 slowly changing dimension data into a data warehouse, and compares the relative performance of these methods given different volumes of data.
We’ll also look at the impact of different storage solutions, comparing the performance difference of using FusionIO compared to traditional disks. Does the hardware platform change the design approach?
This session presents the results from my MSc dissertation investigating Type 2 SCD performance.
8:20pm – 8:50 SQL Server 2012 - Performance Aspect- Apollo Rahil Bukhari (IMGroup)
Apollo, the new data warehouse query acceleration feature improves query performance by thousands of times. It allows end users to get more business value from their data through fast, interactive exploration. It can also reduce development costs, ETL times and can greatly improve ROLAP performance
8:50pm – 9.00pm Wrap-up and Close