Skip Main Navigation
Page Content
This event has ended

Birmingham SQL Server User Group - R and Troubleshooting with default trace

SQL Midlands

Thursday, 3 July 2014 from 18:30 to 21:00 (BST)

Birmingham SQL Server User Group - R and...

Ticket Information

Type End Quantity
SQL Midlands Attendee Ended Free  

Who's Going

Loading your connections...

Share Birmingham SQL Server User Group - R and Troubleshooting with default trace

Event Details

Midlands SQL Server User Group, being held in the Birmingham Chamber of Commerce, Harborne Road, B15 3DH

Session 1: Ajmer Dhariwal - Troubleshooting SQL Server using the default trace

Session 2: Steph Locke - Getting started with R and SQL Server



6.15pm – 6:30pm Meet & Greet

6:30pm - 7:30pm Ajmer Dhariwal - Troubleshooting SQL Server using the default trace

As most DBAs will be only too aware of, it's not a lot of fun identifying the cause of production issues against a server that has not had any formal diagnostics or tracing running against it, but all is not lost.

Starting back in SQL Server 2005 the default trace quietly gathers data on key events which can be vital in resolving or at least narrowing down production issues.

Don't believe the bad press this great little tool has been given to date, because in this session we'll go through multiple examples which are based on real world scenarios where I have used the default trace to resolve a number of issues; we'll go through resolving problems as diverse as failed logins and tempdb filling up to identifying who made server configuration changes and DDL changes.

After this session you'll be armed with the knowledge you need to fully exploit the default trace and look at it in a whole new light!


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

8:00pm – 9:00pm Steph Locke - Getting Started with R and SQL Server

R, the statistical programming language, is another open-source program making inroads into the Microsoft world.

R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites.  It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about to save yourself pains you didn't even know you had.


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.

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 @SQLMidlands) or email

There is parking at the venue, this costs £3 for up to 4 hours. The car park is to the left of the building, on Highfield Road (B4532).

Speaker profiles

Ajmer Dhariwal

Ajmer Dhariwal (@SQLinjun) is a SQL Server consultant with nearly 20 years experience in the IT industry having worked for the likes of Microsoft and Sybase.
After several years working in the financial sector in London he has relocated to the North-East to set up his own consultancy specialising in all things related to Microsoft SQL Server, with a particular focus on performance tuning and optimisation.

Steph Locke

Steph Locke (@SteffLocke) is an experienced Analyst and BI developer within the Finance and Insurance industries. Steph runs her local SQL Server User Group, helps organise SQLRelay, is a co-author of the book Tribal SQL and contributes to the community at large via blogging, presenting and forums.

Do you have questions about Birmingham SQL Server User Group - R and Troubleshooting with default trace? Contact SQL Midlands

When & Where

Birmingham Chamber Of Commerce
75 Harborne Rd
B15 3DH Birmingham
United Kingdom

Thursday, 3 July 2014 from 18:30 to 21:00 (BST)

  Add to my calendar


SQL Midlands

SQLMidlands - Bringing the West Midlands SQL Server community together

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!


OpenMinds High Availability SQL ServerThis event is kindly sponsored by OpenMinds / SIOS. If you need to know about clustering SQL Server or Azure, give them a call!


  Contact the Organiser
Birmingham SQL Server User Group - R and Troubleshooting with default trace
Birmingham, United Kingdom Events Seminar Science & Tech

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.