Organiser

Chris Testa-O'Neill SQL Server MVP

my blog | training

SQLBlogCasts

Public Content

Microsoft 2005 KB's

Microsoft 2008 KB's

Evening Meeting on Thu Oct 28, 2010 in Manchester

SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008

Register for Event
LiveMeeting Attendee URL This event is not available via LiveMeeting
Time Starts (UK time) at 17:30 , Finishes 21:00
Cost Free
Organiser UK SQL Server User Group
Address Westminster House, Reception, Minshull Street, Manchester, M1 3HU
Directions to Event
Tags
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.30pm – 6:00 Registration and networking + Tea/Coffee with biscuits.
Meet and greet.
6:00pm – 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.30pm – 7:30 Replication - Neil Hambly
This presentation on Replication will start with an overview of the various SQL Server replication models:
Snapshot, Transactional, Merge with Peer-Peer added in SQL 2008 release
Following the overview, I will then present in further detail (along with some demos) on the following key topics
  • Components
    • Describe the various components and how they interact
  • Administration
    • Best practices.
  • Performance
    • Replication Agents & Jobs
  • Troubleshooting {Techniques & Tools}
    • Tools available to use for monitoring and troubleshooting
    • Techniques to overcome common problem scenarios

Neil Hambly an experienced Architect/DBA/Developer who has been using the SQL Server Product family since version 6.5 during the last 12 years. A regular attendee and sometime presenter @ UK SQL Server user groups & events as well as an avid Twitter & Powershell fan, when not outside can be found coding and Performance tuning and generally "try to learning" even more SQL knowledge.

7:30pm – 8:00 BREAK: Light refreshments
More time to network and ask questions...
8:00pm – 9.00pm Ch-ch-ch-ch-changes (let SQL take the strain!) - Martin Bell

 

Apologies to David Bowie! SQL 2008 introduced Change Tracking, Change Data Capture, ChSQL Server Audit in this talk I will look at each option, how to use them, the when and why..

 

Martin Bell is a dashing and attractive redhead and you would never guess that he has been a freelance computer consultant in the UK for over 23 years. He’s worked on many relational database systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003 proving he is not just a pretty face! As an insight into his masochistic tendancies he currently organises the Scottish Area and Leeds Area SQL Server User Group meetings. He is also a founding organiser of the highly successful SQLBits Community Conferences showing he is slightly mad and very funny!!

Martin Bell's blog http://sqlblogcasts.com/blogs/martinbell/

Furture SQL Related Events RSS

{All}
Cardiff
Edinburgh
Leeds
Maidstone
Manchester
Telford
York
{All}
Sep
Oct
Dec
Jan
Wed, 15 Sep in 5 days
LEEDS
Evening Meeting (17 registered)
******Win an MSDN Subscription worth $1,000's *********** Using XML data in SQL Server with Anthony Brown, and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown.
Thu, 16 Sep in 6 days
MANCHESTER
Evening Meeting (15 registered)
******Win an MSDN Subscription worth $1,000's *********** User group evening with Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown
Mon, 20 Sep in 10 days
TELFORD
Evening Meeting
BCS: Introduction to Business Intelligence event: Data Warehousing, Cubes, Reporting Systems
Wed, 22 Sep in 12 days
MAIDSTONE
Evening Meeting
Kent User Group - Analysis Services (Andrew Calvett), TSQL Techniques (Dave Ballantyne)
Thu, 23 Sep in 13 days
CARDIFF
Evening Meeting (14 registered)
Chris Testa O'Neill will be creating a cube with SSAS, Ian Archibald from Attunity demonstrating their CDC products **Keep Checking back for further updates**
Thu, 30 Sep in 20 days
YORK
Multi Day Seminar
SQLBits 7: The Seven Wonders of SQL - September 30th to October 2nd
Thu, 7 Oct in 27 days
EDINBURGH
Evening Meeting (5 registered)
Implementing Hierarchies using TSQL and the HierarchyId type and understanding aggregation problems (Tony Rogerson); TBD (Allan Mitchell)
Wed, 27 Oct in 47 days
LEEDS
Evening Meeting (5 registered)
User group evening with Martin Bell and SQL Server and Virtualisation with Mike Kiersey
Thu, 28 Oct in 48 days
MANCHESTER
Evening Meeting (12 registered)
SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008
Wed, 8 Dec in 89 days
LEEDS
Evening Meeting (4 registered)
User group evening with Tony Rogerson and Neil Hambly explores indexed views and computed columns
Thu, 9 Dec in 90 days
MANCHESTER
Evening Meeting (6 registered)
User group evening - Agenda to be confirmed
Wed, 19 Jan in 131 days
LEEDS
Evening Meeting (4 registered)
User group evening with Chris Burns and the Resource Govenor and Policy Based Management with Chris Testa-O'Neill

Past SQL Related Events RSS

2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
7 Sep 2010
BRACKNELL
Evening Meeting
SQL Server CLR and T-SQL Functions - Colin Leversuch-Roberts aka GrumpyDBA, Data Tier Applications (DCA) - Neil Hambly
19 Aug 2010
EDINBURGH
Evening Meeting (11 registered)
Execution plans and Performance Tuning (Rob Carrol); Extended Events (Martin Bell)
18 Aug 2010
MAIDSTONE
Evening Meeting
Kent User Group - Complex Event Processing (Allan Mitchell), Replication (Neil Hambly)
5 Aug 2010
MANCHESTER
Evening Meeting (21 registered)
Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008 Reporting Services R2 with Chris Testa-O'Neill
20 Jul 2010
LEEDS
Evening Meeting
AGI Northern Group meeting: Using geospatial data in the Microsoft world.
14 Jul 2010
LONDON
Evening Meeting (92 registered)
SQL Server and Disk IO (File Groups/Files, SSD's, Fusion-IO, In-RAM DB's, Fragmentation) - Tony Rogerson; Physical Join Operators in SQL Server - Ami Levin; Complex Event Processing - Allan Mitchell
28 Jun 2010
EDINBURGH
Evening Meeting (14 registered)
Replication (Components, Adminstration, Performance and Troubleshooting) - Neil Hambly and SQL Server Upgrades (Notes and Best practice from the field) - Satya Jayanty
24 Jun 2010
CARDIFF
Evening Meeting (16 registered)
Alex Whittles on data warehouse design case studies and an introduction to PowerPivot with Adam Morton
23 Jun 2010
READING
Evening Meeting (31 registered)
Introduction to NoSQL (Not Only SQL) - Gavin Payne; T-SQL Gotcha's and how to avoid them - Ashwani Roy; Introduction to Recency Frequency - Tony Rogerson; Reporting Services - Tim Leung
17 Jun 2010
LONDON
Full Day Seminar
SQL Server Master Class with Kimberly Tripp and Paul Randal
27 May 2010
ONLINE
Online
Q & A Session with the UK SQL Server Product Team
20 May 2010
LONDON
Evening Meeting (30 registered)
Business Intelligence: Implementing common business calcs using DAX in PowerPivot (Chris Webb); Case Study on how to deal with Metrics on high data volumes
19 May 2010
LONDON
Evening Meeting (38 registered)
Service Broker (Intro, Terminology, Design Considerations); Monitoring and Controlling Resources in SQL Server (Resource Governor, Data Collector); BakBone NetVault: FASTRecover provides byte-level continuous data protection
7 May 2010
ONLINE
Webcast (14 registered)
"Cuppa" Corner: Database Design What is and Why is Normalisation important? Domains, Functional Dependencies, Repeating Groups, First Normal Form.
21 Apr 2010
READING
Evening Meeting (40 registered)
Service Broker (Intro + Guidance), Indexing (Selection, Usage, Fragmentation etc...), Normalisation, Surrogate Keys - Locking considerations

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
christianbolton Fri 12:15AM
@GavinPayneUK: Sure, I can do that. We have a couple of customers using it actually. email me if you like. #sqlfaq #sqlserver
gavinpayneuk Thu 8:51AM
Is anyone kind enough to technically validate my 3-slide and 2 script transparent-data-encryption presentation? #sqlfaq #sqlserver
adathedev Wed 12:47PM
RT @tonyrogerson: http://bit.ly/9HTJvJ UK SQL UG: prize draws for SQLBits training day+Fri, MSDN Ultimate subscriptions + regional events #sqlfaq
tonyrogerson Wed 12:23PM
http://bit.ly/9HTJvJ UK SQL UG: prize draws for SQLBits training day+Fri, MSDN Ultimate subscriptions + regional events #sqlfaq
gavinpayneuk Wed 7:59AM
Where to keep the keys - SQL Server Transparent Data Encryption - first thoughts - feedback welcome! http://bit.ly/bD5esz #sqlserver #sqlfaq
sqlsoldier Tue 9:13PM
@GavinPayneUK It's in the encrypted database. #sqlserver #sqlhelp #sqlfaq
kbriankelley Tue 9:07PM
@GavinPayneUK Both http://tinyurl.com/2agyyvh #sqlserver #sqlhelp #sqlfaq
gavinpayneuk Tue 9:05PM
Do my database master keys live inside master or my encrypted user db? #sqlserver #sqlhelp #sqlfaq
allansqlis Mon 7:35PM
RT @tonyrogerson: Introduction to BI event in Telford on 20th Sept run by the BCS (Shropshire) - all welcome and free http://bit.ly/b4gaN8 #sqlfaq
tonyrogerson Mon 12:37PM
Introduction to BI event in Telford on 20th Sept run by the BCS (Shropshire) - all welcome and free http://bit.ly/b4gaN8 #sqlfaq
purplefrogit Mon 9:53AM
RT @PurpleFrogSys: I'm looking to set up a SQL Server user group in the Midlands, let me or @tonyrogerson know if ur interested #sqlfaq http://bit.ly/avTVx4
purplefrogsys Mon 9:47AM
I'm looking to set up a SQL Server user group in the Midlands, let me or @tonyrogerson know if ur interested #sqlfaq http://bit.ly/avTVx4
tonyrogerson Mon 7:49AM
I'm working with Alex Whittles on getting a regional SQL group going in the midlands, ping me if you have a venue or are interested #sqlfaq
allansqlis Mon 6:57AM
The difference between a message and an event can be very blurred making a choice between CEP and MOM difficult #StreamInsight #CEP #sqlfaq
tonyrogerson Sun 6:17AM
Joe Celko writing on best practice on database design yet doesn't name columns on his INSERT http://bit.ly/bwYQbF - #sqlfaq #shocking
adathedev Fri 3:11PM
RT @tonyrogerson: In UK and using SQL Server? Join us on LinkedIn http://linkd.in/cKD35Z and network with other UK based SQL folk #sqlfaq #sqlbits
tonyrogerson Fri 3:09PM
In UK and using SQL Server? Join us on LinkedIn http://linkd.in/cKD35Z and network with other UK based SQL folk #sqlfaq #sqlbits
rachelhawley Fri 9:29AM
Simple & sensible suggestions. RT @GavinPayneUK: My advice on moving from being a DBA to client facing roles http://bit.ly/aGd5fy #sqlfaq
gavinpayneuk Fri 9:13AM
My advice on moving from being a DBA to client facing roles http://bit.ly/aGd5fy #sqlfaq