PowerShell – Fast Ping Writer #1, 2016-03-18 Source: https://gist.github.com/mbrownnycnyc/9913361 This is a very fast way to ping a server using PowerShell. #… Continue Reading
PowerShell – Get SQL Server Info Writer #1, 2016-03-18 $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… Continue Reading
PowerShell – Replace All Instances Of Something In All Files In Directory Writer #1, 2016-03-18 This script searches every file in a directory for a particular string and replaces it… Continue Reading
Fixing Orphaned Users On A Large Scale Writer #1, 2016-03-16 A script that generates a script to fix all orphaned users at once. Continue Reading
Recovering a database in RESTORING state Writer #1, 2016-03-16 How to get your database out of the “restoring” state so you can use it again. Continue Reading
PHP Regular Expressions – Remove Comments From SQL Text Writer #1, 2015-12-142024-08-31 This short block of PHP code takes a SQL script and removes the “dash-dash” and… Continue Reading
Powershell – Finding the most recent backup file in a parent directory Writer #1, 2015-12-01 Having to sift through a large directory to get the latest file can be tedious. … Continue Reading
SQL Server – Rolling Back Dynamic SQL Writer #1, 2013-06-18 Do transactions apply in dynamic SQL, in SQL Server? In a word, yes. For proof,… Continue Reading
PHP Date Difference Writer #1, 2013-06-04 Finding a quick PHP function for date difference was painful. Now that I found it,… Continue Reading
PHP Date Difference Writer #1, 2013-06-042024-08-31 Finding a quick PHP function for date difference was painful. Now that I found it,… Continue Reading