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 » ETL » SSIS   (RSS)
Showing page 1 of 4 (39 total posts)
  • A Biml Case Study

    Business Intelligence Markup Language (Biml) is a SQL Server Integration Services (SSIS) design patterns engine. A Story of Productivity A while back I was contacted by a client experiencing a familiar issue. The Production SQL Server instance was experiencing performance issues due to conflicts between customers and enterprise reporting needs. ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 26, 2014
  • Presenting Enterprise Information Management in SQL 2012 and SQL 2014 in Reston 16 May!

    I am honored to participate in the Reston SQL Server 2014 Launch Update event – a half-day event held 16 May 2014 at the Microsoft Reston Office. You can learn more and register here. Art Rask will kick-off the event with an overview of new features of SQL Server 2014, including: Integrated In-memory technology AlwaysOn HA / DR for ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 17, 2014
  • Automate Your ETL Infrastructure with SSIS and PowerShell

    SQLPASS TV channel has been published the session Automate Your ETL Infrastructure with SSIS and PowerShell that Allen White (@SQLRunr) has done during the PASS Summit 2013.  Abstract Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on December 25, 2013
  • Little Data Remains Important in Healthcare IT

    In his article Healthcare's Big Problem With Little Data, author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization that, I suppose, many thought would organically and naturally occur, stabilize, and be ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 30, 2013
  • Have You Downloaded SQL Server 2012 Evaluation Edition? Why Not?!

    I am installing SQL Server 2012 Evaluation Edition on a virtual machine as I type. You can do this. Here’s one way: Grab some virtual machine software. I like Oracle VirtualBox. It’s cool. It’s free. Install VirtualBox. Download the 180-day free trial of Windows Server 2008 R2. Also cool. Also free. Once Windows ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 8, 2012
  • Updated SSIS Framework, Now Includes Reports

    I have built a beta version of Linchpin People’s SSIS Framework, now including much-requested reports. You can grab the updated copy here. I appreciate any feedback you care to share. :{>
    Posted to Andy Leonard (Weblog) by andyleonard on March 7, 2012
  • Stairway to SSIS Step 3–Adding Rows in Incremental Loads

    If you haven’t yet, check out the Stairways – a series of tutorial articles at SQL Server Central. They. rock. I was really excited when Steve Jones (Blog | @way0utwest | SQLPeople) contacted me to write the Stairway series of tutorials for SSIS! The third article is live this morning. Altogether, the published articles are: What is SSIS? ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 16, 2011
  • Designing an SSIS Framework

    In preparation for SQL Saturday #84 – Kalamazoo,  SQLBits 9, and the PASS Summit 2011; I’ve been honing my presentation called Designing an SSIS Framework. I delivered this presentation a few times over the past couple months. Each time, I promised the attendees I’d send them the code if they emailed me… and a couple things got in the ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 16, 2011
  • Presenting at SQL Saturday #84–Kalamazoo 17 Sep 2011!

    Introduction I am honored to present Designing an SSIS Framework and “I See a Control Flow. Now What?” at SQL Saturday #84 in Kalamazoo Michigan 17 Sep 2011! I See a Control Flow. Now What? This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 7, 2011
  • I Am Here To Help™

    Introduction This isn’t a trick. It’s not a gimmick. It’s not bait-and-switch. It is selfish; please allow me to explain: I Am Here To Help™ This has been my motto for the past few years. How can I serve you today? Are you thinking about starting a User Group and don’t know where to begin? I can help. Are you planning an event and encountering ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 19, 2011
1 2 3 4 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement