PowerShell: Read-Host On Steroids – Enhancements To Jeff Hicks Version

A better Read-Host - by Jeff Hicks Read-Host is very useful but it is too simplistic to write "good" code using it. Jeff Hicks (Twitter: @JeffHicks, Blog: jdhitsolutions.com/blog/)  who needs no introductions in the PowerShell world (and whose books I read to learn PowerShell), created a better Read-Host. I love his version. Please checkout the nice … Continue reading PowerShell: Read-Host On Steroids – Enhancements To Jeff Hicks Version

PowerShell – Hate The Error Text And Warning Text Colors? Change It!

How could such a nice tool have such a terrible choice of colors for errors and warnings? I am talking about the ISE and the unreadable contrast of colors. You can fix it. Open and update your profile by running this from your ISE (which opens your profile in NotePad) notepad $profile Add the above … Continue reading PowerShell – Hate The Error Text And Warning Text Colors? Change It!

SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)

In mature IT shops, all deployment scripts in a release are run into the database using command-line batches as opposed to doing it by hand. Error running SQLCMD scripts in SSMS Occasionally, when one is testing a single script within a release to make sure it works, he/she needs to jump to the command line to … Continue reading SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)