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 » SSIS » SQL   (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
  • "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
  • SSIS: living in a parallel world? Not yet...

    Today I come into a nice bug (misfeature?) of SSIS 2008 and I'd like to share it with you. Let's start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce several outputs for new, deleted, updated rows and so on. It is the classical ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on September 14, 2008
  • Mantaining order in SSIS flow, problems with Merge

    In a previous post I spoke about the advantages of having sorted flows in SSIS to greatly speed up data insertion using fastload. The need to have a sorted flow brings some severe problems to the SSIS programmer that he need to be aware of and that IMHO Microsoft should address with a future implementation of SQL Server. Let’s have a look at the ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on April 10, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement