Thought I’d take a minute and review the progress on my goals for the year. 100 posts. I’m at 32 (33 if you count this) so it’s going to take some dedication to make it. It’s already 10 more than last year, so that’s progress, but with 19 weeks left and 68 posts left, I’m …
I mentioned in a previous post that I’ve recently changed my mind a bit about the Position parameter attribute. I guess technically it is the position parameter of the Parameter parameter attribute (i.e. there’s a parameter attribute called “Parameter” and it has a parameter called position). I don’t think you could come up with something …
The Importance of Learning What You Already Know A couple of months ago I went to a PowerShell user group meeting on a subject that I already knew really well. Since it involved a 3-hour drive (one-way) I almost decided not to go. I had a great time, though, and I thought I’d share some …
Ok. I finally pulled the trigger on a major update (structurally, at least) to SQLSPX. This is the first big change in about 5 years. If you missed the post from a couple of weeks ago warning about this you might want to go back and read it. In short, SQLPSX hadn’t been updated in …
This is not a world-changing topic, but I thought it was worth sharing. If you have written hashtable literals on a single line, you’ve seen this before: Sometimes, it makes more sense to write the hashtable over several lines, especially if it has several items. I’ve always written them like this: I was watching Don …
Continue reading ‘You don’t need semicolons in multi-line hashtable literals.’ »
Last night Rob Campbell (@mjolinor) and I were talking after his presentation on performance when using Get-Content with -ReadCount and different string matching techniques and I realized it’s time to verbalize my thoughts on performance in PowerShell. Part 1 – It doesn’t matter When people ask me if PowerShell is fast, my first response is …
I get asked to look at other people’s PowerShell code a lot at work, and I really enjoy it. I also find myself looking at my “old” code from several years ago (back to 2007!) and think…there’s a lot of work to be done. To that end, I’ve compiled a list of “PowerShell code review …
If you’ve been using PowerShell for any amount of time you’ve probably written a lot of code. Here are some guidelines I’ve come up with for what I consider “Professional” code. I should note that I’m assuming some basic things like correct verb-noun naming, commented code, reasonable variable names, etc. Also, the code should work! …
Continue reading ‘7 Ingredients of Professional PowerShell Code’ »
About five years ago I gave a presentation to a boys group about the rate of change in computer hardware. I compared my first computer (a Commodore 64) and a laptop which I had just bought (a decent Asus laptop). The comparison was humorous. The almost thirty year old computer was several orders of magnitude …
I mentioned here that Invoke-SQLCmd (included in the SQLPS module for SQL Server) was susceptible to SQL-Injection attacks, but I haven’t demonstrated that or ever seen anyone show it. To do so, I’ll start with code out of the help for Invoke-SQLCmd. Here’s the code (taken from here) Notice that the parameters are encoded in a …
