Azure DevOps, Scrum, & .NET Software Leadership and Consulting Services

Free course! Predicting the Future, Estimating, and Running Your Projects with Flow Metrics

Beantown.NET Meeting with Adam Machanic on Thursday 6/7/2007

The Beantown.NET User Group (INETA) is meeting on Thursday, 6/7/2007.  This will be our last meeting before Beantown’s summer break (we’ll be resuming in September at a new meeting location).


This month we have Adam Machanic presenting “Modeling and Querying Graphs and Hierarchies in SQL Server”.


As always, our meeting is open to everyone so bring your friends and co-workers.  If you’re planning to come, please send me an RSVP using the contact form ( by 1pm on 6/7 – and let me know if you want free pizza.


BTW, Wrox has been pouring books into my mailbox lately and this month we have LOTS of free books to give away. 


Future meetings:

• September 6 – Richard Hale Shaw on WCF
• October 4 – Chris Bowen




Beantown Meeting Details

When: Thursday, June 7, 2007, 5:30 – 7:30pm


Adesso Systems

One Liberty Square (Kilby St & Water St)

7th Floor

Boston, MA




Modeling and Querying Graphs and Hierarchies in SQL Server



Hierarchies and graphs exist all around us, in both the natural world and manmade constructs. Unfortunately, hierarchies—especially when they are dynamic in nature—tend to be extremely difficult to work with in SQL databases. In this session you will learn several methods of modeling hierarchies in the database and the ins and outs of querying them. Each method has distinct query complexity and performance pros and cons, and you will learn considerations to help you decide on the appropriate techniques to use in your real-world projects.



Adam Machanic is an independent database software consultant, writer, and speaker based in Boston, Massachusetts. He has implemented SQL Server solutions for a variety of high-availability OLTP and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. Machanic has written for SQL Server Professional magazine, serves as SQL Server 2005 Expert for, and is co-author of “Pro SQL Server 2005”. In addition, he regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP). Machanic’s latest book, “Expert SQL Server 2005,” is due out in early 2007.


, ,

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.