I love the ISE. I’ve used other “environments”, but always end up using the good old ISE. I do use the awesome ISESteroids module by Tobias Weltner (powertheshell.com), but most of the time you can find me in the unadorned, vanilla ISE. With that bit of disclaimer out of the way, there is something that …
Continue reading ‘The Two Faces of the ISE Run Button (and a bit of bonus evil)’ »
Have you ever heard of Rubber Duck Debugging? The idea is simple. If you’re having trouble debugging code, just put a rubber duck on your desk and explain what’s happening in your code to the duck. Seems absurd, but the act of verbalizing the code situation is usually enough to break the log-jam in your …
Using PowerShell and MySQL together with POSH_Ado is just as easy as SQL Server. You’ll need the POSH_Ado and POSH_Ado_MySQL Modules, and use this command to get started: Once you’ve done that you’ll have the following functions at your disposal: New-MySQLCommand New-MySQLConnectionString New-MySQLCommand Invoke-MySQLCommand Invoke-MySQLQuery Invoke-MySQLStoredProcedure These functions work just like the ones for SQLServer …
One of my most popular answers on StackOverflow is also one which has a tiny bit of controversy. It involves how to “hide” helper functions in a module in order to keep them from being exported. Export-ModuleMember Details In case you’re unfamiliar with how exporting functions from a module works, here are the basic rules: …
Continue reading ‘Breaking the rules with helper functions’ »
PowerShell and lists of data go together hand-in-hand. Any time you execute a cmdlet, function, or script, the output is a list of objects which is placed in the output stream for processing. Assigning a list to a variable is not very interesting, either. You just assign it and it’s done. Like this, for instance: …
This is kind of long-winded, if you want, skip down to the code and it should be clear (I hope). Where the story starts As I mentioned here, the original adolib module got copied a few times and with cut-and-paste programming got turned into modules for other database platforms. While it was cool that it …
In the last post, I gave a quick history of my involvement with SQL and SQLPSX. A big part of that was the ADOLib module in SQLPSX, which I haven’t ever really explained here. Since it has been almost 6 years now, I don’t see how I have managed to skip it. This post should …
Almost 6 years ago I wrote this post about how I thought you should go about executing SQL statements and queries in PowerShell. It included a function which allowed you to pass a hashtable of parameter names and values. This post has been one of the most popular on the site. I submitted a module to …
Continue reading ‘Executing SQL the right way in PowerShell (revisited)’ »
I’ve been meaning to write about this for a while. It’s a simple thing that broke some code from PowerShell 1.0. Yes, I still have some code running in production that was written back before 2.0 came out. And before I go any further let me say that PowerShell has done a remarkable job in …
Continue reading ‘Scope delimiter in interpolated strings’ »
I’m not super crazy about writing one-liners in PowerShell, but I ran across a fun problem which was quick to write as a one-liner. I’ll give that here with a little explanation, and follow up in a couple of days with a more polished advanced function solution. Anyway, the problem was that I was working …
Continue reading ‘Cleaning the Path – A PowerShell One-liner’ »
