THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » ssis   (RSS)
Showing page 2 of 42 (414 total posts)
  • BI on your terms with SQL Server 2016

    The last few years Microsoft's strategy was all about cloud first (or cloud only?), releasing new BI products and updates to existing products to the cloud in high pace without almost any investments in on-premises BI. In 2015 Microsoft seems to change its course, they now aim more on the enabling of hybrid scenarios, investing a lot in both ...
    Posted to Jorg Klein (Weblog) by jorg on May 22, 2015
  • Want to Learn More About SSIS and Biml? Upcoming Training Opportunities!

    Here’s a list of upcoming training opportunities for people wanting to learn more about SQL Server Integration Services (SSIS) and Business Intelligence Markup Language (Biml): Office Hours: Is Biml Right for You? Live Q & A Webinar 27 May 2015 at 12:00 PM EDT. Register, it’s FREE! Advanced SSIS Design Patterns and Automation with Biml ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 21, 2015
  • Great Scott! Linchpin People is Going… Back to SQL Saturday Atlanta!

    SQL Saturday #392 is happening THIS SATURDAY! I’m looking forward to returning to Atlanta, where almost everyone speaks without an accent. The schedule looks awesome! I’m excited that several Linchpins were selected to present because this means we’ll get to hang out in person. I’m also excited to see so many friends from #SQLFamily, too, ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 14, 2015
  • Advanced SSIS Design Patterns and Automation with Biml PASS Essential Deutschland–15 Jun 2015!

    I am honored to deliver a full-day PASS Essential in Germany 15 Jun 2015! I’ll be sharing: Advanced SSIS Design Patterns and Automation with BIML Advanced SSIS Design Patterns for performance, support, and maintain-ability Data Flow performance patterns SSIS Catalog-integrated Execution Frameworks Connections and ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 11, 2015
  • COD Hotfixes available for SQL Server 2014 (SSIS Unpivot and Clustered Columnstore)

    Microsoft has released a hotfix (12.0.2504) which includes two fixes. KB #2999809 : FIX: Poor performance when a query contains table joins in SQL Server 2014 - this actually has to do with segment elimination in clustered columnstore indexes. KB #3058512 : FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 10, 2015
  • Real World SSIS: A Survival Guide, 8 May, Baltimore

    My friend and fellow Linchpin, Tim Mitchell (blog | @Tim_Mitchell) will deliver a day-long seminar titled Real World SSIS: A Survival Guide the day before SQL Saturday – Baltimore (9 May). Attend and learn more about: Handling warnings, errors, and other bad stuff Data cleansing using SSIS, T-SQL, and DQS More than just a green box: ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 8, 2015
  • Software Economics and Testing

    “There are two types of developers: those who test their software and those who will.” – Andy, circa 2015 It’s April Fool’s Day in the US, but I’m going to act like it’s Halloween. Software testing is no joke, and not testing should scare you. In 1996 (yes kids, years used to begin with a “1”), in the sixth issue of Fast Company ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 1, 2015
  • Tabular Data Packages and a BIML challenge

    Update. The challenge set below has been responded to by Scott Currie who also happens to be the inventor of BIML. He has made his work  available at In February 2004 I joined a company called Conchango and had the pleasure of working with some very very smart people (Mick Horne, Dan ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 27, 2015
  • Announcing SSIS Design Patterns Training in London 7-10 Sep 2015!

    I am honored to work alongside TechniTrain to deliver SQL Server Integration Services Design Patterns in London 7-10 Sep 2015! Register before 31 Mar to save £100. Who is it for? The target audience for this course is intermediate SQL Server Integration Services developers (or quick learners) who wish to learn best practices and design ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 11, 2015
  • Secure Connections Management in SSIS, Part 2

    SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers In Secure Connections Management in SSIS, Part 1, I demonstrated configuring an SSIS Connection ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 2, 2015
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement