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 Click here to join Meeting
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

Wed, 17 Mar in 3 days
LONDON
Evening Meeting (125 registered)
SQL 2008 Data Warehousing Features (Vincent Rainardi); Index Views and Computed Columns (Neil Hambly); Business Intelligence in Office 2010 - Excel,PowerPivot,SharePoint (Duncan Sutcliffe); finishing with a Q & A on BI with the panel
Sat, 27 Mar in 13 days
MANCHESTER
Evening Meeting (3 registered)
Introduction to Business Intellence in the SQL Server Stack - ***Date to be confirmed*** - register your interest
Sat, 27 Mar in 13 days
MANCHESTER
Evening Meeting (5 registered)
Introduction to Database Maintenance and Development 101 - ***Date to be confirmed*** - register your interest
Wed, 21 Apr in 38 days
READING
Evening Meeting (18 registered)
Developer and DBA Focus
Fri, 7 May in 54 days
ONLINE
Webcast (2 registered)
Database Design Part 1 - Why is Normalisation important? What is Normalisation, a look at First Normal Form (1NF) and Boyce Codd (BCNF) Normal Form
Wed, 19 May in 66 days
LONDON
Evening Meeting (17 registered)
Developer and DBA focus
Wed, 23 Jun in 101 days
READING
Evening Meeting (4 registered)
Business Intelligence focus
Wed, 14 Jul in 122 days
LONDON
Evening Meeting (7 registered)
Generic session on SQL Server

Past Events RSS

25 Feb 2010
EDINBURGH
Evening Meeting (19 registered)
** Prize Draw **, An evening of performance troubleshooting with Iain Kick , Learning SQL Server with Alistair Board
25 Feb 2010
CARDIFF
Evening Meeting (16 registered)
**Change to Agenda** BI Fundamentals: Building an Enterprise ETL Framework in SSIS, Data Warehouse Design
20 Jan 2010
DUNDEE
Evening Meeting (7 registered)
Allan Mitchell - Intro to SQL Server Integration Services 2008; Tony Rogerson - Intro to SQL Server tools both flavours - DBA and Developer. Usual Nuggets, Usual SQL LiveLock; Q & A; Advice etc..
17 Dec 2009
MANCHESTER
Evening Meeting (9 registered)
Manchester SQL Server User group - Round the table talks, SQL Nuggets, Informal talk and out for a drink and a chance to win a Copy of Windows 7 and SQL Server 2008
10 Dec 2009
LEEDS
Evening Meeting (9 registered)
An evening of Service Broker and Powershell
26 Nov 2009
EDINBURGH
Evening Meeting (8 registered)
** Cancelled ** SQL Server Nuggets and a look into the Newsgroups
26 Nov 2009
LONDON
Evening Meeting (57 registered)
SQL Server internals and best practice for Absolute Beginners (Tony Rogerson); Nuggest from Dave Ballantyne on Ranking, UDF's; MS Business Intelligence Project Boosters (Siddharth Mehta) - an Introduction to the Power of Policies (Martin Cairney), BakBone product demonstration and the first LiveLock Discussion
18 Nov 2009
LONDON
Evening Meeting
SQL Azure and what is new in SQL Server 2008 R2
11 Nov 2009
READING
Evening Meeting (36 registered)
High Availability (Partitioning, File Groups (use of, backup/restore)) and an Introduction to SQL Server architecture - Tony Rogerson; Virtualising SQL Server (why, design, how, issues, solutions, troubleshooting) - Justin Langford
29 Oct 2009
LONDON
Evening Meeting (42 registered)
Deploying SSRS reports using msbuild (Jamie Thomson); BI 2.0 (Andrew Sadler); Data Warehouse Development Workbench for SQL Server (Steve Hitchman)
28 Oct 2009
DUNDEE
Evening Meeting
SQL Injection Attacks and Tips on How to Prevent Them
15 Oct 2009
MANCHESTER
Evening Meeting (17 registered)
Reporting Services evening. Hosted by Chris Testa-O'Neill
14 Oct 2009
READING
Evening Meeting (33 registered)
Focus: Developer/DBA; Tony Rogerson on TSQL Hints and Tips (CTE Recursion,Case,Partitioning,Sub-Queries,Normalisation/DeNormalisation) and Colin Leversuch-Roberts "How are my servers Today?" - real time monitoring dashboards
8 Oct 2009
CARDIFF
Evening Meeting (18 registered)
South Wales User Group first meeting - Ensuring Business Continuity (Backups, Mirroring and Monitoring) - Tony Rogerson; SQL 2008 Integration Services - some of the things that make it better - Allan Mitchell.
8 Oct 2009
EDINBURGH
Evening Meeting (11 registered)
SQL Server Performance Analysis Tools and Powershell

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
aaronbertrand Sun 2:45PM
@tonyrogerson some people use (SMALL)DATETIME as a key, e.g. for reporting, so GETDATE()/SYSUTCDATE() etc. #sqlfaq #sqlhelp
tonyrogerson Sun 9:44AM
Looking at methods to generate a surrogate key value - IDENTITY, NEWID, NEWSEQUENTIALID, diy, hashing (SHA1 ??) - any more?#sqlfaq #sqlhelp
tonyrogerson Sat 2:18PM
Feels like I'm writing a book on surrogate keys, Part 1 blogged http://bit.ly/bRbFjX (Rules for surrogate keys, problems they solve) #sqlfaq
Jennifer Stirrup Wed 6:49PM
Is anyone hiring at the moment? Looking for a London-based BI focused role
tonyrogerson Wed 12:46PM
@philcr I'd really like to see Surface with a 2008 R2 demo on it taking full advantage of the kit - that would be cool! #sqlfaq