Development

Creating an Excel Pivot Table Using PowerShell

Posted on

Doug Finke has a new post about a PowerShell script he wrote to create an Excel Pivot Table. Out-ExcelPivotTable inspects the piped data, sets up the numeric properties as data fields and string properties as row fields (nested). Doug includes screenshot of the output, in case you are unfamiliar with Pivot Tables. The actual script […]

Information Technology

PowerShell and SQL Server

Posted on

Customers are always asking about using PowerShell to interact with their SQL servers.  One great source I’ve started following is Max Trinidad.  He has a very good grasp of both PowerShell and SQL Server administration.  Max has also contributed to codeplex with the SQLDevTools Module.  He wrote a blog postthat discusses some of the features. […]

Information Technology

Enabling and Disabling Hyper-Threading via PowerCLI

Posted on

I found an interesting discussion on the VMware Communities about managing hyper-threading settings via PowerCLI.  The discussion has a couple of useful scripts.  To find out if hyper-threading is enabled use this script: Get-Host | Select-Object Name,HyperthreadingActive To disable hyper-threading, use the connect-VIserver to connect directly to the host and use this script: ## host […]