posted on Thursday, June 01, 2006 9:32 AM
by
bknight
Free All Day HA Event in Jacksonville, FL
Whether you’re a developer, DBA or manager, you’ll get something out of this all day SQL Server free event from Microsoft and Idea Integration (Brian from SQLServerCentral.com will be doing part of the event). This event is being run with Microsoft and Idea Integration and will be at a detailed tech level (no marketing). This all-day session is designed to Get You Started with Microsoft SQL Server 2005 High Availability and gotchas when upgrading to 2005. High availability is a hot topic for most enterprise customers. Any application downtime can impact your business, resulting in revenue loss, customer dissatisfaction, and damaging creditability of their business. Application downtime can be caused by a variety of issues such as human error, natural disasters, hardware failure, and application upgrades. Today, SQL Server 2005 has a full range of options, which could achieve and maintain appropriate levels of application availability. However, there is a lack of awareness around these features. Moreover, there is limited information to guide customers to choose the right features to achieve their availability goals.
Space is limited for this event and this email is going out to more than 300 so please register fast to claim your seat.
These 300 Level sessions will be mostly demos from Microsoft and Idea Integration!
Q&A periods and post-event networking are built into the schedule to enable you to get your questions answered.
For: Architects and Database Administrators
When: Wednesday, June 7, 2006, 8:45am to 5:00pm
Speakers will remain after the event for ad hoc discussions
Agenda: See next page for detailed agenda. Sessions will focus on upgrading to SQL Server 2005 and High Availability Data Management.
Where: Modis Building in Auditorium (on 2nd story) 1 E Independent Dr, Jacksonville, FL 32202 Office number: 904.360.2700 or Toll Free: 800.idea.com.
Cost: Free event
Parking: Parking available at Landing or in 9-story garage across the street.
Language: English-United States
Lunch: Provided
Registration: DUE TO SPACE LIMITATIONS, REGISTRATION IS REQUIRED
Event URL : http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032297798&Culture=en-US
Event ID : 1032297798
I hope you will be able to join us. Please contact me directly if you have additional questions.
SQL Server 2005 Always on – HA Day
|
Time |
Topic |
Speaker |
|
8:30 am |
Registration Opens |
|
|
8:45 |
Welcome & introduction to “SQL Server 2005 Always on” HA day
|
Microsoft |
|
9:00 am |
SQL Server 2005 Upgrade Best Practices Why upgrade to SQL Server 2005
· Proof points (case study 2000 vs 2005 performance)
Risk mitigation – Microsoft Contribution
· Build Process & CTP Discussion
· Upgrade scenarios
· SQL Server 2005 Upgrade Advisor
· SQL Server 2005 Database Upgrade test toolkit
SQL Server lessons learned
Deprecated SQL Server 2000 features
|
JC Armand - Microsoft |
|
10:30 |
Break |
|
|
10:45 am |
Database Mirroring
· Database Mirroring Overview
· Key Benefits
· Basic Principle of Mirroring
· Demo (Database Mirroring Setup)
· Technology Drill Down
o Server Side
o Client Side
· What Happens when things Go Wrong? Database Mirroring Keeps Going!
|
JC Armand - Microsoft |
|
12:15 pm |
Lunch provided |
|
|
1:00 pm |
SQL Server 2005 Clustering Improvements
Windows Server 2003
· SP1 Improvements
· Storage Best Practices
· Virtualization
· ClusPrep Discussion
SQL Server 2005 Clustering Improvements
· Standard VS EE
· New features & enhancements
· Management improvements
· Setup
Demo of a cluster setup from Windows 2003 to SQL Server 2005.
|
Brian Knight – Idea Integration
SQL Server MVP and Author |
|
2:30 pm |
Break |
|
|
2:45 pm |
“Always on” Features that keep the lights on
- Log Shipping
- Peer-to-Peer Replication
- Database Snapshots
- Online Index Operations
- Partial Database Availability
- Row-level Versioning (Snapshot Isolation & Read Committed Snapshot Isolation)
- Backup/Restore (Checksum on Backups, Backup Media Mirroring, Page-level Restore, Piecemeal Restore)
- Scalable Shared Database
- Checksum on Data Pages
- Instant File Initialization
- Dedicated Administrator Connection
- Dynamic Configuration (CPU Affinity, AWE Memory)
|
Brian Knight – Idea Integration
SQL Server MVP and Author |
|
4:15 |
Break |
|
|
4:30 pm |
Event Wrap-up. Speakers will remain for networking and informal discussions. |
Panel discussion |
|
5:00 pm |
Event concludes |
|
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032297798&Culture=en-US