THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL 2008 » SSIS   (RSS)
  • SQLSaturday #69 - Philly Love

    Thanks to the Philly SQL Server User Group (PSSUG) and to everyone who attended SQLSaturday #69 in the City of Brotherly Love yesterday. It was a great event with a lot of great people. My presentations are available for download at the links ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on March 6, 2011
  • Try-N-Save SSIS Packages

    The Try-N-Save SSIS Packages from my SSIS Dimensional Data Optimization presentation are available at http://cid-8f7e6c950afc6b3e.office.live.com/self.aspx/.Public/Presentation/TryNSave.zip. I'm still working on getting the sample database uploaded - even compressed a backup is larger than SkyDrive's upload filesize limit. I'll script it out when ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 29, 2010
  • High Performance Dimensional Data Loads With SSIS Presentation

    Just finished giving the SSIS High-Performance Dimensional Data Load presentation at SQLSaturday #59 NYC.  Here are the slides in PDF format.  I'll upload the Try-N-Save code and sample data later for attendees to play with. Thanks to everyone who attended my session and thanks to Melissa D. and NJSQL for putting this ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 20, 2010
  • It's Official - SQLSaturday is Coming to NYC!

    New Jersey SQL Server User Group (NJSQL) is bringing SQLSaturday #39 to NYC on April 24, 2010!  The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices.  The speaker line-up is growing fast—if you'd like to present, visit the event's open call for speakers.  This is a free full-day ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 6, 2010
  • SSIS: Mo' Secure Configurations

    I ran into an issue the other day and I needed a solution for automically configuring my SSIS packages from securely stored DBMS connection strings. Problem is that most DBMSs don’t support Integrated Authentication—they require a username and password. Storing the username/password combo in the connection string in plain text is a security risk, ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 18, 2010
  • "SQL Server MVP Deep Dives" Book Available for Early Access/Pre-Orders

    The MVP authored book, SQL Server MVP Deep Dives is now available for early access and pre-orders at http://manning.com/nielsen/.  The book is divided into 5 sections that cover everything from building a proper relational database to developing BI solutions: 1. Database Design and Architecture 2. Database Development 3. Database ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on September 16, 2009
  • DTS still alive in 2008?

    I was on a call with several other folks the other day discussing ''Katmai''.  The topic of DTS came up. MSFT had indicated that support for DTS would not go beyond SQL Server 2005 in a variety of channels.  I can remember the dozens of Upgrade Advisor messages that always appeared.  I just revisited the ''Advisory'' ...
    Posted to Rick Heiges (Weblog) by RickHeiges on August 22, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement