benjf.com – Page 35 – Real content from a human brain

PowerShell – Get All SQL Server Instances In Environment

cls import-module failoverclusters Import-Module -Name SQLPS -DisableNameChecking $servers = “comma”,”separated”,”server”,”list” foreach($server in $servers) { try { $virtual_name = $server; $instances = ”; try{ $virtual_name = ((get-clusterresource -Cluster $server -ErrorAction SilentlyContinue -WarningAction SilentlyContinue | get-clusterparameter VirtualServerName -ErrorAction SilentlyContinue -WarningAction SilentlyContinue | Select Value -ErrorAction SilentlyContinue -WarningAction SilentlyContinue)[0].Value ) } catch{} $server = $virtual_name; $path = “SQLServer:\SQL\”… Read More »

PowerShell – Fast Ping

Source: https://gist.github.com/mbrownnycnyc/9913361 This is a very fast way to ping a server using PowerShell. # with reference to http://theadminguy.com/2009/04/30/portscan-with-powershell/ 2 function fastping{ 3 [CmdletBinding()] 4 param( 5 [String]$computername = “127.0.0.1”, 6 [int]$delay = 100 7 ) 8 9 $ping = new-object System.Net.NetworkInformation.Ping 10 # see http://msdn.microsoft.com/en-us/library/system.net.networkinformation.ipstatus%28v=vs.110%29.aspx 11 try { 12 if ($ping.send($computername,$delay).status -ne “Success”) {… Read More »

PowerShell – Get SQL Server Info

$assemblylist = “Microsoft.SqlServer.Management.Common”, “Microsoft.SqlServer.Smo”, “Microsoft.SqlServer.Dmf “, “Microsoft.SqlServer.Instapi “, “Microsoft.SqlServer.SqlWmiManagement “, “Microsoft.SqlServer.ConnectionInfo “, “Microsoft.SqlServer.SmoExtended “, “Microsoft.SqlServer.SqlTDiagM “, “Microsoft.SqlServer.SString “, “Microsoft.SqlServer.Management.RegisteredServers “, “Microsoft.SqlServer.Management.Sdk.Sfc “, “Microsoft.SqlServer.SqlEnum “, “Microsoft.SqlServer.RegSvrEnum “, “Microsoft.SqlServer.WmiEnum “, “Microsoft.SqlServer.ServiceBrokerEnum “, “Microsoft.SqlServer.ConnectionInfoExtended “, “Microsoft.SqlServer.Management.Collector “, “Microsoft.SqlServer.Management.CollectorEnum”, “Microsoft.SqlServer.Management.Dac”, “Microsoft.SqlServer.Management.DacEnum”, “Microsoft.SqlServer.Management.Utility” foreach ($asm in $assemblylist) { $asm = [Reflection.Assembly]::LoadWithPartialName($asm) } $computers = Get-Content -Path C:\scripts\servers.txt #… Read More »

PowerShell – Replace All Instances Of Something In All Files In Directory

This script searches every file in a directory for a particular string and replaces it with another value. get-childItem | ForEach { (Get-Content $_ | ForEach {$_ -replace “OLDVALUE,”NEWVALUE”}) | Set-Content $_}

Fixing Orphaned Users On A Large Scale

A script that generates a script to fix all orphaned users at once.

Recovering a database in RESTORING state

How to get your database out of the “restoring” state so you can use it again.

Trump’s Strategy

The Donald Trump campaign has taken the world by storm. Not only has he upset the apple cart in the United States, but he has managed to piss off people in the U.S. and political leaders abroad. Could anyone in the U.S. imagine watching a foreign nation’s election process and lashing out at one of… Read More »

Rubio Thinks Trump is a Two-Term President

Essentially, Rubio is saying that Trump is a two-term president. Listen to his own words:

PHP Regular Expressions – Remove Comments From SQL Text

This short block of PHP code takes a SQL script and removes the “dash-dash” and “/**/” comments from it. Of course, many languages, including PHP itself, use the “/**/” comment style so this could apply to PHP scripts, as well. The line that removes the dash-dash style comments could easily be changed to the “//”… Read More »

Powershell – Finding the most recent backup file in a parent directory

Having to sift through a large directory to get the latest file can be tedious. Surprisingly, I’ve needed this twice in the past month, so I figured I should post it. I hope this helps someone.