Tag Archives: sql

Send Windows Event Logs to SQL Database

I’m currently in the process of planning for an AppLocker rollout to all my PCs (about 7,500 of them) due to an increasing amount of malware. You should probably be doing this too. Anyway, a sensible first step is to … Continue reading

Rate this:

Posted in PowerShell, Scripting, Security, Windows | Tagged , , , , , , , , , , , , , , , , , , , , , , , | 4 Comments

RDSH 2012 R2: Shadow Users without Connection Broker admin rights

It seems as though the only way to use the PowerShell Get-RDUserSession cmdlet against the Connection Broker is if the user running the command is a member of the¬†¬†Administrators group on the Connection Broker server. This might be undesirable…! This … Continue reading

Rate this:

Posted in Remote Desktop, Windows | Tagged , , , , , , , , , , , , , | 2 Comments

Missing row when using ExecuteReader to fill a DataTable

I’ve been using the following PowerShell code to retrieve the contents of an SQL Server table and store it in a DataTable for fast local processing: $BuildDBConnection = New-Object -TypeName System.Data.SqlClient.SqlConnection -ArgumentList “Server=RCMSQL01;Database=TSBuild;Integrated Security=SSPI” $BuildDBConnection.Open() # Get Main table $SQLCommand … Continue reading

Rate this:

Posted in PowerShell, Scripting | Tagged , , , , , , , , | Leave a comment

PowerShell: There are null values and then there are SQL null values

I was reading some data out of a SQL Server table, and wanted to do an operation if one of the string values returned, MAC, was either blank or null. I was using the following code: $NewServerName = “SomeServerName” $DBServerName … Continue reading

Rate this:

Posted in PowerShell, Scripting | Tagged , , , , , , , | Leave a comment

Symantec NetBackup SQL agent issues

Finally managed to get this working today after much struggling (and trying not to have to wade through the 200-odd pages of not-easy-to-read NetBackup for SQL Server Administrator’s guide). So, I installed the NetBackup client, patched to version 7.1.0.4 and … Continue reading

Rate this:

Posted in NetBackup | Tagged , , , , , , | 1 Comment

vSphere client: Performance overview not working

Various things seem to cause this to fail. The error reported within the Performance Overview pane of vSphere client is: Perf Charts service experienced an internal error Report application initialization is not completed successfully. Retry in 60 seconds. In my … Continue reading

Rate this:

Posted in vSphere | Tagged , , , , , , | Leave a comment