Join the Hampshire UK SQL Server User Group evening meeting to network, learn, ask questions and meet other SQL Server professioanls.
17:30 - 18:00 Meet and greet.
18:00 - 18:15 Site Information and Welcome
18:30 - 19:30 Erin Stellato - Kicking and Screaming: Replacing Profiler with Extended Events
There have been three new releases of SQL Server since the introduction of Extended Events in SQL Server 2008, and DBAs and developers alike *still* prefer Profiler. Friends, it's time to move on. If you've tried Extended Events and struggled, or if you've been thinking about it but just aren't sure where to begin, then come to this session. Using your existing knowledge and experience, we bridge the gap between Profiler and Extended Events through a series of demos, starting with the Profiler UI you know and love, and ending with an understanding of how to leverage functionality in the Extended Events UI for data analysis. By the end of this session, you’ll know how to use Extended Events in place of Profiler to continue the tasks you've been doing for years--and more. Whether you attend kicking and screaming, with resignation because you’ve finally given up, or with boundless enthusiasm for Extended Events, you'll learn practical techniques you can put to use immediately.
19:30 - 20:00 Light refreshments
20:00 - 21:00 John Martin - Taming The Monster – Managing VLDBs
We all that that database, it started small and no one took any notice of it. Now it is quite literally the elephant in the room and you need to deal with it, but what do you do? In this session we will look at techniques for managing Very Large Databases (VLDBs). Looking at the options that we have for backup and recovery, maintenance tasks such as CHECKDB, Index and Statistics Maintenance. How can we alter the approach that we take to these regular tasks in order to not need excessive maintenance windows, and maintain service for the applications and processes that require access to the database.
21:10: Feedback and Close
IMPORTANT: Please ensure you register as we need to provide the details of who's attending with the site security team for security badges.