The Lonely Administrator

Friday Fun: Get Latest PowerShell Scripts

Probably like many of you I keep almost all of my scripts in a single location. I’m also usually working on multiple items at the same time. Some times I have difficult remembering the name of a script I might … Continue reading → Read...

Published Fri, May 18 2012 9:51 AM by The Lonely Administrator

Filed under: functions, Scripting, PowerShell, Friday Fun, Measure-Object, Out-Gridview

Introducing the ScriptingHelp PowerShell Module

Over the last few weeks I’ve posted articles on the different parameter validation options in Windows PowerShell. More than one person suggested consolidating the articles. That seemed like a good idea. There were a variety of ways to handle this...

Published Wed, May 16 2012 8:47 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, Training, PowerShell v2.0, ScriptingHelp

PowerShell Scripting with [ValidateNotNullorEmpty]

I’ve been writing about the different parameter validation attributes that you can use in your PowerShell scripting. One that I use in practically every script is [ValidateNotNullorEmpty()]. This validation will ensure that something is passed as...

Published Tue, May 15 2012 7:18 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, PowerShell v2.0, Validation

SQL Saturday 129 Session Material

I spoke this past weekend at a SQL Saturday event in Rochester, NY. My first SQL Saturday event and it was a lot of fun. A great turnout and some very interested attendees. I did three PowerShell sessions on jobs, … Continue reading → Read...

Published Mon, May 14 2012 8:51 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, Conferences, Powershell 3.0, scheduled task, SQLSat, Workflow, Windows 8, scheduled job

Friday Fun: PowerShell ISE Function Finder

At the PowerShell Deep Dive in San Diego, I did a lightning session showing off something I had been working on. Sometimes I don’t know what possesses me, but I felt the need for a better way to navigate my … Continue reading → Read...

Published Fri, May 11 2012 8:37 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, Friday Fun, PowerShell ISE, ISE, Out-Gridview, WPF, ShowUI

Quick and Dirty Excel from PowerShell

I continue to tinker with Office applications and Windows PowerShell. I was looking at an Excel issue related to opening a new workbook. To verify the problem wasn’t PowerShell related I offered a suggestion to try creating an Excel workbook …...

Published Thu, May 10 2012 7:56 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, Miscellaneous, Excel

San Diego 2012 PowerShell Deep Dive Slides and Demos

Last week at the PowerShell Deep Dive in San Diego, I did a short presentation on integrating Microsoft Office applications like Excel and Word with Windows PowerShell. I easily could have spoken much longer and probably tried to cram too … Continue...

Published Tue, May 08 2012 9:30 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, DeepDive, Conferences, TEC, Office

Friday Fun: PowerShell Countdown

Recently, Josh Atwell posted a PowerShell script that performed a countdown. Naturally, I was inspired and did the whole “embrace and extend” thing. Don’t get me wrong: Josh’s script is perfectly fine. I saw some opportunities...

Published Fri, Apr 27 2012 9:05 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, Friday Fun

FZ8D4JAWU7Q3

claim post. Nothing to see here. Read More...

Published Fri, Apr 27 2012 6:07 AM by The Lonely Administrator

Filed under: PowerShell

Technorati Claim – ignore me

Pay no attention to this post. FZ8D4JAWU7Q3 Read More...

Published Thu, Apr 26 2012 7:10 PM by The Lonely Administrator

Filed under: PowerShell

PowerShell Scripting with [ValidateCount]

Here’s another parameter validation attribute you might want to use in your PowerShell scripting and functions. If your parameter can take an array of values, you might want to limit that array to a certain size. For example, your parameter …...

Published Thu, Apr 26 2012 8:38 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, PowerShell v2.0, parameter, Validation

Skipping WMI System Properties in PowerShell

One of my favorite techniques when using WMI in PowerShell is to pipe an object to Select-Object and select all properties. Try this: get-wmiobject win32_bios | select * It works, but it also gets all of the system properties like … Continue...

Published Wed, Apr 25 2012 8:15 AM by The Lonely Administrator

Filed under: Scripting, WMI, PowerShell, ScriptBlock, Get-WMIObject

Convert Boolean Values

First, let me state right off the bat that what I have here should be for very special use cases and is NOT something I feel you need to be using at all. Now the use case: You are preparing … Continue reading → Read More...

Published Tue, Apr 24 2012 10:42 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, Convert, Boolean

PowerShell Scripting with [ValidateLength]

In continuing the exploration of parameter validation attributes, today we’ll look at [ValidateLength()]. You can use this attribute in your PowerShell scripting to validate that a parameter value is at least a certain length and no more and a certain...

Published Fri, Apr 20 2012 11:11 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, parameter, Validation

PowerShell Scripting with [ValidatePattern]

I’ve been writing about a number of parameters attributes you can include in your PowerShell scripting to validate parameter values. Today I want to cover using a regular expression pattern to validate a parameter value. I’m going to assume...

Published Thu, Apr 19 2012 9:20 AM by The Lonely Administrator

Filed under: Scripting, PowerShell, PowerShell v2.0, Regular Expressions, Validation

Recent Posts

Archives

Tags