Tips and Tricks

#PSTip List all Active Directory constructed attributes

Shay Levy
2 Min To Read
25 Apr, 2013
- Active directory
- Tips and tricks

Active Directory has a special kind of attributes called Constructed attributes. Constructed attributes are not “real” attributes, they are not stored in the directory.

#PSTip Enumerate all SQL Server instances in a network

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

Note: This tip requires PowerShell 2.0 or above. Ever thought about how you can list of all SQL Server instances on the local network?

#PSTip Get the AD site name of a computer

Shay Levy
1 Min To Read
23 Apr, 2013
- Active directory
- Tips and tricks

There are a few ways to get the site a computer is a member of. In .NET we can use the ActiveDirectorySite class.

#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.

Showing items from Tips and Tricks