SQL Midlands

Bringing the Midlands SQL Server community together

Midlands SQL Server User Group, being held in the Old Joint Stock pub in the centre of Birmingham on Monday 5th December

Session 1: Log Parser with Jonathan Allen

Session 2: All you need to know about Kerberos with Duncan Sutcliffe

You can follow the Midlands SQL Server User Group on Twitter at http://twitter.com/SQLMidlands


6.00pm – 6:30pm Meet, Greet & Beer


6:30pm - 7:30pm Log Parser (Jonathan Allen)

This session will introduce people to a free tool from Microsoft that will speed up adhoc data import processes and file parsing among other data manipulation uses.

LogParser uses a SQL-like query language to work with data in many formats (CSV, IISW3C, HTML, XML, ADS, REG, EVT, BIN and many more) and can convert the data into may outputs types (CSV, NAT, SQL, W3C, XML etc). It has many uses and can be employed in many ways to assist a busy DBA.


7:30pm - 7:50pm Break, Food & Beer


7:50pm – 9:00pm Kerberos - All you need to know in an hour (Duncan Sutcliffe)

A quick but detailed walkthrough explaining what you need to do to make Kerberos work in a Microsoft BI environment. The session covers when and why you need Kerberos, and how to configure it for Reporting Services, Excel Services and PerformancePoint. Although the session is demo-driven, delegates will also take away useful planning tools and troubleshooting tips.

This session is based on a much longer training course I run, but will still get all the why, when and (most importantly) how of Kerberos squeezed into a live demo.


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.


When you get to the Old Joint Stock, grab yourself a drink from the bar and go through the doors at the back right of the pub, and then up the stairs.

If you need any further details or have any requests for this or future Midlands SSUG events, please let me (Alex Whittles) know, either on Twitter (@PurpleFrogSys or @SSUGMidlands) or email This email address is being protected from spambots. You need JavaScript enabled to view it.

See you in December!


Speaker profiles

Duncan Sutcliffe

Duncan's a senior architect for Microsoft business intelligence solutions at Hitachi Consulting, working with clients such as the Bank of England, Sky, Experian Footfall and the NHS.  WIth a good twelve years or more designing BI solutions under my belt, He is keen on architecture design, development frameworks and very high quality code.  Although he works with all the SQL Server products including PerformancePoint and PowerPivot, his real specialties are physical and logical architecture, performance tuning, SSIS and SSAS design.

He's spoken at the London user group as well as at various Microsoft events, maintains a blog, and is an active professional consultant.

Jonathan Allen

Jonathan has been working with SQL Server since 1999. He enjoys performance tuning, development and using SQL Server to provide appropriate business solutions. He is the founder and leader of the PASS SQLSouthWest user group (http://www.sqlsouthwest.co.uk), is a PASS regional mentor, and enjoys blogging about it all for Simple Talk.



SQL Midlands is Proudly Sponsored by Purple Frog

The Dimensional Data Warehouse and OLAP Cube experts