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 » business intelligence   (RSS)
Showing page 2 of 3 (24 total posts)
  • SSIS is Case-Sensitive

    Introduction SSIS is case-sensitive even if the database is case-insensitive. Imagine...  ... you work in an ETL shop where someone who believes in natural keys won the Battle of the Joins. Imagine one of your natural keys is a string. (I know it's a stretch... play along!). Let's build some tables to sketch it out. If you do ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 28, 2010
  • It's Official, I'm a Geek

    I'm honored to join Glen Gordon (Blog - @glengordon) and G. Andrew Duthie (Blog - @devhammer) today at 3:00 PM EDT for an MSDN Webcast entitled GeekSpeak: Inside SQL Server Integration Services (SSIS). This is a LiveMeeting and you can join in the fun as an attendee here. It's a live show, so bring your questions! :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on March 24, 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
  • A week in Seattle

    Tomorrow morning I’ll fly to Seattle for the usual PASS Community Summit. I’m really happy for the next week. Even if this period is really full of work and a week away means that at my return I’ll have *really* busy times, the PASS Conference is always a nice break: meeting old and new friends, learning new things, enjoying beers and cocktails ...
    Posted to Davide Mauri (Weblog) by manowar on October 30, 2009
  • SET IDENTITY_INSERT little bug(?)

    While I was working on a package to incrementally load a dimension in the DWH I’m developing for a customer, I stumbled upon a tricky little bug (I think, I still have to have a response from MS) that had – and will have – a little impact on how I create my packages. I’ve found that, when working on an empty table that has an identity column, if ...
    Posted to Davide Mauri (Weblog) by manowar on September 30, 2009
  • Presenting at the PASS Application Development Virtual Chapter 8 Sep!

    Business Intelligence at RESTSeptember 8th at 1:00 PM EasternPresenter: Andy Leonard  I am honored to present Business Intelligence at REST to the PASS Application Development Virtual Chapter on 8 Sep 2009! This is going to be a fun presentation for me. I'm going to talk about my weather station and some business intelligence I've wrapped ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 3, 2009
  • Anatomy of an Incremental Load

    My article Anatomy of an Incremental Load was recently republished at SQLServerCentral.com. In the article I describe the base design pattern I use for doing incremental loads in SSIS. :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on August 17, 2009
  • Speaking at RichmondSQL Tonight!

    I am honored to present SSIS Design Patterns tonight at RichmondSQL! If you're in ther area, stop by for some free food and networking.  :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on August 13, 2009
  • Presenting Incremental Loads, CDC, and SSIS 2008 to Columbus SQL Server UG Tomorrow!

    I'm honored to present Incremental Loads, Change Data Capture, and SSIS 2008 to the Columbus SQL Server Users Group tomorrow evening! This is the first remote presentation I've attempted in a while. I won't be in physical attendance, only virtually. I'll be in my office in Farmville, VA. Isn't technology cool? :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on July 8, 2009
  • PASS Summit 2009 - From Zero to SSIS

    I learned a couple weeks back my proposal for a pre- or post-conference seminar entitled ''From Zero to SSIS'' had been selected as an alternate at the PASS Summit 2009. I was a little disappointed,  but then I looked at the incredible speakers and topics selected for pre- and post-conference seminars here.  These seminars ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 15, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement