Tips and Tricks

#PSTip Change SQL Server MaxServerMemory configuration using SMO

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

Note: This tip requires PowerShell 2.0 or above. As database administrators, we might want to configure SQL MaxServerMemory setting to ensure the SQL service does not occupy all available physical memory.

#PSTip View Policy Settings with RSOP WMI classes

Shay Levy
2 Min To Read
02 Apr, 2013
- Tips and tricks
- Wmi

Note: This tip requires admin privileges (elevated shell) To get Resultant Set of Policy (RSOP) data we usually RSOP.mmc or the gpresult command line tool.

#PSTip Detecting if a certain process is elevated

Stefan Stranger
2 Min To Read
29 Mar, 2013
- Tips and tricks

Note: This tip requires PowerShell 3.0 There was a question recently in the PowerShell MVP mailing list about how to detect if a certain process is elevated.

#PSTip Identifying SQL system objects using SMO

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

Note: This tip requires PowerShell 2.0 or above. A SQL Server instance, by default, deploys a few system databases such as Temp DB, MSDB, Master, and Model DB.

#PSTip Generate T-SQL script to clone database tables using SMO

Ravikanth C
1 Min To Read
27 Mar, 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 SMO in PowerShell to generate T-SQL scripts for cloning databases.

#PSTip Fixing the output of ConvertTo-Html

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

When you export PowerShell objects to HTML, using the ConvertTo-Html cmdlet, and HTML links are present as the values of the object, ConvertTo-Html doesn’t render them as HTML links.

Showing items from Tips and Tricks