Community developer events

Best Practices in Performance and Availability for SQL Server 2005/2008

Date
1-3 Sep 2008 (Add to calendar) GMT
Venue
de Havilland Conference Centre , Hatfield, GB
Cost
from £570, with early bird

Kimberly L. Tripp and Paul S. Randal

This class has three primary goals (for almost all topics/modules): planning, practice/implementation and post-mortem - with the largest emphasis on designing/implementing the RIGHT solution. Questions that you must ask are: How do you choose technologies to fit requirements and effectively use key features of SQL Server 2005/2008? How does your technology/choice affect workload performance?

Only after an in-depth plan is developed should you move on to actual implementation. So what are the areas that you need to consider?

  • Architecting for Availability
  • Architecting for Performance
  • Maintaining Performance and Availability

And just to be clear, this is not a high-level class on planning. This is an intense, in-depth class encompassing structures, internals, technologies and solutions. Planning is a critical part of performance, high-availability, database maintenance and disaster recovery - but the most-often disregarded.

Performance tuning spans many areas within SQL Server from database creation to database design to the code you execute (ad-hoc or procedural). A single magic bullet does not exist (indexing is the closest thing to a magic bullet for some queries). However, to achieve a truly scalable and reliable database it takes a variety of best practices - from database creation (including file structure and placement) to table design and creation (using vertical and horizontal partitioning techniques) to system architecture (including disaster recovery planning and implementation) to ongoing maintenance. Whether you're trying to achieve high performance for a few users or scale to support thousands, there are numerous areas that you can tune to improve performance - proactively. But, how do you make this a reality?

SQL Server 2005 and 2008 provide a variety of options to help keep your database more available. However, even in the event of a disaster, are you sure you know the best path for recovery - with the least amount of downtime and/or data loss? Putting a well-thought out plan into practice requires a thorough understanding of the technologies, their pitfalls and the effects of many technologies when combined. In terms of architecture, we will start by discussing the most important part of designing an available solution - requirements. Then we'll show how to use requirements to drive a technology decision - not the other way around, which happens so often and results in an inadequate implementation.

No matter how much effort you spend on the design of your database, if you don't maintain it in production then it will suffer from performance and manageability problems - and possibly data loss and/or downtime. The key to availability and performance is well thought-out and automated database maintenance. The final part of the course will discuss maintenance strategies required to keep your carefully designed system available and performing well, plus a primer on recovering from disasters.

If you're planning, or already manage, an enterprise system and want better performance and availability - then this is the place to be!

Module List:

  1. Foundations - SQL Server structures and algorithms
  2. Architecting for Availability
  3. Architecting for Performance
  4. Maintaining Performance and Availability

Course Length/Type

Three day instructor led seminar.

£600 with early bird discount, a further 5% discount is using the link above or booking multiple events.

Comments

  1. 01 Jan 1999 at 00:00

Leave a comment

Sign in or Join us (it's free).

AddThis

Map

Other nearby events

  • Feb 4

    Securing Web Applications Training Course

    16km away in London

    The Securing Web Applications training course is a one day hands on event targeted at web developers. The courses is delivered by Sec-1 whos main activity is the assessment of web applications for corporate and government clients.

  • Nov 13

    GSC Security Summit 2009, London

    17km away in London

    The Global Security Challenge LLP (GSC), the providers of the world’s leading security innovation competition, will be holding its fourth annual GSC Security Summit at London Business School on Friday 13 November 2009.The GSC, thorough it’s competitions and events, aims to identify, explore and foster innovation in the field of homeland security technology. The GSC Security Summit is recognised as a leading conference in the area of security innovation.

  • Dec 12

    Ruby Manor 2 : Manor Harder

    18km away in London

    Ruby Manor 2 : Manor Harder The Guvner is opening the doors to The Manor once again, and just like last time it’s up to you to fill my echoing halls with the sound of Ruby. It'll be the same process as last year, so you can just read last year’s announcement again () and skip straight to making a topic suggestion (something you’d like to listen to) or talk proposal (something you’d like to speak about) in a new thread on the mailing list

  • Nov 17

    Core RoR: Web Development With Ruby on Rails

    18km away in London

    In this core Ruby on Rails 2.3 course, you are going to actually build and deploy a web application written in Ruby on Rails, learning how to use Ruby on Rails along the way. LEARN HOW TO: * Understand Ruby fundamentals * Install Ruby and Rails * Develop a full working web application with Ruby on Rails * Use new features in Ruby on Rails 2.

  • Nov 27

    Agile Specifications, Bdd And Testing Exchange

    18km away in London

    Following the excellent response to our Agile Testing and BDD community events and courses during the last 10 months, Skills Matter is proud to organise the first, annual Agile Specification, BDD and Testing eXchange - an intensive and intimate event aimed at bringing together leading thinkers and passionate community members. The aim of this eXchange is to promote awareness and adoption of modern Agile Testing techniques and ideas.

Related podcasts

  • Stack Overflow: Podcast #28

    This is the twenty-eighth episode of the StackOverflow podcast, where Joel and Jeff discuss Windows Azure, SQL Server 2008 full text search, Bayesian filtering, porn detection, and project management — among other things. Jeff met the inestimable Joey DeVilla aka Accordion Guy...

Want to stay in touch with what's going on? Follow us on twitter!