List/Grid Columns Subscribe RSS feed of category Columns
#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…
#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…
#PSTip Check if a SQL endpoint exists or not
Note: This tip requires PowerShell 2.0 or above. Before we make an attempt at creating a new database mirroring endpoint, we need to verify if an endpoint with the given…
