This event has ended

Kent .Net/Sql User group

Kent SQL Server / .Net User Group

Monday, 3 October 2011 at 19:00 (BST)

Ashford, United Kingdom

Kent .Net/Sql User group

Ticket Information

Type End Quantity
Free Ended Free  

Share Kent .Net/Sql User group

Event Details

As part of "SQL Relay" and "Sql Server week",  the Kent .Net/SQL usergroup is meeting on Monday, 3rd october.
We have James Rowland-Jones (MVP) and Neil Hambly in our new location is Ashford.
The meeting will be at :

The Windmill Inn
278 Hythe Road,
Willesborough
Ashford
TN24 0QR

Starting at 7pm.

Hope to see you there.

 

“Replication: Troubleshooting and Performance”
Neil Hambly

During this session we will look @ replication BEST PRACTICES
Show you how to overcome some typical issues using proven troubleshooting techniques and how to configure for performance
Session covers the following areas

• Components Overview - Describe the various components and how they interact

• Performance Replication Agents & Jobs

• Troubleshooting {Techniques & Tools}

o Examine tools available to perform monitoring and troubleshooting
o Techniques to overcome common problem scenarios
o Tips on achieving higher replication performance

------------------------------------


The Art of War-Fast Track Data Warehouse and Fragmentation
James Rowland-Jones

When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy.
Know your enemy.

Learn all about fragmentation - from the inside out. Let's get back to brass tacks and understand how SQL Server handles heaps and clustered indexes, re-visit page allocation and then apply this knowledge to our understanding of fragmentation. We will conclude by looking at some design patterns to help you minimise the impact of fragmentation on your next data warehousing project.

 

Key topics presented:
• 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

Do you have questions about Kent .Net/Sql User group? Contact Kent SQL Server / .Net User Group

When & Where


The Windmill inn
278 Hythe Road
Willesborough<br />
tn24 0qr Ashford
United Kingdom

Monday, 3 October 2011 at 19:00 (BST)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.