For awhile now I’ve been working on a PowerShell project that I use every day. I am always in a PowerShell prompt and because I always seem to have little things like phone calls or family events that I need to keep track of, I wrote a “tickler” system. The events are stored in a SQL database any my PowerShell commands query for upcoming events. My module has commands for setting up the database, querying commands and modifying data. All the SQL stuff is done without using the SQL PowerShell module because I didn’t want to take a dependency on it and I want to write something that will work cross-platform. I wasn’t sure if the SQL cmdlets would be 100% compatible, plus my needs were simple so I found it easier to write my own query function. Today, I decided to launch a semi-public beta and share it with you.
I’ve blogged in the past about Wayne Martin and his outstanding list of command line tips. These are one line commands, some complex some simple, that you can use to accomplish a wide range of task. The overall number of tips is to 425 and Wayne recently reorganized them into 7 categories to make it easier for people to digest. There’s very little scripting with any of these commands. Most use native or freely available command line tools. But because they are executed from a command line you could incorporate them into a script. I encourage you to check them out.
The single list:
The same commands split into categories:
There is a very nice review of the new Powershell book at :
I’m glad he likes the book, even though he doesn’t know who I am. But I’m working on it!! Anyway, the interesting point in his review is that he is looking at PowerShell from the perspective of a SQL DBA. In his review he makes a compelling argument for DBAs to start learning PowerShell. In fact, he believes PowerShell is the next logical step for admins who are already scripting. Naturally, I’m going to agree.
Whether you’re a DBA or not, if you do any sort of automation or administrative scripting, Windows PowerShell should be incoming hot and heavy on your radar screen.