Skip Main Navigation
Page Content

Save This Event

Event Saved

Looks like this event has already ended.

Check out upcoming events by this organiser, or organise your very own event.

View upcoming events Create an event

Birmingham SQL Server User Group - Indexing Nightmare Cut Through the Clutter & Using BIML for Automation

SQL Midlands

Thursday, 19 January 2017 from 18:15 to 21:00 (GMT)

Birmingham SQL Server User Group - Indexing Nightmare...

Ticket Information

Type Remaining End Quantity
SQL Midlands Attendee 86 Tickets Ended Free  

Share Birmingham SQL Server User Group - Indexing Nightmare Cut Through the Clutter & Using BIML for Automation

Event Details

Midlands SQL Server User Group - 19th January 2017, 6.15pm

Session 1: Stuart Moore - Indexing Nightmare - Cut Through the Clutter

Session 2: Terry McCann - Using BIML to automate Data warehouse dimensions



6.15pm – 6:30pm Meet & Greet

6:30pm - 7:30pm Stuart Moore - Indexing Nightmare - Cut Through the Clutter

Inherited a database with 30 indexes on every table? Has the vendor for your 3rd party app recommended more indexes over the years than you can remember? Got indexes that were added to fix a data load problem 4 years ago, but not sure if they're still being used? Indexes are key to SQL Server performance, but like everything too much of a good thing is a bad thing. In this sessions we'll look at how you can analyse your current indexes with the aim of consolidating them into useful ones, even removing some completely and how to improve the ones you've got left


7:30pm - 8:00pm Break & Pizza

8:00pm – 9:00pm Terry McCann - Using BIML to automate Data warehouse dimensions

Whether you're new to data warehousing or you have been building warehouses for years, you need to know how to build a slowly changing dimensions. As developers we can quickly become lazy and resort to coping and pasting SSIS packages to replicate dimensions. While this works for small warehouses, when you have 100+ dimensions this is a problem. In this session we will look at how you can handle type I and type II attributes in the same dimension in an automated way. However to get there we need to understand how this has been accomplished historically. We will look at the SCD wizard in SSIS, using TSQL MERGE, creating a manual process and finally using BIML to automate the whole process. Along the way you will learn about dimensional design, loading warehouses, master data services and BIML.


Event Sponsors

Purple Frog Systems - A big thank you to Purple Frog Systems for organising the event.

Rullion - A big thank you to Rullion for providing the catering for this event.



This session will be held at Aston Manor Academy.


Aston Manor Academy Phillips Street Aston Birmingham B6 4PZ

Parking on site is available through the main gates but is limited. There is also on street parking available opposite.

We will be hiring the main hall which located through the entrance doors and to the left.


Other Details
We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.

Dress code: relaxed


Event Organiser Contact Details

If you need any further details or have any requests for this or future Midlands SSUG events, please contact get in touch. 

Paul Andrew Twitter: @mrpaulandrew Email:

Alex Whittles Twitter: @PurpleFrogAlex Email:

SSUG Twitter: @SQLMidlands


Speaker Profiles

Stuart Moore has spent 20+ years working with computers  trying to make data move faster and infrastructures simpler, mostly succeeding. Currently mainly working with SQL Server, Azure, PowerShell and C# to develop hybrid infrastructures.

Terry McCann is a Data warehouse/Big data/ Data science consultant for Adatis consulting limited a Microsoft gold partner. Specialising in Microsoft BI architecture. Frequent speaker at SQL Saturdays in the UK and Europe. Organiser of the Data Science user group in Exeter and previous co-organiser of SQL Saturday Exeter.

Do you have questions about Birmingham SQL Server User Group - Indexing Nightmare Cut Through the Clutter & Using BIML for Automation? Contact SQL Midlands

When & Where

Aston Manor Academy
Phillips Street
B6 4PZ Birmingham
United Kingdom

Thursday, 19 January 2017 from 18:15 to 21:00 (GMT)

  Add to my calendar


SQL Midlands

SQLMidlands - Bringing the West Midlands SQL Server community together


All future events will be promoted on Meetup, not here. Head over to the link above to sign up!


We normally hold meetings every other month, usually on a Thursday after work at in the centre of Birmingham. It's an informal gathering of like minded people, with a couple of speakers presenting tips, techniques and information on old, new and upcoming technology. We like to get a mixture of world leading speakers as well as providing an opportunity for our members to present.

We tailor the speakers and sessions to your requests so if you have any specific topics that you want to go through, then come along and let us know.

We're part of the UK SQL Server community at and we're an official PASS chapter (the Professional Association for SQL Server) covering the Midlands in the UK.


If you've registered for an event and can no longer make it, please do unregister so that we don't over order the food! To unregister just view your tickets in your EventBrite account, and then cancel the relevant ticket. Thanks!


This event is kindly sponsored by Purple Frog Systems, if you need any Microsoft Business Intelligence help (Data Warehouses, ETL, Cubes, Azure, IoT, etc.), give them a call!


  Contact the Organiser

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.