Author Archives: Writer #1

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.

Google’s New Free Mason Logo

I couldn’t help but notice the stunning similarity between Google’s new maps logo and the Free Mason’s logo. It doesn’t take too much imagination to see this one.

Walk By Faith, Not By Sight

One man walks by faith and another walks by sight. The first man is spiritual and the second is scientific. Both are walking in a legitimate way; neither is wrong. One, however, is creating and changing his world while the other is reacting and being changed by his world.