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 1 of 2 (18 total posts)
  • 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
  • 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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement