Belfast SQL Server User Group

Welcome to the Belfast Chapter

Next Meeting

Thursday,

August

09

Belfast SQL User-Group

  • In-Person @ Adelaide Exchange Belfast, Antrim, United Kingdom (map)
  • 18:00 - 21:00 GMT Daylight Time
  • Language: English

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 networkin, Meet and greet.

6:15 – 7:30pm Neil Hambly "SQL Server 2012 Memory Management"

7:30 – 7:50pm Break: Light refreshments More time to network, ask questions and eat pizza...

7:50– 8:50pm Alex Whittles Mergetastic!

8:50pm Wrap-up & Prize Giving

Featured Presentation:

SQL Server 2012 Memory Management

Neil Hambly, Founder, CIO & Principal Consultant DataMovements

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

About Neil:
Neil Hambly is a SQL Server consultant, founder & Consultant @ DataMovements a founder of Datamovements a Gold Microsoft Data & Analytics Consulting company Neil has 20+ years in a variety of SQL Server roles and is a MCT a regular presenter (200+ events) at usergroup and PASS events, PASS Summits & SQL Saturdays & many UK events (SQLBits, SQLRelay), Leader of PASS London (UK) & Professional Development VC, Melissa Data MVP, SQL Cruise Technical Lead who likes Guinness, Loves whisky and dancing.

Mergetastic

Alex Whittles, Business Intelligence Consultant Purple Frog

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.

About Alex:
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX & DAX. He's a chartered engineer & has an MSc in Business Intelligence. He runs the Birmingham (UK) SQL Pass chapter & Azure user groups, and is on the SQLBits and SQL Relay committees in the UK. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQL Saturdays as well as numerous SQL Pass chapters around Europe

Supplementary Materials

The following event attachments are available to you:

PASSChapterLogo.jpg

sql_micro_sm.gif

sql_ca_sm.gif

Liberty IT

Momentum NI

Apress

WROX

SQL Sentry

Plural Sight

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids