** Prize Draw Win £50 of Amazon Vouchers courtesy of Quest Software **
Entry only available to attendees.
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.
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
Microsoft Office at Waverley Gate
Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.