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 (25 total posts)
  • PASS Summit 2010 – BI Workshop

    PASS Summit 2010 Pre & Post conference are out! This year I’ll deliver the “Creating BI Solution from A to Z” seminar in which, as the title implies, attendees will see how to create a BI solution starting from scratch. Going through the dimensional modeling and the creation of the Datawarehouse, the implementation of the ETL process with ...
    Posted to Davide Mauri (Weblog) by manowar on June 30, 2010
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement