Organiser

Allan Mitchell, SQL Server MVP

sqldts.com | sqlis.com |  hire me

SQLBlogCasts

Public Content

Microsoft 2005 KB's

Microsoft 2008 KB's

Evening Meeting on Wed May 27, 2009 in Edinburgh

Patterns and Practices with SQL Server and How to Model Hierarchies.

LiveMeeting Attendee URL This event is not available via LiveMeeting
Cost Free
Organiser UK SQL Server User Group
Address Microsoft Office at Waverley Gate, Edinburgh
Directions to Event
Tags

Scottish Area SQL Server User Group Meeting, Edinburgh - Wednesday 27th May

Data, is it too much? Patterns and Practices with SQL Server – Satya Shyam K Jayanty

 

If You Have Too Much Data, Then Good Enough Is Good Enough In this session we cover the topics include, among others, where things are breaking when you have too much data, maintaining data integrity, and analyzing patterns.

 

 

Satya Shyam K Jayanty
Satya is an Independent Database expert, with over 16 years of experience in application designing, developing and managing database technologies using industry famous technologies & software. He has been working with SQL Server since version 4.2 (1996) and an active member & moderator in Technet, MSDN, SQL-Server-Performance.com forums/websites and also writes for http://www.sql-server-performance.com website. A regular speaker and volunteer (Ask The Experts) at SQL Server events such as SQLPASS, Tech-ed etc. he was first made a SQL Server MVP in 2006. He manages the website http://www.sqlserver-qa.net.
 

How do you do - Hierarchies?

The most common way to model hierarchies in a relational database is to use the Adjacency List model, with the new hierarchyid in SQL Server 2008 should we all be using the Materialised Path model or now? In this presentation Martin will look the methods used for each method and the advantages and disadvantages of using each methods, so that you may decide which is the best for you!

 

Martin Bell
Martin Bell has been a freelance computer consultant in the UK for over 23 years. He has 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.  Martin organises the Leeds and Scottish Area SQL Server User Group meetings and is one of the founding members of the SQLBits organising committee.


Agenda

18:30 - 19:00 - Introduction, Networking and Food

19:00 - 19:50 - SQL Server Patterns and Practices – Satya Shyam K Jayanty

19:50 - 20:00 – Break

  

20:00 – 20:50 – How do you do - Hierarchies? - Martin Bell

 

20:50 – 21:00 - Close

 

Location:
Microsoft Office at Waverley Gate
http://www.microsoft.com/uk/about/map-edinburgh.mspx


Registration will be necessary as I have to submit registrations to Microsoft on Wednesday morning.

Coming Events RSS

Tue, 7 Sep in 4 days
BRACKNELL
Evening Meeting
SQL Server CLR and T-SQL Functions - Colin Leversuch-Roberts aka GrumpyDBA, Data Tier Applications (DCA) - Neil Hambly
Wed, 15 Sep in 12 days
LEEDS
Evening Meeting (15 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 13 days
MANCHESTER
Evening Meeting (14 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
Wed, 22 Sep in 19 days
MAIDSTONE
Evening Meeting
Kent User Group - Analysis Services (Andrew Calvett), TSQL Techniques (Dave Ballantyne)
Thu, 23 Sep in 20 days
CARDIFF
Evening Meeting (13 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 27 days
YORK
Multi Day Seminar
SQLBits 7: The Seven Wonders of SQL - September 30th to October 2nd
Thu, 7 Oct in 34 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 54 days
LEEDS
Evening Meeting (5 registered)
User group evening with Martin Bell and SQL Server and Virtualisation with Mike Kiersey
Thu, 28 Oct in 55 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 96 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 97 days
MANCHESTER
Evening Meeting (6 registered)
User group evening - Agenda to be confirmed
Wed, 19 Jan in 138 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 Events RSS

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
15 Apr 2010
LONDON
Evening Meeting (11 registered)
Social for SQL and SQL Server professionals - SQL quiz, meet your peers, ask the group Q & A

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
Stephanie Sullivan Wed 3:34PM
Looking for a lift to sql bits from south wales. Anybody driving up who welcome a reduction in petrol money?
neil_hambly Tue 2:11PM
My next presentation (DAC-PAC) is @ the VBUG Bracknell (7th Sept) http://bit.ly/9ZgObb along with GrumpyDBA (CLR vs TSQL functions) #sqlfaq
allansqlis Sun 9:08PM
Solution to a practical problem when issuing Current Time Increments in StreamInsight http://goo.gl/UhQn #StreamInsight #CEP #sqlfaq
gavinpayneuk Sat 10:02PM
@SQLRich #sqlserver #sqlfaq Using the internal SQL Server encryption tools
sqlrich Sat 9:58PM
@GavinPayneUK Do you mean SQL's internal code or DBA's implementing encryption? #sqlserver #sqlfaq
gavinpayneuk Sat 9:14PM
@mouldie Have they started using SQL's internal encrypt tools or is it still done at the app, o/s or storage level? #sqlserver #sqlfaq
gavinpayneuk Sat 8:40PM
Does anyone bother with encryption actually within SQL Server? #sqlserver #sqlfaq
neil_hambly Sat 9:44AM
Can't stop laughing RT @tonyrogerson: RT @fasel: Mongo DB is web scale :D http://bit.ly/cWY3el #nosql very funny video and so true #sqlfaq
tonyrogerson Sat 9:26AM
RT @fasel: Mongo DB is web scale :D http://bit.ly/cWY3el #nosql very funny video and so true #sqlfaq
bletchleypark Fri 12:00PM
RT @tonyrogerson: I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, done via paypal #sqlfaq - very worthy cause!
neil_hambly Fri 10:28AM
I have also pledged 1 day RT @tonyrogerson: I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, #sqlfaq
tonyrogerson Fri 10:10AM
I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, done via paypal #sqlfaq - very worthy cause!