August 2008 - Posts

• Thursday September 11th 2008 6:30PM to 8:00PM

  August's Presentation: An Introduction to Analysis Services 2005 Registration -  Please register! This Months Sponsor-Fahrenheit Technology Abstract: Microsoft’s Analysis Services 2005 is best known for its ability to build and manage OLAP data cubes.  In addition to that core functionality, SSAS enables users to define key performance indicators (KPIs), profile data, mine data and predict future activities using the results of that mining.  Perhaps best of all, SSAS is included as part of SQL Server 2005 Standard and Enterprise Editions.  This session introduces the audience to the capabilities of SSAS, businesses uses for those tools and ways to integrate SSAS with Integration Services and Reporting Services.  About Mark: Mark Hudson has more than 10 years experience in business intelligence and data analysis.  He has developed data warehouses and data presentation layers using numerous tools including both SQL Server 2000 and SQL Server 2005.  He currently serves as an architect and developer with CapTech Ventures, Inc. (mhudson@captechventures.com, www.captechventures.com).  Posted Aug 19 2008, 09:18 AM by fibrock with no comments Filed under: Meeting Info, Analysis Services 2005

• Thursday August 14th 2008 6:30PM to 8:00PM

  August's Presentation: SSIS FrameWorks! Registration -  Please register! This Months Sponsor-McClain Group II Abstract: SSIS Frameworks focuses on Object Oriented programming techniques applied to SSIS Development.  We will explore the concepts of encapsulation and modularity from an Object Oriented Programming perspective and how this can be applied to developing SSIS packages.   SSIS Frameworks will look into building both a metadata structure and the SSIS package design, to support breaking units of work into small reusable SSIS packages and how to structure those packages for re-use.  Real world examples from a Data Warehouse to Master Data Management Systems will be referenced to show how this type of SSIS development can cut development time and allow for coding work to be spread across a team.  We will also get into the nitty gritty of some SSIS configurations/event handlers/variable passing. About Steve: Steve Fibich currently works in Richmond VA at PFGC as the Systems Architect on a Master Data Management project utilizing SQL Server 2005 and SSIS 2005 pulling data from iSeries, Unix, VAX,  and SAP for a massive system integration effort.  He has been working with SQL Server since 6.5 building Data Warehouses,  building integration systems for third party product integration, creating Master Data Management systems , and doing general DBA work for the past 10 years. Posted Aug 05 2008, 04:59 AM by fibrock with no comments Filed under: Meeting Info, SSIS