#scriptcenter

[gsysadmin]

Windows Update PowerShell Module

Import-Module PSWindowsUpdatehttps://gallery.technet.microsoft.com/scriptcenter/2d191bcd-3308-4edd-9de2-88dff796b0bc

Set-ExecutionPolicy RemoteSigned

Import-Module PSWindowsUpdate

Get-WUList

Get-WUInstall

[rg443]

List expensive tsql queries (sys.dm_exec_query_stats)

List expensive queries [bs url=http://gallery.technet.microsoft.com/scriptcenter/List-expensive-queries-f6d63ac6] This Transact-SQL script returns the values from DMV sys.dm_exec_query_stats to rate SQL statements by their costs. These “costs” can be “Average CPU execution time “Average logical operations” or the total values of these measures

DECLARE @MinExecutions int; SET @MinExecutions = 5…