Dec 10 2010

12 Days of SQL, On the 2nd Day of SQL…

Microsoft gave to me, an excellent new management language. Yeah, so it doesn’t rhyme or match the song in any way, but as far as gifts of the season go, PowerShell is it. There are a couple of problems with PowerShell, first, it’s not installed everywhere, and second, DBAs just haven’t quite latched on to this new language as a management tool.

That second problem is absolutely not one that I would say about Aaron Nelson (blog|twitter), our next 12 Days of SQL blogger.  Aaron is one of the leading lights out there educating DBAs, and everyone else for that matter, about the strengths and capabilities of PowerShell as a management language for SQL Server. I’ve said it twice, and I hope you noticed, but I didn’t say scripting language, because PowerShell isn’t. It’s a management language. It’s a way to automate the management of your servers and that’s what Aaron’s work is all about. He blogs and tweets and presents quite a lot about PowerShell. If you’re trying to learn this excellent tool, you should be reading his stuff.

In particular, the post that has me the most excited, out of all the work that Aaron has done this year, is this excellent explanation of remoting with PowerShell. Why this post in particular? Because remoting, combined with asynchronous calls means you can send a PowerShell script to any or all servers in your environment, at the same time. It means you can perform serious, enterprise level management tasks in an automated and repeatable fashion and you can do it to all your servers at the same time, easily. Yeah, I said easily. That’s because it is easy. Read Aaron’s excellent explanation and you’ll agree. Once you understand how to call all your servers remotely, it’s even easier to then pass them a script, call a stored proc, send a DBCC command, or just about anything else. This is why I call PowerShell a management language, because we’re not talking about scripting here, we’re talking about managing your servers, and that’s exciting.

On the 3rd Day of SQL, Microsoft gave to me, 3 excited screams… Sorry, but you’ll have to wait until Monday for the next installment, but the wait, I assure you, will be worth it. That’s because David Stein (blog|twitter) will be shouting a post in your direction that will absolutely be something you want to hear (and you’ll hear it, loud & clear). Now, I’m teasing Dave, and you can ask him why, but I mean it in good fun. David’s a FreeCon alumn, a nice guy, and a talented individual. If you’re not checking his stuff regularly, you really should be.


  • By Kendra Little, December 10, 2010 @ 9:34 am

    That really is a great post. Nice pick!

  • By Sandra A Mueller, December 10, 2010 @ 9:40 am

    LOL — Leading Light 🙂

    Great post!

  • By Grant Fritchey, December 10, 2010 @ 10:07 am

    Thanks. I really do love Aaron’s work. I tried keeping up with him for a bit, but he just stomped me into a mudhole. Now I follow along behind going “cool, cool”

  • By Brian Garraty, December 10, 2010 @ 10:12 am

    Looks like Aaron’s post is exactly what I was looking for earlier this week. Thanks Grant and Aaron!

  • By Karen Lopez, December 20, 2010 @ 2:42 pm

    I’ve been doing some nifty things learning Powershell…or #PoSh, as the kool kids on Twitter call it. All thanks to Aaron.

    Glad you picked it, Grant.

  • By lasercap laser tag, July 30, 2014 @ 10:29 am

    When using this product regularly, most users also notice new growth in areas that were previously thinning.
    It can affect the appearance, confidence, and maybe even the
    self esteem of a person. The step-by-step method of using castor oil for hair
    loss treatment:.

  • By lulu boutique dresses online, September 11, 2014 @ 4:36 am

    And a beautiful dress with pants for the first day of school.

    Once again this course is conducted via email at one email per week over a period of eight
    weeks. On the contrary side, old females may wish to imitate the
    styles of some middle aged stars.

Other Links to this Post

  1. The Twelve Days of SQL Series | Brent Ozar - Too Much Information — December 15, 2010 @ 9:08 am

  2. The 9th Day of SQL: Things Aren’t as Simple as They Seem « — December 21, 2010 @ 9:14 am

  3. On the 10th day of SQL… « Crys's Crap — December 22, 2010 @ 11:03 am

  4. 12 Days Of SQL – What is your Over / Under? | InfoAdvisors' Blog — December 22, 2010 @ 11:48 am

  5. On The 11th Day of SQL | StraightPath Consulting's SQL Server Blog — December 23, 2010 @ 9:23 am

  6. What I’ve Been Writing Lately | Brent Ozar - Too Much Information — December 27, 2010 @ 7:01 am

  7. The Twelve Days of (SQL) Christmas « Voice of the DBA — January 10, 2011 @ 12:04 pm

RSS feed for comments on this post. TrackBack URI

Leave a comment