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 5 of 6 (54 total posts)
  • Why is it good to be comfortable with multi-threading?

    If you are an application developer, you should find a new job if you can't do multu-threaded programming. What if you are a DBA? Probably not, not to the same extent anyway. Some in our community clearly realize the importance of being able to do things in parallel. Adam Machanic, for instance, has put in a lot of efforts in this area and ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 8, 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
  • Connect Digest : 2011-04-18

    This week I decided to focus on a few suggestions revolving around automation and making certain tasks easier to script or deploy. The first one that came to mind was a recent request from Nicholas Cain (blog | twitter), asking for a SCHEMA_ONLY backup option - to make moving a database *without* the data a much easier process: #660256 : Add ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 18, 2011
  • [OT] : Windows Activation, en masse

    This weekend I discovered a minor issue in one of my virtual environments. I had built out 100 VMs based on a Hyper-V template, but I forgot to activate the original source before creating the template, so all of the machines were suddenly out of compliance. While easy enough on a one- or two-machine basis to just log into the machine and activate ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 13, 2011
  • Database Maintenance Scripting Done Right

    I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple ...
    Posted to Kevin Kline (Weblog) by KKline on February 18, 2011
  • 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 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