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)
  • Schedule an SSIS Application with SSIS Framework Community Edition

    This blog has moved! You can find this content at the following new location: http://andyleonard.blog/2017/07/27/schedule-an-ssis-application-with-ssis-framework-community-edition/
    Posted to Andy Leonard (Weblog) by andyleonard on May 8, 2017
  • 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
  • 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
  • Pain of the Week/Expert's Perspective: Performance Tuning for Backups and Restores

    First off - the Pain of the Week webcast series has been renamed.  It's now known as The Expert's Perspective.  Please join us for future webcasts and, if you're interested in speaking, drop me a note to see if we can get you on the roster! The bigger your databases get, the longer backups take. That doesn't really seem like a ...
    Posted to Kevin Kline (Weblog) by KKline on June 27, 2011
  • New on SQLMag - Automating the Startup and Shutdown of Windows Services

    I just posted a new blog entry on how I automate the shutdown and startup of Windows services. Check it out at http://www.sqlmag.com/blogs/tool-time.aspx.  Be sure to let me know what you think and if you have your own unique methods for automating the control of Windows services!Many thanks,-Kevin-Twitter @kekline-More content at ...
    Posted to Kevin Kline (Weblog) by KKline on April 27, 2010
Privacy Statement