Tips and Tricks

#PSTip Changing SQL database AutoShrink property using SMO and PowerShell

Ravikanth C
1 Min To Read
22 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In today’s tip, we will see how we can use SQL SMO and PowerShell to change the AutoShrink property of a SQL database.

#PSTip PowerShell command-line switch shortcuts

Shay Levy
1 Min To Read
19 Apr, 2013
- Tips and tricks

Note: This tip requires PowerShell 2.0 or above. Windows PowerShell allows you to create short names for commands using Aliases. It even allows you to specify short parameter names.

#PSTip Restoring a SQL Database using SMO

Ravikanth C
1 Min To Read
18 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In a couple of earlier tips on using SMO, we looked at backing up a SQL database and transaction logs.

#PSTip Count the number of mailboxes per department

Shay Levy
2 Min To Read
17 Apr, 2013
- Exchange
- Tips and tricks

Yesterday I got an email asking for help to create a report of all user mailboxes in Exchange per department. When you execute a Get-Mailbox command, you’ll see that the Department property is not included in the result.

#PSTip Backing up SQL transaction log using SMO

Ravikanth C
1 Min To Read
16 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how we can use SQL SMO to perform database backup.

#PSTip Managing Remote Sessions

Chad Miller
2 Min To Read
15 Apr, 2013
- Tips and tricks

Note: This tip requires Windows PowerShell 2.0 or above. The Get-WSManInstance cmdlet can be used to view the sessions that are connected to a remote computer.

Showing items from Tips and Tricks