2016-03-18
PowerShell – Scripts Not Allowed To Run
If PowerShell is not allowing you to run scripts then you might need to set the...
2016-03-18
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 {...
2016-03-18
PowerShell – Fast Ping
Source: https://gist.github.com/mbrownnycnyc/9913361 This is a very fast way to ping a server using PowerShell. # with...
2016-03-18
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 “,...
2016-03-18
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...
2016-03-16
Fixing Orphaned Users On A Large Scale
A script that generates a script to fix all orphaned users at once.
2016-03-16
Recovering a database in RESTORING state
How to get your database out of the “restoring” state so you can use it again.
2016-03-11
Trump’s Strategy
The Donald Trump campaign has taken the world by storm. Not only has he upset the...
2016-02-28
Rubio Thinks Trump is a Two-Term President
Essentially, Rubio is saying that Trump is a two-term president. Listen to his own words:
2015-12-14
PHP Regular Expressions – Remove Comments From SQL Text
This short block of PHP code takes a SQL script and removes the “dash-dash” and “/**/”...