Tips and Tricks

#PSTip Enhancements to implicit remoting in PowerShell 3.0

Jan Egil Ring
2 Min To Read
22 Mar, 2013
- Tips and tricks

Note: This tip requires PowerShell 3.0 or above. Since PowerShell 2.0 we could use implicit remoting to import cmdlets from a remote PowerShell session into the local PowerShell session:

#PSTip Working with Excel constants

Shay Levy
2 Min To Read
20 Mar, 2013
- Tips and tricks

When automating Microsoft Excel, almost every time you’ll need to include some constant values to define the behaviour of the code.

#PSTip Generate T-SQL script for cloning a SQL database

Ravikanth C
1 Min To Read
19 Mar, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. As database administrator, you may want to create a database on development or test servers with similar settings as on the production server.

#PSTip Get a list of geographical locations

Shay Levy
2 Min To Read
18 Mar, 2013
- Tips and tricks

Note: This tip requires PowerShell 3.0 or above. In a previous tip I wrote about the International module. One of the commands of the module, Get-WinHomeLocation, returns a GeoID object which represents the home location (Country and Region) of the …

#PSTip Getting Enum values in PowerShell 3.0

Shay Levy
1 Min To Read
15 Mar, 2013
- Tips and tricks

Note: This tip requires PowerShell 3.0 or above. Prior to PowerShell 3.0, to return a list of names or values of an Enumeration object, we needed to use the static methods of the System.

#PSTip Change SQL Server default backup folder location

Ravikanth C
1 Min To Read
14 Mar, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. If you have ever backed up a SQL Server database, you will know that the default backup location is set to the Program Files folder where SQL is installed.

Showing items from Tips and Tricks