#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 MoreShowing items from Tips and Tricks
#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#PSTip Reset your ISE runspace
Josh Miller- 2 Min To Read
- 05 Aug, 2013
Note: This tip requires PowerShell 2.0 or above. I have scripts that work with multiple versions of the same third-party .
Read More#PSTip Drop all Active Connections of SQL Database
-
Ravikanth C
- 1 Min To Read
- 02 Aug, 2013
Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how we can retrieve the active connection count for a SQL database.
Read More#PSTip Get Active Database Connections of a SQL Database
-
Ravikanth C
- 1 Min To Read
- 01 Aug, 2013
Note: This tip requires PowerShell 2.0 or above. As a part of SQL SMO automation, when we want to detach or delete databases, we might want to first drop all active database connections.
Read More