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 peers.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
5.30pm – 6:00pm Registration and networking
Meet and greet.
6:00pm – 6:30pm 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 work.
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.
6:30pm - 7:30pm 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.
7:30pm – 8:00pm BREAK: Light refreshments
8:00pm – 9:00pm 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 blog http://SQL.RichardDouglas.co.uk
9:00pm - Close and down the pub