SQLRelay: The First Leg

SQLBits 9 may be over but the SQL community is still going strong in the UK with the first leg of SQLRelay kicking off this evening. If you haven’t heard of SQLRelay we’re hosting a mammoth 15 SQL user group meetings in three days and a 16th national event in London on the fourth day with none other than Itzik Ben-Gan speaking! All this is completely free to attend, all you need to do is register at http://sqlserverfaq.com/

Tonight the first four events will be held, I’ve copied the agenda for all of them below:

Birmingham

The Birmingham group is organised by Alex Whittles (Twitter)

You can follow the Midlands SQL Server User Group at www.SQLMidlands.com and on Twitter at twitter.com/SQLMidlands
6.00pm – 6:30pm Meet, Greet & Beer

6:30pm – 7:30pm Tony Rogerson – High Availability in SQL Server, I will also cover background HA topics so it will be relevant to other editions too, but all demos will be in SQL Denali and concentrating on the new features.

7:30pm – 8:00pm Break, Food & Beer

8:00pm – 9:00pm Andrew Fryer – Discovering Denali. There is a lot of new business intelligence in the next version of SQL Server, but there’s loads of other interesting stuff for developers and DBAs as well. So I want to spend an hour going over the whole thing and then dig into some of the cool stuff that will be of interest, such as: 

  • Data Quality Services 
  • Filetable – the new WinFS 
  • As well as the self service BI you might have been hearing about 
  • Project Juneau – better visual studio integration 
  • SQL Server and virtualisation

The event is being held in the Old Joint Stock pub in the centre of Birmingham, you can register here.

Farnham, Surrey

The fourth evening Surrey SQL Server community event, hosted in Farnham Surrey, and supported by Coeo.
This event will cover contemporary technology topics for those using SQL Server in 2011, as well as providing a chance to make and meet with SQL Server community friends.
The event will have three sessions, and a SQL Server news session at the beginning of the evening:

Deep Dive into AlwaysOn Availability Groups
Christian Bolton MCA/MCM/MVP, Technical Director – Coeo

In this session you’ll learn about the new High Availability feature coming in SQL Server Denali known as AlwaysOn Availability Groups and will see in-depth details and demos on the following topics:
-          Availability Groups
-          Multiple replicas
-          Readable replicas
-          Offloading backups to replicas

A deep dive into PowerShell (7.15-8.00pm)
Pete Rossi – Head of Automation, Attenda

CSI:SQL – Performing SQL Server audits – A newcomer’s first session (6.20-6.50pm)
Richard Doering – Senior DBA for Clinisys


  

There will be the usual short break mid-evening with a buffet provided.
Please send any questions or queries to myself, gavin@coeo.com

You can still register for this event here.

Kent SQL Server and .NET User Group

Dave Ballantyne is organising another Kent SQL Server and .NET User Group as part of the SQLRelay event.

SignUp here http://kentnetsql20110911.eventbrite.com/

Neil Hambly with “Replication: Troubleshooting and Performance”

 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 {Emphasis on these items in Bold}

v Components Overview – Describe the various components and how they interact

v Performance Replication Agents & Jobs

v Troubleshooting {Techniques & Tools}

  • Examine tools available to perform monitoring and troubleshooting
  • Techniques to overcome common problem scenarios
  • 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

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

Location:

The Windmill
Hythe Road
Willesborough
Ashford
Kent
TN24 0QR

Manchester

Back by popular demand, a whole evening with the fantastic Mr Allan Mitchell who will be doing two new sessions at this user group event for SQLRelay.
Allan is the joint owner of Copper Blue Consulting Ltd.  Copper Blue Consulting focus on getting the right data to the right people at the right time and in the right format.  We are passionate about data integrity and suitability.  We have worked all over the world in a variety of industries.and on projects both large and small.  We specialise in ETL, CEP, MDS, Data Visualisation as well as Operational and Predictive Analytics. We offer training as well as consultancy.

www.CopperBlueConsulting.com

Remember to tell your friends and the people you work with; make sure you register as soon as you can as this will be a popular user group.

5.30 – 6:00 pm 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 Data Quality Services (DQS) in SQL Server Denali with Allan Mitchell

Complimenting SSIS in SQL Server Denali we now have DQS which is a knowledge based reusable data cleansing solution to perform computer-assisted data quality analyses, and also manage your data quality interactively.  You can use different sources including cloud to enhance your data quality.

Come to this session to understand how to use this technology outside of and inside of SSIS and understand how Microsoft are starting to fill out their Data Quality Portfolio.

7.30 – 7.50pm BREAK: Light refreshments
More time to network and ask questions…

7:50 – 8.50pm Master Data Services in SQL Server Denali with Allan Mitchell

Everybody has data distributed across their environments.  The same entity is often stored in multiple systems by multiple business units i.e. Finance has the concept of a customer and so does Sales.  The problem is even though they may be the same customer rarely are they comparable across the same attributes.  This is only getting worse with acquisitions whereby different business processes cause different levels of data to be stored. 

It all gets very messy very quickly and businesses are starting to realise the need to have a co-ordinated view of their business

Master Data Services is Microsoft’s tool to help you start implementing a Master Data Management solution within your business.

This session will focus on the technology MDS and we will mention the wider scope of MDM.  MDM is a mix of technology and business and is potentially a large but very beneficial undertaking.

You can register for this event here