SQLBits

Understanding TSQL performance is crucial to building a successful scalable database solution.
In this session we will cover the fundamentals of performance tuning your SQL to ensure your application can scale.  We will use query plans, sql profiler, dmvs, resource utilization and contention to diagnose performance and scalability issues. We will then look at using advanced TSQL techniques and indexing to show you how to improve your performance and scalability.

If you want to get the most out of your Analysis Services cube it’s essential to know and understand MDX: you need it to be able to write queries and calculations, and also to be able to use more advanced features such as cell security. This one-day seminar, aimed at those with little or no previous MDX experience, will teach you the basic concepts of the language as well as show you how to write common queries and calculations.  The seminar will be taught by Chris Webb.

The Advanced Troubleshooting Workshop for SQL Server 2005 provides attendees with SQL Server internals knowledge, practical troubleshooting skills and a proven troubleshooting methodology.   The workshop will enable attendees to tackle complex SQL Server problems with confidence.

This seminar will provide you with the information required to implement and maintain reporting services . You will start by exploring the different installation options for reporting services. Create compelling reports, manage and distribute the reports. You also explore how to manage the reports effectively and maintain the reporting server