SQL Server DBA Training Forum

Hi All,

On November 4-6 we are running three one day training courses aimed at DBA's which are designed to jumpstart your knowledge of SQL Server 2008 planning and deployment.

If you design solutions on SQL Server, maintain SQL Server databases or are evaluating SQL Server for deployment, this training will prove useful.

The training will be run by Jeremy Boyd.

Agenda/Content

8:30-10am – Overview of SQL Server 2008

What is new in SQL Server 2008 that makes it worth seriously considering? What is the difference between Web, Standard and Enterprise?  All these things are covered in this introduction to SQL Server 2008.  This is a 200 level session intended to give you a overview of what the new capabilities and tools are in the product and where they will be useful to you.

10:15-11:30 – Migrating from SQL Server 2000/2005 to SQL Server 2008

There are many new changes in SQL Server 2008, particularly when upgrading from SQL Server 2000.  Is it worth migrating?  If so, where do you start?  How can you approach this?  What about DTS to SSIS migrations?  This session will give you some considerations and approaches to take away with you to help you make the right decisions and the migration to SQL 2008 whether it be from SQL 2000 or SQL 2005.

11:45-1pm – SQL Server Architecture

Architecture is about ensuring that solutions are available and scalable.  This includes thinking through how to allow other stakeholders get the most from the solution.  This session will explore how much developers can do with SQL Server 2008 and how DBA’s should architect their implementation to provide the key features developers will build into their applications without compromising the service the database server provides. We will also look at and discuss the various architectures that you can consider when using SQL Server 2008 technologies.

-- lunch –-

1:45-3pm – High availability and resilience

Mirroring, clustering and replication have come a long way in SQL Server 2008.  In addition there are new features such as the Resource Governor that will ensure that your mission critical applications never suffer from contention with other applications. This session will give you a solid understanding of these technologies and when to use them.

3:15-4:30 – SQL Server Management

Managing SQL Server 2008 servers is easier than ever before. Check out how policy based management in SQL Server 2008 will reduce risks, how configuration servers allow you to group servers together for easier management and get an introduction into SQL PowerShell to really jump start your management framework.

Throughout the day there will be opportunities to ask questions and get expert answers and talk to your peers and see how they've done things.

Registration

To register, click one of the links below.  There is no charge for this training.

Tuesday, November 4 - Wellington - The Brewery Bar (upstairs conference room) (Register)
Wednesday, November 5 - Auckland - The Duxton Hotel (Register)
Thursday, November 6 - Christchurch - Christchurch Convention Centre (Register)

Nick.