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 » Automation   (RSS)
Showing page 1 of 3 (30 total posts)
  • Coming Soon: A Command-Line Interface for Managing SSIS Catalogs

    I’m excited to announce CatCompare – a command-line interface (CLI) for SSIS Catalog Compare – is in pre-release testing. I plan to release the next update of SSIS Catalog Compare with an option to purchase the GUI product stand-alone or the GUI + CLI for a higher price. BUT… If you purchase SSIS Catalog Compare before that release, you can ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 11, 2016
  • Updates to SSIS Catalog Compare (Preview)

    The launch of SSIS Catalog Compare is approaching. If you purchase the beta (or preview) version before the v1.0 product launch for $95 USD, you will enjoy lifetime updates of the product and no yearly maintenance fees for support, updates, and upgrades. If you wait, you will have to pay more for the product and you will have to pay a yearly ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 21, 2016
  • Biml 103–Automating SSIS Design Patterns with Biml Recording is up!

    The Biml 103 webinar “Automating SSIS Design Patterns with Biml” recording is now available. Registration is required, but it’s free. Enjoy! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on January 14, 2016
  • SSIS Catalog Compare and DILM Recording is now available!

    You can now view the recording from the SSIS Catalog Compare and DILM presentation here. I’m trying something new here, so please bear with me. This link takes you to a registration page. After you register, you can view the recording. Enjoy! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on December 30, 2015
  • ETL Instrumentation in 2016

    A long time ago in a galaxy far, far away… I wrote about ETL Instrumentation. Ok, it wasn’t that long ago, and it wasn’t far away. But things have changed some since I wrote that series, and I would like to spend some time updating the material. I’m typing this post at the end of 2015, so I’m using SQL Server 2016 CTP 3.2 running on Windows ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 26, 2015
  • Presenting “Use Biml to Automate SSIS Design Patterns” at SQL Saturday-Nashville!

    I’m honored to present “Use Biml to Automate SSIS Design Patterns” at SQL Saturday – Nashville 16 Jan 2016! Abstract: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 21, 2015
  • Precon - SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgia

            I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for SQL Saturday 477 – Atlanta BI Edition titled SSIS Design Patterns and BIML: A Day of Intelligent Data Integration! This precon is all about DILM (Data integration Lifecycle Management). Abstract: SSIS Design ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 12, 2015
  • Biml 101 – A Free Webinar 18 Nov 1:00 PM EST

    If you’ve heard the buzz about Business Intelligence Markup Language (Biml) but never used it, you may be curious about how Biml works and how it can help reduce the amount of time required to develop SSIS packages. In this 100-level presentation, BimlHero Andy Leonard demonstrates how to use Biml to build an SSIS package. Register here. I ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 4, 2015
  • Browsing the Catalog with SSIS Catalog Compare

    One neat feature of SSIS Catalog Compare is the Catalog Browser. It’s a TreeView control that connects to the SSIS Catalog and displays handy information for Data Integration Administrators and Release Configurations people working in a DevOps enterprise. The Integration Services Catalogs node in SQL Server Management Studio’s (SSMS) Object ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 21, 2015
  • SQL Formatting Matters…

    … to some folks more than others. We likely all have stories about working with folks who care a lot about the format of their SQL statements. I’ve worked with a lot of database developers and analysts. I cannot say SQL formatting distinguishes the good from the bad (or ugly), but I have noticed the sharpest developers have a preferred SQL ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 20, 2015
1 2 3 Next >
Privacy Statement