Agenda
18:15 - 18:45 - Introduction, Networking and Food
18:45 - 19:45 – This presentation on Replication will start with an overview of the various SQL Server replication models: Snapshot, Transactional, Merge with Peer-Peer added in SQL 2008 release.
Following the overview, Neil will then present in further detail (along with some demos) on the following key topics
- Components
- Describe the various components and how they interact
- Administration
- Performance
- Replication Agents & Jobs
- Troubleshooting {Techniques & Tools}
- Tools available to use for monitoring and troubleshooting
- Techniques to overcome common problem scenarios
Neil Hambly an experienced Architect/DBA/Developer who has been using the SQL Server Product family since version 6.5 during the last 12 years. A regular attendee and sometime presenter @ UK SQL Server user groups & events as well as an avid Twitter & Powershell fan, when not outside can be found coding and Performance tuning and generally "try to learning" even more SQL knowledge. Neil's blog can be found at
http://sqlblogcasts.com/blogs/neilhambly/default.aspx and followed on Twitter: @Neil_Hambly
19:45 - 20:00 - Break
20:00 - 20:55 – Microsoft SQL Server Upgrade, 2000 - 2005 - 2008: Notes and Best Practices from the Field
This session will provide a SQL Server 2008 upgrade overview. The session will cover the essential phases and steps involved in upgrading SQL Server 2000, SQL Server 2005, and SQL Server 2008 to SQL Server 2008 R2 by using best practices and available resources. We will cover the highlights of upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks.