Why Adolib (and POSH_Ado)?

I’ve realized that in my explanations of Adolib and POSH_Ado, I left something important out. Why in the world am I spending all of this time and effort writing database access modules when there are already tools out there (SQLPS, for instance) which work. The simple answer is SQLPS is not good enough for several …

Continue reading ‘Why Adolib (and POSH_Ado)?’ »

Getting Started with POSH_Ado

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 …

Continue reading ‘Getting Started with POSH_Ado’ »

Executing SQL the right way in PowerShell (revisited)

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)’ »