Inaugural Meeting of the Essex SQL Server User Group - Wednesday 5th October
Come along to see the birth!
18:00 - 18:30 - Introduction and Networking
18:30 - 19:30 - Dave Ballantyne
Cursors are evil, and shouldn't be used
That's frequent advice given on forums when asking about performance problems. Its correct advice, but how do you go about removing cursors and what do you replace them with? That's the tricky part! By deconstructing a cursor based routine, Dave will demonstrate a number of TSQL techniques and how they can be applied to generate a new routine with significantly less overhead.
Dave Ballantyne is a freelance SQLServer database developer/designer and has been working in the IT field for over 20 years. Tuning and optimizing SQLServer processes is his particular talent. Dave regularly contributes to online forums and is a regular speaker at UK events such as SQL Bits and user groups. He also is founder of the Kent .NET/SqlServer user group.
19:30 - 19:50 - Break
More time to Network and Food
19:50 - 20:50 - Chris Testa-O'Neill
We have control! - Controlling Resources in SQL Server
Since SQL Server 2008, you can control environments using Policy based management and with the Resource Governor. This session will demonstrate the implementation and workings of Policy based management and with the Resource Governor and provide you compelling reasons why these tools can be used to enforce standards and control SQL Server hardware in your environments
Chris Testa-O'Neill is a SQL Server Microsoft Most Valuable Professional (MVP) and a Senior Consultant at Coeo specialising in SQL Server Business Intelligence. He is also a technical author, working on courses for SQL Server 2008 R2 with Microsoft Learning and advising on the SQL Server Denali curriculum. Chris runs the Manchester SQL Server User Group and is an organiser for SQLBits. Chris has spoken at a range of events including user groups in the UK and Adelaide, Australia, SQLBits, the MCT Conference and this year's SQLPASS. Chris is a Microsoft Certified Trainer (MCT), MCDBA, MCTS and MCITP in SQL Server.
20:50 - 21:00 - Feedback and Close
Location: Xchanging, Endeavour Drive, Basildon, SS14 3WF