What's New Here?Subscribe to RSS feed
#PSTip Deleting expired certificates from the personal certificate store
We use a lot of certificates for website authentication, and they expire each year. Some people end up with a collection of expired certificates. That makes it hard to find…
#PSTip Use Excel to View HTML Output
Excel can be used to view HTML. If you add some CSS styles to the result of ConvertTo-HTML you can add much more rich output to Excel then you would…
Working with non-native PowerShell encoding (EBCDIC)
The -Encoding parameter in many native I/O cmdlets uses the [Microsoft.PowerShell.Commands.FileSystemCmdletProviderEncoding] enum. Files that come from an IBM mainframe such as the AS/400 are often exported to ASCII or Unicode…
Desired State Configuration in Windows Server 2012 R2 – Online hands on lab
I am sure you all must have already looked at the Desired State Configuration (DSC) feature announcement by Jeffrey Snover and Kenneth Hansen at TechEd 2013. This exciting change is…
#PSTip Deleting a SQL mirroring endpoint with SMO and PowerShell
Note: This tip requires PowerShell 2.0 or above. In earlier tips, we looked at how we can get all SQL endpoints, check if a SQL endpoint exists or not, and creating…
#PSTip Creating a SQL TCP mirroring endpoint with SMO and PowerShell
Note: This tip requires PowerShell 2.0 or above. In today’s tip, we will see how we can use PowerShell and SMO to create a SQL TCP mirroring endpoint. We can…
#PSTip Refresh the PSModulePath environment variable without re-opening console
A co-worker had asked me a question about why the SQLPS module was not available for importing immediately after an automated install of SQL using a PowerShell script. Within this…
#PSTip Provide CapsLock status in Read-Host prompt
In Windows, you get a message about the CapsLock status when logging on to Windows OS and with CapsLock on. You see this kind of experience in many other applications…

