Tips and Tricks

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

#PSTip List all endpoints in a SQL deployment

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

Note: This tip requires PowerShell 2.0 or above. When working with SQL Server database mirroring, it is desired to understand how to create and troubleshoot database endpoints.

#PSTip Retrieving SQL database last backup dates using SMO

Ravikanth C
1 Min To Read
31 May, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. For regular reporting and auditing purposes, it is always desired to capture the SQL last backup dates.

#PSTip Getting SharePoint 2010 Health Analyzer alerts report by email

Shay Levy
2 Min To Read
30 May, 2013
- Tips and tricks
- Share point

SharePoint 2010 administrators are probably familiar with the following screenshot–you open the Central Administration page and you’re presented with a red Health Analyzer alert.

Showing items from Tips and Tricks