Hemanth C DamecharlaNote: This tip requires PowerShell 2.0 or above. Sometimes we need to know if a particular DB is available on a given instance before going ahead and making any configuration changes.
Read More
Hemanth C DamecharlaNote: This tip requires PowerShell 2.0 or above. In a previous tip, we checked out how to get the names of all databases to which a login is mapped and the username for that login in each database.
Read More
Hemanth C DamecharlaNote: This tip requires PowerShell 2.0 or above. One of the projects on which I work requires a validation step after each deployment.
Read More
Shay LevyThere are many ways to get the path of the system directory (e.g system32). Here’ one that I find very useful that involves the .
Read More
Ravikanth CNote: This tip requires PowerShell 3.0 or above. [adsisearcher] is a PowerShell type adapter for DirectorySearcher .NET class. We can use this type adapter to perform queries against Active Directory Domain Services.
Read More
Ravikanth CNote: This tip requires PowerShell 3.0 or above. Before performing tasks like adding roles to a SQL login, it is desired to validate the existence of SQL login.
Read More