June 2008 - Posts

• Thursday July 17th 2008 6:30PM to 8:00PM

  June's Presentation: Colonial Williamsburg’s Foundation Data Warehouse overview with Rick Todd! Registration - Coming Soon! This Months Sponsor   Abstract: Colonial Williamsburg’s Foundation Data Warehouse, where the 18th century meets the 21st century.  Rick Todd from the Colonial Williamsburg Foundation IT Department will be sharing some of their insights into handling the ever-tricky Customer Dimension while building their Data Warehouse.  Colonial Williamsburg is a perfect fit for a Data Warehouse, having lines of business as diverse as Ticketing, Hotel, Food and Beverage, Retail (online, on location, and catalog), Spa, and Golf.  Rick will be discussing some of the successes and failures his team (of 2) has had will attempting to import, conform, merge, household, and report on customers across all these systems (which currently include SQL 2000, SQL 2005, and AS400).  The first 3/4ths of the presentation will be a fairly fast moving, high level discussion covering modeling the Customer dimension, an ETL framework for conformed dimensions, merging, purging, and householding Customers through fuzzy logic, and handling the conformed dimension in Analysis Services.  The last 1/4th of the meeting time will be left for a more in-depth discussion of any areas that people find interesting.  Please come to help Rick further Colonial Williamsburg’s mission: That the Future May Learn From the Past.  In this case, their Rick’s teams’ past mistakes and successes, as opposed to the founding of our country. About Rick: Rick Todd has been a database developer for 9 years.  Initially as a private consultant in Chicago for the health care industry, the Federal Reserve Bank, and various smaller customers.  From there he went on to be a Database Architect for Resort Technology Partners, LLC of Vail then Avon Colorado.  At RTP Rick was responsible for design and development of various OLTP systems for the #1 ski resort software developer in North America.  After 7 years at RTP, Rick visited the Colonial Williamsburg Foundation after they purchased RTP’s software and flew him out for training on the database.  Rick moved to Williamsburg and started the Data Warehouse project for the Colonial Williamsburg Foundation last year in May. Register: Click here to register! Posted Jun 25 2008, 01:23 PM by fibrock with no comments Filed under: Meeting Info

• Thursday June 12th 2008 6:30PM to 8:00PM

  June's Presentation: RSSUG Round table! Registration - Coming Soon! This Months Sponsor Abstract This is going to be round table discussion facilitated by Andy Leonard, Ron Deskins, and Mark Hudson.  The topic is SQL Server, but other than that it is wide open.  Please post your comments to the board so we can get a lively discussion going at the meeting!   About Everyone:   Andy Leonard is a Solid Quality Mentor, SQL Server database and Integration Services developer, SQL Server MVP, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services , Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers ,  MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005 , and the upcoming e-book Mastering Visual Studio Team System Database Edition . Andy founded and manages VSTeamSystemCentral.com and maintains two blogs there: Applied Team System and Applied Business Intelligence . He also blogs for  SQLBlog.com. Andy's background includes web application architecture and development, VB.Net, ASP, and ASP.Net; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000 and 2005; and test-driven database development.   Mark Hudson has more than 10 years experience in business intelligence and data analysis.  He has developed data warehouses and report presentation layers using both SQL Server 2000 and SQL Server 2005.  He currently serves the Richmond area as a data architect and developer with CapTech Ventures. Ron Deskins - Richmond SQL Server User Group President. (No picture on file)   Posted Jun 03 2008, 09:46 AM by fibrock with no comments Filed under: Meeting Info