#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 MoreShowing items from Tips and Tricks
#PSTip Identifying DSC commands
Shay Levy- 1 Min To Read
- 12 Aug, 2013
Note: This tip requires PowerShell 4.0 or above. Starting in Windows PowerShell 4.0 with the new Desired State Configuration (DSC) feature, we now have one more command type added to the list of command types: Configuration.
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#PSTip Multiple variable assignments
-
Shay Levy
- 1 Min To Read
- 08 Aug, 2013
In the previous tip I showed how we can use multiple assignments to swap the value of two or more variable values.
Read More#PSTip Swapping the value of two variables
-
Shay Levy
- 1 Min To Read
- 07 Aug, 2013
In most programming languages the conventional way to swap the value of two variable is to use a third variable.
Read More#PSTip Retrieve all SQL instance names on local and remote computers
-
Ravikanth C
- 1 Min To Read
- 06 Aug, 2013
I was looking at way to retrieve the SQL instance names on a remote computer without using SQL SMO. This is essential for me as I don’t always expect to have the SQL SMO DLLs on the computer where I run my scripts.
Read More