Scottish Area SQL Server User Group Meeting, Edinburgh 25th February

I’m looking forward to this weeks Scottish Area SQL Server User Group meeting. Iain Kick is our guest speaker talking about Performance Troubleshooting. I’ve seen this talk a couple of times and it’s always great to hear how a vendor approaches these problems. If everyone looked at things the same way, then there would be no progress or invention in the world, and each day would be one endless Ground Hog Day!

This sort links with the second presentation by Alistair Board and myself on how you can learn SQL Server. Everyone is different and knowing what is available could help open doors to progressing your knowledge and possible enhance your career.

Here’s the full itinerary (and don’t forget we’ll be having pizza!):

End-to-End SQL Server Performance Troubleshooting – Iain Kick

When attempting to diagnose a problem in a SQL Server application, there's no right or wrong way to go about troubleshooting. However, certain techniques yield much better results when used for end-to-end troubleshooting.

This presentation will teach you the best practices for finding the root cause of a problem in a SQL Server application, correlating that root cause to a specific set of activities being performed on the server, and tuning the problem activity for maximum performance-all using the native SQL Server tools. We will then compare and contrast those techniques to Quest Software's performance management and query tuning tools. All examples and syntax are verified for Microsoft SQL Server 2005.

Ways to learn SQL Server – Alistair Board and Martin Bell

One of the reasons that I like to work with SQL Server is that you never stop learning new things. This may sound daunting to new people coming to this as a career change or taking their first steps in a new position, but it’s one of the areas why we still work with SQL Server. Everyone has their own preferred methods of learning, but finding the resources that suit you best is not always easy. This talk will draw on the many years of experience that Alistair and Martin have with SQL Server, but if you have something you wish to contribute feel free to bring it along.

Agenda

18:30 - 19:00 - Introduction, Networking and Food

19:00 - 19:50 – End-to-End SQL Server Performance Troubleshooting – Iain Kick

19:50 - 20:00 - Break

20:00 - 20:50 – Ways to learn SQL Server - Alistair Board and Martin Bell

20:50 - 21:00 - Close

Location:

Microsoft Office at Waverley Gate http://www.microsoft.com/uk/about/map-edinburgh.mspx

Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.