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 » Automation   (RSS)
Showing page 1 of 3 (24 total posts)
  • 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
  • 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
  • Using NLog With BIDS Helper to add logging to BIML Script executions

    When using BIML within BIDS Helper, if your BIML Script files get complex it may be quite hard to debug BIML Script Execution in order to understand what’s going on behind the scenes. On Windows Server 2008 it was possible to use the System.Diagnostic.Debug.WriteLine and DebugViewer from SysInternal to do the trick but it seems that this approach ...
    Posted to Davide Mauri (Weblog) by manowar on December 3, 2014
  • Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

    The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.Hear one of my most popular session via streaming media at SQLSentry.TV!Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy.  And it doesn’t ...
    Posted to Kevin Kline (Weblog) by KKline on April 9, 2014
  • Build Your Own Microsoft Operations Manager Pack

    Operations Manager Management Pack Development KitI just recently told you about some cool new things happening with System Center - before I stumbled across this tidbit.  Hey, if I could, I'd go back in time and add this entry to the previous one --- yeah, and totally NOT play the stock market to make a fortune through time travel. ...
    Posted to Kevin Kline (Weblog) by KKline on May 3, 2012
  • New White Paper: SQL Server Extended Events and Notifications

    SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred.  There's PerfMon, and Profiler, and loads of Dynamic Management Views to check.  But where to look? As ...
    Posted to Kevin Kline (Weblog) by KKline on April 25, 2012
  • Everybody Needs a Test Harness

    When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
    Posted to Kevin Kline (Weblog) by KKline on October 31, 2011
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement