Regular expressions go all the way back to 1956. I think I first saw them in the PERL language; but today in 2015, they are very useful in Powershell, C# and most every language. Regular Expressions have three main purposes: 1. Validate if text conforms to a pattern 2. Capture (extract) a string (or series […]
Intro to Oracle for SQLServer Developers and DBAs 1. Oracle has something called V$ tables, which are essential similar to the Dynamic Management View (DMV) of SQLServer, Here are two examples: select * from v$database; select * from v$thread; Result – this shows that my 11g Express Edition has both an instance name of “xe” […]
Intro to Oracle SQL for SQL Server Developers and DBAs This is an Intro to Oracle SQL for SQLServer Developers and DBAs, and probably Part 1 of several blogs that I will write as I learn more, and make more newbie mistakes. You probably already know that Microsoft implementation (or extension) of the “standard” SQL […]
This blog shows you how to How to Add and Delete MSMQ Queues from Powershell, programmatically, via a simple re-usable function. I used the code from this blog as a base: http://blogs.msdn.com/b/sajay/archive/2010/03/18/powershell-script-to-create-an-msmq.aspx. His code is fine, but it’s from an administrators perspective, i.e. run this Powershell, pass it some parms. I wanted the same code […]
How to Get the Last Line of a File Have you ever needed to read just the last line of a file (i.e. “the last row”) in Powershell? It’s easier than I thought. If you ask for the last several rows (as shown in the commented-out code in the example below, you will get back […]
I found the base code for this here: http://vstepic.blogspot.com/2013/02/how-to-convert-string-to-base64-and.html. If you want to know more about Base64, check out this Wikipedia Entry But I’m not a command-line guy, I’m a developer, and I like to have my code in a file where I can edit it, modify it, re-use it, and run it. Function Base64Encode($textIn) […]
Powershell has the Add-Content cmdlet to append data to the end of a file. While it also has Export-CSV cmdlet, that seems to be more for dealing with collections where you pipe a collection of objects directly to the CSV (Comma Separated Value) file. What if you have several variables and you want to put […]
The following example is available in the BizTalk SDK, and represents an 850 “Purchase Order Document”, We will be describing some how to read this EDI data in this blog. <code> ISA*00* *00* *ZZ*THEM *ZZ*US *991221*1226*U*00401*000000025*0*T*> GS*PO*THEM*US*19991221*1226*1*X*004010 ST*850*0001 BEG*00*NE*3859199838**950727***IBM PER*AA*Andrew Carlson*TE*(708) 555-2930 DTM*002*970523 PO1*1*93*BX*145.39**CB*KOW-20392-10 PID*F****Uninterruptible Power System PER*AA*Camilla Anderson*TE*(708) 555-2011 PO1*2*25*EA*35.68**CB*1093-4927-001 PID*F****High Volume Printer Stand PER*AA*Miranda Cappelan*TE*(708) […]
I’m building a little app that is driven by an XML configuration file. I need to substitute variables from the XML with a random name or a keyword from another source, so I used $Keyword and $MaleName and $FemaleName. Look at this code, and see if you can spot the bug. Every single text field […]
<pre> [Reflection.Assembly]::LoadWithPartialName("System.Messaging") cls $queueName = '.\Private$\NealTest' $queue = new-object System.Messaging.MessageQueue $queueName $utf8 = new-object System.Text.UTF8Encoding $msgs = $queue.GetAllMessages() write-host "Number of messages=$($msgs.Length)" foreach ($msg in $msgs) { write-host $msg_.Id write-host $utf8.GetString($msg.BodyStream.ToArray()) } </pre> Depending on how many times you wrote messages to the queue, the output will look something like this: