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.
5.45 – 6:15pm Registration and networking
Meet and greet.
6:15 – 7:30pm Neil Hambly "SQL Server 2012 Memory Management"
SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory.
This session will dive into questions related to memory in SQL Server 2012
• Explore SQL Server 2012’s new memory architecture and learn how to diagnose memory performance issues
• Gain insight on memory pressure issues
• Discover settings to adjust the memory configuration levels and their impact
Neil Hambly is a
SQL veteran with over 13 years’ expertise in SQL Server from Version 6.5 right
through to the very latest 2012 edition. Neil has held numerous DB roles at
major organizations such as BBC, ABN AMRO, ACCENTURE, alongside a number of
smaller companies, with prior roles as both a DBA and Developer, and currently
is a Database Architect at MDSL.
Neil is an active speaker at
conferences and user groups. He is SQL London PASS Chapter leader , he can often be seen presenting @ UK & International events.Database
7:30 – 7:50pm Break: Light refreshments
More time to network, ask questions and eat pizza...
7:50– 8:50pm Alex Whittles Mergetastic!
The more I use T-SQL’s Merge statement the more I love it. It’s fast, powerful, flexible and above all, it provides a world of opportunities to save a lot of time.
In this session we’ll look at how merge can be used to perform complex multi-stage tasks such as loading data into data warehouse dimensions, including the handling of type 0, 1 & 2 slowly changing dimensions.
I’ll present a summary of my MSc dissertation findings, comparing the performance of using T-SQL Merge against other more traditional methods of loading data warehouse dimensions in SSIS.
We’ll also look at how we can use simple metadata configuration and dynamic SQL to completely automate the generation of the merge statement, resulting in an incredibly simple meta-data configurable data warehouse platform.
Alex is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specialises in dimensional data modelling, data warehouse design, ETL systems, OLAP cubes, MDX, PowerPivot and DAX. Alex is leader of the Birmingham PASS chapter and runs the Midlands SQL Relay events. He has just completed an MSc in Business Intelligence, writing a thesis on the performance characteristics of loading type 2 SCDs into a data warehouse. He’s also a regular speaker at SQLBits and at various SQL Server user groups and PASS chapters around the UK.