Monthly Archives: January 2008

My CodeCamp2008 Topic – Building a Windows App in Powershell

This coming Saturday, February 2nd 2008, I will be giving one presentation in both Spanish and English on "Building a Windows Application in Powershell".  So, here’s all the presentation material including some bonus code.  Enjoy!! Here’s the link to download the file: … Continue reading

Posted in PowerShell | Leave a comment

Come to our So.Florida CodeCamp 2008 on Saturday, Feb. 2th (all day event)…

Welcome to the FlaDotNet User Groups! Don’t miss this FREE Developer Event on Saturday – February 2, 2008 at Devry University in Miramar. For more information visit: http://codecamp08.fladotnet.comREGISTER NOW BEFORE IT FILLS UP!http://www.clicktoattend.com/?id=122048 I will be one of the speakers … Continue reading

Posted in IT/Developer Community Events | Leave a comment

Combining a COM object to a simple solution to get SQL Server Information

This is a simple solution that will generate a *.txt report with some SQL Server information. The “Scripting.FileSystem” COM Object is use to verify that the file is deleted before is created by the Powershell “Out-File” CMDlet. We’ll use the … Continue reading

Posted in PowerShell | Leave a comment

Building a Windows Application in Powershell (converting C#)

  C# code Powershell code this.button1 = new System.Windows.Forms.Button(); $button1 = new –object System.Windows.Forms.Button; New New-object This. $ () Not needed ; ;  can stay or removed >, <, =, !=… -gt, -lt, -eq, -ne… (look in the PS reference … Continue reading

Posted in PowerShell | Leave a comment

Powershell Quick Tips: SQL Server 2008 differences vs SQL Server 2005 when loading SMO GAC’s in PSscripts

First, I found SQL Server 2008 SMO is downward compatible with SQL Server 2005 and limited with SQL 2000.  So, when you build your Powershell SMO scripts, you need to load 2 SMO GAC’s in order for your script work. … Continue reading

Posted in PowerShell | Leave a comment

Powershell Quick Tips: Valid Folder name string when working with SMO .AddDevices()

When building a Powershell script with SMO to Backup/Restore databases I found an error when using folder names in the string.  The following foldername sample will show you what’s correct (or not) when using the .AddDevice() method in either SQL … Continue reading

Posted in PowerShell | Leave a comment