Network, learn, ask a question, meet other folk, get fed - these are all
things that happen at user group events. These events are a really
great opportunity to socialise in an informal learning experience - if you want
your own exposure then come and do a 1 - 5 minute nugget in front of your
Remember to tell your friends and the people you work with; make sure you
register as soon as you can.
17.30 – 18:00 Registration and networking
Meet and greet.
18:00 – 18:30 Round Table discussion and Nuggets - ALL
Take stock and get the latest news in the SQL Server field. This is also a
great opportunity to ask any burning questions you have, may be a problem at
It's also a great opportunity to share your knowledge and gain exposure in the
industry by giving a short 1 - 6 minute "nugget" demo/tip.
18:30 - 19:30 - Session One - Understanding Execution Plans - Paul Anderton MCM
You develop some tsql, you get the results you require but it takes minutes or hours to run, your boss says it has to run in seconds....... what do you do? Where should you look
Someone says what does the Execution Plan show? whats an Execution Plan? you say!
If this is you then this session will be a good intro into what Execution Plans are, how to get them and what information can be gained from them. Following that we will take a look at the some of the Common Query Operators you'll see then look at the Plan Cache and finish off with Querying the Plan Cache
Paul is a Microsoft Certified Master (MCM) and currently works as a DBA for DWF LLP in Manchester, one of the Largest Law Firms in the UK. He has over 14 years experience in the IT industry, starting as a Network Administrator before becoming a SQL DBA, focusing on SQL Server for the past 10 years. His roles include Production DBA, Development DBA and SQL Developer and has worked with SQL Server since SQL Server 7.0.
19:30 - 19:50 - Break
Time for pizza
19:50 - 20:50 - Session Two - Natural Born Killers,
Performance Issues to Avoid
Learning SQL is easy, mastering it is hard. In this session you’ll
learn simple but effective tricks to design your database objects better
and write more optimized code. As an attendee you will gain a deeper
understanding of common database development and administration mistakes, and
how you can avoid them.
Ever thought that you were adhering to best practices but still seeing
performance problems? You might well be. In this session I will be covering why
the optimizer isn’t using all available processors, when the database engine
fails to report all the resources a query has used and why the optimizer
doesn't always use the best plan.
You will leave this session with a list of things that you can check for in
your environment to improve performance for your users.
Richard Douglas is a Systems Consultant and SQL Server Evangelist for Dell
Software where he specialises in providing SQL Server solutions and system
health checks to organisations across the EMEA region. Richard is the founder
and organiser of the Maidenhead SQL Server User Group and has spoken at several
PASS events including the PASS Summit, SQL Rally's and SQL Saturdays. Richard
also regularly presents webinars for Dell Software and PASS Virtual Chapters on
various SQL Server related topics and was a technical reviewer on two SQL
Server 2012 books. Richard can be contacted via Twitter @SQLRich or on his
20:50 - 21:00 - Feedback, Prize Draw and Close
Finally: Drinks down the pub