Actions and Detail Panel
Leeds User Group - 1st December 2016
Thu 1 December 2016, 17:30 – 21:00 GMT
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.
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 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.
18:30 - 19:30 - 99 Things but the batch isn't one - Martin Croft
Manchester’s August SQL user group was inspirational it seems, there was a TSQL feature shown that was actually a new SQL 2016 feature but either it was said incorrectly or I misheard that it was a 2012 feature, I was how did I not know that! how could I not know that? That’s when I decided my next presentation (this one) would be on things I learn around SQL from that user group till now.
Why not make it challenging? 99 new things, how hard can that be? The presentation will show exactly that, and my adventure covering a lot of clever stuff (I hope), Touching on SQL, productivity tools, amazingly useful websites, emailing Pinal Dave and trying to get on Brent Ozar Podcast
Hopefully there will be something for everyone and hopefully, I'll get to 99.
About Martin: Martin Croft is a time served SQL developer / DBA contractor / consultant who has worked with SQL Server since SQL 6.5 all the way through to SQL 2016, having attending the user groups for many years he wanted to (try) and give something back for all the things he's have picked up from the sessions he’s seen and share things hopefully people find useful.
19:30 - 19:50 - Break
Time for pizza
19:50 - 20:50 - Tune the query, not the plan - Kevan Riley
Execution plans are a great resource when trying to tune a query, but often we get hung up on trying to fix what we consider to be 'bad' operators, for example table scans vs clustered index scans; scans vs seeks; sort operations. In this session we will take a look at some misconceptions, step through what SQL Server is doing and see if we are actually improving the performance when change the plan to have 'better' operators.
About Kevan: Kevan Riley (MCSE:Data Platform) has been working with SQL Server since 1999 in a variety of DBA and DB developer roles. He now works as a freelance SQL Server Consultant in the UK and is no more happier than when knee-deep in performance tuning. He can be often found contributing at ask.sqlservercentral.com and getting involved with the SQL community at UK user groups, SQL Saturdays, SQLBits and SQL Relay.
20:50 - 21:00 - Feedback, Prize Draw and Close
Finally: Drinks down the pub