Tips and Tricks

#PSTip Use Excel to View HTML Output

Josh Miller
1 Min To Read
17 Jun, 2013
- Tips and tricks

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 get with a simple Export-Csv

#PSTip Deleting a SQL mirroring endpoint with SMO and PowerShell

Ravikanth C
1 Min To Read
11 Jun, 2013
- SQL
- Tips and tricks

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 SQL mirroring endpoints.

#PSTip Creating a SQL TCP mirroring endpoint with SMO and PowerShell

Ravikanth C
2 Min To Read
10 Jun, 2013
- SQL
- Tips and tricks

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.

#PSTip Refresh the PSModulePath environment variable without re-opening console

Ravikanth C
1 Min To Read
06 Jun, 2013
- Tips and tricks

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.

#PSTip Provide CapsLock status in Read-Host prompt

Ravikanth C
1 Min To Read
05 Jun, 2013
- Tips and tricks

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 including web applications.

#PSTip Check if a SQL endpoint exists or not

Ravikanth C
1 Min To Read
04 Jun, 2013
- SQL
- Tips and tricks

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 name and/or port already exists.

Showing items from Tips and Tricks