Welcome to Southampton SQL Server User Group, this event is hosted at St Andrews United Reformed Church located on the corner of Alma Road and The Avenue.
We have a couple of great speakers covering different SQL Server based topics along with a number of prizes to give away and free pizza during the break.
18:15 - Doors Open
18:30 - Introductions
18:45 - John Q Martin
Title: Migrating and Upgrading SQL Server
Abstract: With Microsoft's increased rate of releasing new versions of SQL Server, older versions are going to be dropping out of support sooner rather than later. Making migrations to new versions of SQL Server more common and important if you need support. This session will cover a number of the options and important tasks to consider when upgrading a SQL Server or Migrating databases from older servers to new ones. Along with a few gotcha's to look out for along the way.
Bio: John is a Senior BI Developer working on large scale enterpreise transactional and analytic systems for a leading player in the Online Loyalty marketplace. Working with SQL Server for over six years in all areas from operational DBA all the way through Development to BI. John's main areas of interest are SQL Server High Availability & DR and Performance Tuning bad queries.
19:45 - Break
20:00 - Neil Hambly
Title: Load Testing with SQL Server Tools
It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels.
Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Bio: Neil Hambly is a SQL veteran with over 15 years’ expertise in SQL Server from Version 6.5 through to the very latest 2012 edition. Neil has held numerous DB roles at major organizations such as BBC, ABN AMRO, ACCENTURE, alongside a number of smaller companies, with prior roles as both a DBA ,Developer & Architect, He is now the Principle Database Engineer @ ASOS. He is a PASS UK Regional Mentor & leader of SQL London PASS Chapter, often seen speaking @ international and national SQL events
21:00 - Prize Draw & Close
21:15 - Event close