Category Archives: Technology

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.

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.

Your Cell Phone Is A Document Scanner

CamScanner is a free Android app that takes photos of documents, automatically crops the photo, enhances the photo, saves it, categorizes it, tags it, converts it to PDF, and uploads it to your cloud. And CamScanner does it well. The quality is as good as (or better than) a normal scanner. Here is a sample… Read More »

U.S. judge allows lawsuit against Google over email ads

SAN FRANCISCO (Reuters) – A federal judge on Thursday refused to dismiss most of a lawsuit against Google Inc over allegations the company improperly scanned the content of customers’ emails in order to place ads. U.S. District Judge Lucy Koh in San Jose, California ruled that the proposed class action lawsuit against Google can proceed.… Read More »

SQL Server – Rolling Back Dynamic SQL

Do transactions apply in dynamic SQL, in SQL Server? In a word, yes. For proof, run the following chunks of code: