Geeks With Blogs

News Brandy Favilla is currently the Community Engagement Manager at New Horizons of Minnesota (www.nhmn.com). In this position, she helps people define and build their careers through educational events. Brandy focuses on networking with members of the Information Technology community to form partnerships in education. She strives to maintain New Horizons’ reputation as a high-quality learning center throughout the Twin Cities and beyond. Some of her accomplishments include chairing the committee for both the TechFuse and MindSurf Conferences hosted by New Horizons, co-chairing Twin Cities Code Camp and Twin Cities SharePoint Camp, Co-host of the Twin Cities Developers Guild, VP of PR for TechMasters (www.techmasters-tc.com), Communications Chair of PACT (www.pactweb.org), Programs chair for IAMCP, President of the Business Intelligence User Group (www.ncbisig.org) and actively participating in the SharePoint User Group (www.sharepointmn.com). *the thoughts and opinions in this blog are my own and do not reflect the opinions of New Horizons of Minnesota
Twin Cities IT and Developer Events Postings by Brandy Favilla

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.

Posted on Monday, July 21, 2008 9:55 AM | Back to top


Comments on this post: SQL User Group Meeting - August 19, 2008

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © TwinCitiesITandDevEvents | Powered by: GeeksWithBlogs.net