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.