Month: August 2009

2nd Annual Back to School with Microsoft & Oracle Event

* I am reposting this to let everyone know that they need to sign up now for the 2nd Annual Back to School event that we are holding September 15th,2009 in Indianapolis. Attendance is already above 100 people so book your space now. We have even had people from as far away as the west coast asking if we will be webcasting the sessions.. not this time ..sorry, but it has definitely sparked some more interest in doing a virtual conference! So look at the inf0rmation below and get signed up , we have a great line up of speakers on all kinds of DBA and Developer topics. This will be a good excuse to take off from work for some FREE training. What boss is going to turn that down, right???? My parent company Perpetual Technologies, Inc. is getting ready to throw their second annual Back to School with Microsoft & Oracle Event on Sept 16th , 2009. This will be a great event and to the best of my knowledge the only event that specifically looks to give presentations across both platforms. You can sign up for the event at the url below: Perpetual Event Sign Up Page! As always the event is FREE! So get up off your duffs and ask for a day off to attend because with a whopping 20 presentations it is sure...

Read More

Powershell Tip:Capturing Your Session Output

Continuing on my journey of quick Powershell tip blog posts, another option that you normally want with your script files is an easy way in which to capture your session information so that you can have a log of all of your commands and outputs. Luckily, Powershell makes this fairly easy for you with the Start-Transcript command. The command syntax is below: Start-transcript  <FileName> Stop-transcript So you can take a look at the output I got from my previous post on using the Format function in Powershell. ********************** Windows PowerShell Transcript Start Start time: 20090811211507 Username : PERPTECH\arie.jones Machine : LPT-AJONES01 (Microsoft Windows NT 5.1.2600 Service Pack 3) ********************** Transcript started, output file is log.txt PS C:\> [string]::Format("{0:C}",12.99) $12.99 PS C:\> [string]::Format("{0:###-##-####}",111223333) 111-22-3333 PS C:\> [string]::Format("{0:(###)###-####}",3178675309) (317)867-5309 PS C:\> stop-transcript ********************** Windows PowerShell Transcript End End time: 20090811211605 ********************** Unfortunately, it has been well documented that there are some shortfalls within the transcript process within this framework …,..to the extent that some recommendations have been to stop transcription before a statement that does not get logged( sorry no real way to figure that out without doing it) ..pipe it to append it to end of file…then restart. Kind of a big pain and I am sure that they will be working on a couple of fixes…So you will just have to try it out and see within your set...

Read More

Powershell Tip: Formatting a String with Format

One of the more useful tips that you will use almost everyday within your Powershell development experience will deal with data formatting. Powershell provides you with a Format function that for those of you familiar with data formatting  using String.Format will feel right at home. The syntax is basically as follows: [string]::Format(“{format structure}”, data value) So below I demonstrate a couple of common formatting structures for money, SSNs, and phone numbers but can be expanded upon in an number of ways… PS C:\> [string]::Format("{0:C}",12.99) $12.99 PS C:\> [string]::Format("{0:###-##-####}",111223333) 111-22-3333 PS C:\> [string]::Format("{0:(###)###-####}",3178675309) (317)867-5309 Cheers, AJ   Technorati Tags: powershell,scripting,powershell tips,powershell tip,tricks,formatting,string.format,string formatting,format...

Read More

Microsoft TechNet Scripting Center

Here is a great resource for those people looking for tools and hints concerning everything related to scripting. This TechNet site has everything from vbscript to PowerShell along with a wide array of tools and advice to get you through those sticky situations. Microsoft TechNet Script Center Cheers,...

Read More

Log Parser

A colleague of mine asked me if I had a tool that would easily read in and parse a deadlock log file. The Log Parser utility from Microsoft easily accesses text based data in various formats(e.g. XML,Log Files, and Event Logs). You can download the Log Parser 2.2 from the url below: http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en Cheers, AJ Technorati Tags: sql server,log parser,xml,log files,event...

Read More