SQL Server Club User Group Bristol July 2011 Meeting
Thursday, July 21, 2011 from 6:30 PM to 8:30 PM (BST)
72 Prince Street, BRISTOL
An Evening of SQL Server Talk with James Rowland-Jones, SQL Server MVP
James is a SQL Server Consultant for SQLKnowHow and has worked for some of the world's largest institutions on OLTP and BI/DW.
He's a SQLBits speaker and part of the organising committee, which is where we've had the pleasure of seeing his presentations in the past.
We're delighted that James is coming to Bristol to deliver a talk on The Art of War-Fast Track Data Warehouse and Fragmentation. We will learn all about fragmentation from the inside out.
James will take us back to brass tacks so we can understand how SQL Server handles heaps and clustered indexes, re-visit page allocation and then apply this knowledge to our understanding of fragmentation.
He will conclude by looking at some design patterns to help minimise the impact of fragmentation on our data warehousing projects.
Key topics that James will cover:
- Logical, extent and file fragmentation
- Heap and clustered index architecture and internals
- Page allocation - how it works and how to influence it
- Trace flags that help avoid fragmentation
- Fragmentation in action
- Design patterns for minimal fragmentation
When & Where
SQL Server Club User Group South West
Rachel Clements, Founder and Organiser
I'm priviledged to be a founder of the SQL Server Club User Group South West (UK). A keen member of the national community SQLBits and Bristol developer group DotNetDevNet, I understand the importance of community networks to deliver content and friendship.
I'm a .NET/SQL Server developer and I attended the recent Speaker Training event at Microsoft's Reading campus. Great presentations make a great evening out for us techies and so I hope you register and I see you at a meeting very soon.