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:00 – 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 Anthony Brown - Getting data from here to there
This presentation will go through the replication architecture in sql server and the different replication methods available to use. Each method has its own pros and cons and these will be shown along with some examples of situations where each method can be used. It will also cover how to set it all up, what to watch out for, and what to look for when things go wrong.
Anthony has been a sql server DBA since 1998 and have worked with all versions of SQL server since 6.5. Since 2001 he has worked at John Lewis on their website designing a highly scalable and resilient architecture for it. He has experience in many areas of sql server including service broker, replication and visual studio database projects.
Anthony's blog http://sqlblogcasts.com/blogs/antxxxx/Default.aspx
7:30 – 7:50pm Break: Light refreshments
More time to network, ask questions and eat pizza...
7.50 – 8:50pm David Betteridge – A trip into Index Internals
This will be a journey through the different index structures available to us in SQL Server. Starting with the standard clustered/non clustered indexes, passing through filtered and partitioned indexes and concluding with the new column store indexes. At each stop we will look at the structure behind the index (at a page level) to help us understand when we should use the index and what our best practices should be.
David works for a software company (PROACTIS Group Ltd) based in West Yorkshire. He is the DBA and Technical Architect for their ‘software as a service’ solution and also leads the technical integrations team.
8.50pm – 9.00pm Close
Then it down to the pub for a drink!