I am delivering two Rock Solid SQL 2005 sessions next week in SoCal….

September 13th — Irvine, Ca – 8am-12noon

September 15th — San Diego (Mira Mesa), Ca – 8am-12noon

Rock Solid SQL: Strengthen your SQL Servers with SQL Server 2005

SQL Server databases provide the foundation for your business solutions, so don’t you want to build the finest groundwork possible?  The new SQL Server 2005 will enhance security, reliability, and performance to give you a solid, dependable base.  Think about your current SQL system: Can you still access your database if the server goes down?  How fast can you failover?  What is your Maintenance Plan?  Who is Locking and who is Blocking?  In this session, we’ll upgrade an existing SQL Server database to SQL Server 2005 and show you how to maintain a more secure, reliable database solution for your business.

We will look at:

  • How to exploit the new security features to tighten controls on your existing systems.
  • How the new Database Mirroring technology can provide faster, automatic failover.
  • How simple and easy it is to configure automatic maintenance plans and alerts.
  • How the new Dynamic Management Views provide greater insight into your database performance with simple, yet powerful reports.
  • How to quickly tune the database with the Database Tuning Advisor.
  • How you can reduce locking contention with new optimistic concurrency controls.
  • How to enhance performance and reliability by partitioning tables on the disk.

Cheers!