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 (56 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
  • SSIS Design Patterns Training in London 8-11 Sep!

    A few seats remain for my course SQL Server Integration Services 2012 Design Patterns to be delivered in London 8-11 Sep 2014. Register today to learn more about: New features in SSIS 2012 and 2014 Advanced patterns for loading data warehouses Error handling The (new) Project Deployment Model Scripting in SSIS The (new) SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 16, 2014
  • Azure Automation – the beginning of cloud ETL on Azure?

    I have maintained a watching brief on what I refer to as “cloud ETL”, that is the ability build ETL routines in a cloud environment and therefore leverage all the benefits that the cloud model brings*. Thus far my main opinion piece in this area is What would a cloud-based ETL tool look like? in which I laid out what features I thought a cloud ETL ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 24, 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
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement