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.30 – 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.30 - 7:30pm Designing tables for scale - data typing, data compression and table partitioning with Nick Coleburn
Good database design is the foundation of building robust, scalable database systems. Optimising your table design can make or break a database. In this session Nick will cover data typing, utilising SQL Server data compression and table partitioning, and how optimising the design of these technologies can substantially reduce disk I/O, memory usage and improve overall system performance.
Nick works as a Senior Technical Manager for The Co-operative Group, heading up the SQL Server Development Team; part of the Group Software Development Team. The team specialise in providing internal SQL Server consultancy to other software development teams, and design/build very large scale SQL Server database systems and Business Intelligence solutions. These also include systems which are sold to external customers.
Nick has been working with SQL Server for over 10 years specialising in designing large Data Warehouse and Business Intelligence solutions. He holds various Microsoft SQL Server certifications, including an MCDBA and 5 MCITPs covering SQL Server 2000, 2005 and 2008.
7:30 – 7:50pm BREAK: Light refreshments
More time to network and ask questions...
7:50pm – 8.50pm Intelligent Laziness with the Management Data Warehouse - why work harder, when you can work smarter? = Jen Stirrup
In this session, so we are going to look at ways to help DBA to work smarter ratherthan harder when troubleshooting SQL Server performance problems! We will lookat the Management Data Warehouse (MDW), which is a SQL Server database whichholds data about the performance of SQL Server databases. Specifically, the MDWstores the standard performance counters which help performance monitoring andtroubleshooting, thereby helping DBAs to commence a detailed analysis of theperformance more quickly – leading to quicker performance troubleshooting and resolution.
Jen Stirrup is an MCP, with a Bachelors degree in Psychology and two Masters in Artificial Intelligence and Cognitive Science. Currently, Jen is a freelance Business Intelligence consultant, delivering solutions to global clients. Jen is a veteran SQL Server Developer with over 12 years SQL experience in delivering end-to-end Business Intelligence solution. Jen blogs for SQLServerPedia as well a
8:50 - 9:00 pm Round up and off to the pub