Birmingham SQL Server User Group - R and Troubleshooting with default trace
Thursday, 3 July 2014 from 18:30 to 21:00 (BST)
Birmingham, United Kingdom
San Francisco, California
London, United Kingdom
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.
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 SSUG@PurpleFrogSystems.com
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).
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 (@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.
When & Where
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.
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!