Loading Events

« All Events

  • This event has passed.

Hants SSUG 19th May 2016

May 19 @ 6:00 pm - 9:00 pm

Free

To Register: https://www.eventbrite.co.uk/e/may-uk-hants-sql-server-user-group-evening-meeting-tickets-22653054897?aff=ebrowse

Event description

Description

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.


Share with friends
Date and Time
Location

QinetiQ Group Plc

Ively Road

Farnborough

View Map

Organiser

Hants SSUG