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
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.
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
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.
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.
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.
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
Dhariwal is a SQL Server consultant with nearly 20 years experience in
the IT industry having worked for the likes of Microsoft and Sybase.
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.