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 5 of 5 (49 total posts)
  • T-SQL Tuesday #15 : Running T-SQL workloads remotely on multiple servers

      This month's installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: ''So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or with Powershell or a mix of both. Give us your best tips/tricks and ideas for making our lives easier through Automation.'' In a recent project, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 8, 2011
  • PowerShell, Start-Job, -ScriptBlock = sad panda face

    I am working on a project where I am using PowerShell to collect a lot of performance counters from a lot of servers.  More on that later.  For now I wanted to highlight an important lesson I learned when trying to use Start-Job to call a PS script using -ScriptBlock and passing in parameters.  This could be a comedy of errors if ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 29, 2011
  • Scripting for the out-of-band attention

    I have written a lot of throw-away scripts, some of which were written to control the execution of a large number of SQL scripts. The logic of these control scripts is often simple, but their execution can last for a long time (e.g. hours). When writing this type of control scripts, people would generally give some thoughts to improve robustness ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 20, 2010
  • Logging for post-processing

    As a practicing database professional, I'm sure you have done a lot of logging, I mean, output and/or error logging from your scripts, your scheduled jobs, and any other programs you might have written. The primary purpose of logging, of course, is to facilitate troubleshooting in case something goes wrong.  Often, people don't give much ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 17, 2010
  • 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  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
  • Get an overview report on your log shipping setups

    [Updated Dec 23 to include a T-SQL script at the bottom of the post].   You may have an environment where log shipping is set up on various databases between various servers. Would it be handy to have an overview report highlighting which database is being log shipped where? Even if you have some kind of record to keep track of the ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 21, 2009
  • Find the complete call tree for a stored procedure

    Would it be nice to print out the complete call tree of a stored procedure? By complete call tree, I mean the following:   ·              At the very top level, the call tree should identify all the procedures that are called ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 22, 2009
  • Managing multi-instance cluster failovers with different hardware

    Windows Clustering no longer requires identical hardware Because you can now easily create Windows clusters with different metal, I hear more and more about environments where nodes in a cluster are vastly different.  Whether this is because they can only deck out one server at a time, or because they need to mix older and newer hardware, it ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 18, 2009
  • Executing a large number of SQL scripts

    Say, you are given a large number of scripts underneath the following directory tree:   N:\Apps\Release\PRS\PR12345\CMP1\procs                                ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 4, 2008
Privacy Statement