Skip to content

The Powershell Challenge

November 7, 2013

indexI’ve been wanting to do more with Powershell (PoSh). I’ve seen Allen White present on it for years, and I’ve dabbled in various ways, using it to handle small tasks. However I haven’t really committed to learning a bunch of PoSh.

Last month I was with Grant Fritchey on the 2013 SQL in the City tour and in one of his sessions, he uses some Powershell to audit his SQL Server instance. I thought that was pretty cool, and it made me want to dig in further. At the end of his talk, he mentioned a book, and I decided to grab it.

It’s Learn Windows Powershell 3 in a Month of Lunches from Don Jones. The name alone made me want to grab it, and it has a catchy title.

My plan is to take time every day or two and read a chapter and work through exercises in the book. I really want to get more comfort in PoSh because I do believe in it and I think it’s a fantastic way to get things done. I don’t work at scale, but I suspect with a little practice I’ll be using PoSh more often for simple things and saving those scripts.

I’ll blog along the way and see how things are going. Once I get through, I expect that I’ll be digging into more with other articles and books that deal specifically with SQL Server.

The days in the Challenge:

About these ads

From → Blog

12 Comments
  1. If you move into using Azure, you’ll not survive without it! Certainly worth getting up to scratch if Azure is ever a consideration. I’m not an expert in Powershell, but I know enough to do whatever I want, which has proven very useful.

    • Yep, part of my focus here is because of all the Azure demos that seem to require it.

  2. Azure is definitely one more reason for learning PowerShell. But, the biggest draw for this would be the effort vs. rewards that are attached with learning PoSH. It is like playing Diablo-II in Nightmare mode with GOD hack turned on.

  3. Robert Sterbal permalink

    Powershell is a pretty cool OS lock in. You won’t create a billion dollar service on the Windows platform, but you can do a lot of work much more efficiently this way. My fascination is be able to run the scripts solely using xp_cmdshell.

    • Really? I bet there are some billion dollar services on the Windows platform. Years ago Dell was selling $1b/yr on their website, powered by SQL Server and Windows.

      I agree that it is a bit of a lock in, but so is .NET. If you’re a Windows shop/person, it’s a valuable tool and because all other tooling is being built on it, learning this is a good way to roll your own tools together.

  4. Robert Sterbal permalink

    I’m meant 1-3 billion dollars of owner equity (Instagram, Snapchat) in months with code and scripts. Windows still runs a ton of devices, and having a tool to reach them efficiently is important. It is just costly to scale.

  5. vikas pathak permalink

    I am new in powershell learning, but I am eager to know and dig it.can you please suggest any book that help me to learn from scratch.

  6. Will H permalink

    I know I’m late to the party, but I bought this book a few months ago (bad timing right before a big move) and I’m going to try to catch up and work through it, too!

Trackbacks & Pingbacks

  1. Budget for Training | Voice of the DBA
  2. T-SQL Tuesday #50–Automation | Voice of the DBA
  3. Starting to Use Powershell | Voice of the DBA

Comments are closed.

Follow

Get every new post delivered to your Inbox.

Join 4,953 other followers

%d bloggers like this: