Topic: Changing Landscape of Data Security
Date: January 8, 2008 @ 6:00pm
Speaker: David Mertz
David is managing Partner with Compliance Security Partners, LLC, has spent the last six years immersed in compliance and data security issues. Whether the data security requirements are Federal - HIPAA, FACTA, FCRA, FTC, GLBA, State – 40 states have followed California’s lead, or industry based – PCI DSS, BITS, ISO 27000, Mertz has worked with clients in building and implementing efficient and cost effective information security programs. Mertz has been panelist on webinars discussing a wide variety of PCI related issues on behalf of Tripwire. Mertz has written article for a number of trade journals and speaks regularly at national and regional seminars regarding compliance and data security issues.
Location: Johnson County Community College (JCCC) Regnier Center
Sponsor: Power I.T.
Topic: Foundations for SSIS
Date: February 12, 2008 @ 6:00pm
Speaker: Matthew Crouch
Matt specializes in building Business Intelligence systems on Microsoft SQL Server platforms. Matt has over fourteen years of database management experience. Over the last 7 years has been architecting data warehouse and business intelligence solution. He is currently the Business Intelligence Architect at Midland Loan Services. His background includes SQL Server DBA, instructor at DeVry University, VB.Net, ASP, and ASP.Net; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000 and 2005; IBM Websphere Datastage (ETL Tool); MicroStrategy (BI Tool), Oracle Business Intelligence Enterprise Edition OBIEE (BI Tool).
Location: Johnson County Community College (JCCC) Regnier Center
Overview:
Presentation "Establishing a framework in SSIS using templates and configurations" Moving to SQL Server Integration Services (SSIS) can be a daunting task, but setting up a framework before you start helps development. Understanding SSIS Configurations and some best practices on how to use them will assist in faster development. Using templates will also help establish standards and keep consistent audit functionality. Matt will review the different SSIS configurations, templates and standards he has developed on his latest SSIS Project.