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   (RSS)
Showing page 1 of 6 (52 total posts)
  • 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
  • Declarative ETL

    T-SQL is a declarative programming language. This means that a T-SQL developer defines what (s)he wants the query to do, not how to do it. The secret sauce that turns the “what” into the “how” is a piece of software called the query optimiser and there are tomes dedicated to how one can make the query optimiser dance to their will. Generally the ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 16, 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
  • ETL is dead, long live AP2 ?

    Three days ago I posted What would a cloud-based ETL tool look like? where I wondered out loud about the sorts of tools data integration dudes like myself would be using in the future. I got some good feedback and already have a list of “stuff” to go and look at including: Boomi – They claim 1million cloud integrations (whatever one of those ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 15, 2013
  • What would a cloud-based ETL tool look like?

    Given that “moving data to the cloud” is, rightly or wrongly, currently in vogue in our industry I have to think that pretty soon there will be a glaring need for tools that help us to move data between these heterogeneous sources – a cloud-based ETL tool for cloud-based data if you will. Perhaps such a thing already exists -I’ve talked about ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 12, 2013
  • SSIS Design Patterns, the Book

    For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current publication date is 27 Aug 2012 and I have high confidence in this date. I take ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 6, 2012
  • 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
  • Simplifying CSV Data Loads

    Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database.  When it comes to loading CSV data into the database, many options exist, however, few make it as simple as CSVexpress, powered by expressor software.  I recently visited ...
    Posted to Kevin Kline (Weblog) by KKline on October 27, 2011
  • Thoughts on Data Explorer

    To my mind the most interesting piece of news to come out of the recent PASS conference was the unveiling of a new SQL Azure Labs project coming from the SQL Server organisation that has the codename ''Data Explorer'' (not a very imaginitive codename I'm sure you'll agree) and for which there is information available at ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 24, 2011
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement