Inaugural meeting of the Belfast SQL Users Group on August 9th, 2012

A new SQL User Group has been set up in Northern Ireland and they will hold their inaugural meeting in Belfast on August 9th, 2012.

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

Session Takeaways:
• 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 Architect, MDSL

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.8:50pm Wrap-up & Prize Giving

Time Starts (UK time) at 17:00 , Finishes 21:00
Cost Free
Organiser UK SQL Server User Group
Address Liberty Information Technology, Adelaide Exchange, 24- 26 Adelaide Street, Belfast, BT2 8GD

Leave a comment


  1. thank you for providing us so many information, i always learn something here.

  2. this is a cool stuff, keep on adding the information.

  3. thanks for this information.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: