Tips and Tricks

#PSTip How to start an elevated PowerShell from Windows Explorer

Aleksandar Nikolic
1 Min To Read
25 Jun, 2013
- Tips and tricks

Note: This tip requires PowerShell 2.0 or above. The next time you are working in a folder and need to open a Windows PowerShell console directly to that location, it would be nice to have ‘Open Windows PowerShell Here as Administrator’ option on a …

#PSTip Change database recovery model using SMO

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

Note: This tip requires PowerShell 2.0 or above. Database mirroring requires that the database be in Full recovery model as a prerequisite to configure mirroring.

#PSTip Deleting expired certificates from the personal certificate store

Josh Miller
2 Min To Read
19 Jun, 2013
- Tips and tricks

We use a lot of certificates for website authentication, and they expire each year. Some people end up with a collection of expired certificates.

#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.

Showing items from Tips and Tricks