OC SQL Data Platform

Welcome

Orange County Data Platform Community

We have found a NEW HOME!  Again!
Special thanks goes to Michellea David for hosting us at her new building at 220 Commerce in Irvine, CA.

  • 6:30 > Networking and pizza
  • 7:00 > Presentations
  • 8:30 > Drinks at a nearby watering hole for additional networking and shop talk

Mechanics Bank
220 Commerce
Irvine, CA 92602

Do you have any events to share? If you do, send them to Ted Stathakis.

 


 



Next Meeting

Thursday,

April

14

BIG PASS Community Monthly Meeting - Rob Hatton

  • In-Person @ 6256 Greenwich Dr. San Diego, California, United States (map)
  • 18:30 - 20:30 Pacific Daylight Time
  • Language: English

We are really looking forward to our next meeting. I hope you are too. If you can make it, please RSVP here.

Agenda

6:30 PM - Networking. Feel free to bring your dinner and join us for some great conversation. 

7:00 PM - Announcements

7:15 PM - Rob Hatton (In Person)

8:30 PM - Raffle and wrap up

8:45 PM - Networking at Los Cabos Cantina

You do not need to bring a paper ticket to the event. The registration is to obtain a head count for the size of the room and for how much food needs to be purchased. Please un-register by Wednesday if you know that you won't be able to make it. Thank you.

Abstracts below
 
Please contact Mickey Stuewe if you have any questions.

Featured Presentation:

Managing Hierarchical Data

Robert Hatton, Business Intelligence Developer Holland & Knight

Managing hierarchical data (such as Budgets, Bills of Material, or Organization Charts) can be a real challenge in a relational database. This presentation will feature a design pattern that makes it seem almost simple. We'll see a database schema that is flexible and efficient. We'll also take some time to discuss common design mistakes. Finally we’ll review a recursive CTE that will allow you to traverse large hierarchies with surprising speed!

About Robert:
Rob Hatton is the author of the Business Intelligence Team Handbook. Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.

We are always looking for speakers to present at our monthly meetings.  We are sure you have done some really cool stuff in your role and would like to hear from friends in the trenches.  It's not hard and there are many of us happy to coach you.

 

PASSChapterLogo.jpg


Sponsors



 

sql_micro_sm.gif

 

 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids