October SQL Server user group meeting.
18:150 - Doors Open
18:30 - Introductions
18:45 - James Burns (Friend of Red Gate)
James will be presenting a session on Database source control, why it is important and how to achieve it.
19:45 - Pizza, drinks & chat.
20:00 - Paul Randal (Remote Session via web conference) - (@PaulRandal) [http://www.sqlskills.com]
Title: Fragmentation: Internals, Analysis, and Solutions.
As soon as you have more than one index on a table, you're going to start seeing fragmentation. Many people know that this fragmentation is bad, but why is it bad? And what is the best way to get rid of it? Find out from the person who wrote the tools for detecting and removing index fragmentation. In this session, you’ll learn how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You'll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-management strategy.
Paul Randal is the CEO of SQLskills.com, which he runs with his wife Kimberly L. Tripp. Both Paul and Kimberly are very widely known and respected experts in the SQL Server world, with both being SQL Server MVPs, and Microsoft Regional Directors. Paul is a Contributing Editor for TechNet Magazine, where he writes the bi-monthly SQL Q&A column and feature articles.
21:00 - End