#PSTip Finding all databases to which a login is mapped
Hemanth C Damecharla- 1 Min To Read
- 19 Aug, 2013
Note: This tip requires PowerShell 2.0 or above. One of the projects on which I work requires a validation step after each deployment.
Read MoreShowing items from Tips and Tricks
#PSTip Get the fully qualified path of the system directory
Shay Levy- 1 Min To Read
- 16 Aug, 2013
There 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#PSTip Validate if a user exists in Active Directory
Ravikanth C- 1 Min To Read
- 15 Aug, 2013
Note: 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#PSTip Validate if a SQL login exists using PowerShell
-
Ravikanth C
- 1 Min To Read
- 14 Aug, 2013
Note: 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#PSTip Add a SQL login to database roles using SMO
-
Ravikanth C
- 1 Min To Read
- 13 Aug, 2013
Note: This tip requires PowerShell 2.0 or above. We can use SQL Server SMO object to add a SQL login to the database roles.
Read More#PSTip Initializing multiple variables at once
-
Shay Levy
- 1 Min To Read
- 09 Aug, 2013
Here’s another cool variables tip. Say you want to initialize a few variables to a specific value. Instead of doing:
Read More