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 5 (48 total posts)
  • 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
  • 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
  • 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
Privacy Statement