Considerations of Using Excel Data Sources in SSIS 2005 & Designing a Secure SQL Server 2008 Solution
Date: August 19, 2008
Time: 4:30 PM - 7:30 PM
Visit www.mnssug.org to register
Topic One: Considerations of Using Excel Data Sources in SSIS 2005
Speaker: Mark Vaillancourt, Digineer
When connecting to Excel, SSIS uses the Jet provider, which expects an Access database by default. Since Excel is not a database, nor does it tend to act like one, particularly with respect to data type consistency within a column, it is often necessary to give Jet a little help. This presentation will cover some tips for helping Jet connect to your Excel files properly. We will also discuss some tips for dealing with Excel filles using SSIS outside of just connecting to them.
Mark Vaillancourt is an Information Management Consultant with Digineer, Inc, a Microsoft certified Gold and Managed Partner, based in Plymouth, MN. Mark has been working with databases for 9 years, with most of that experience working with the ticketing and fundraising system at the Guthrie Theater in Minneapolis. In March of 2007, Mark joined Digineer and started working with Microsoft SQL Server. He has spent the past several months elbow deep in SQL Server Integration Services (and loving it).
Topic Two: Designing a Secure SQL Server 2008 Solution
Speaker: David Baldauff, Digineer
This presentation will delve into SQL Server 2008 security concerns and ways to design a secure SQL Server 2008 solution. We will describe Kerberos at a high level, and then go into detail on how to setup Delegation and Kerberos authentication using SQL Server. The presentation will include a review of the tools necessary to setup delegation and Kerberos and the debugging techniques used to resolve Kerberos authentication problems. If you are looking for a way to improve your security, eliminate the need for SQL authentication and understand the tools needed to do this, then this presentation is for you. If you know what a double-hop is and could never quite find a way around the problem before, then this presentation is for you.
David Baldauff is a consultant for Digineer, a Microsoft certified Gold and Managed Partner, in Plymouth, MN. David has been working in software and database development for over 15 years and specializes in data architecture and data-centric application design. David recently completed a courseware book for AppDev.com on SSIS 2005, and has also recently contributed to a Microsoft whitepaper on SQL Server 2005 Enterprise Edition features.