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.
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 NOT the Midlands Art Centre.
Aston Manor Academy
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 as highlighted on the aerial photo below.
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.
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.