Powershell: Set Execution Policy to Unrestricted

by | Jun 21, 2014 | PowerShell

Out of the box, Powershell execution is restricted to “RemoteSigned,” which means downloaded scripts must be signed by a trusted publisher before they can be run. In order to allow all scripts to run, you need to set the execution policy to unrestricted....

Activate Windows 8.x From a Command Line

by | Jun 16, 2014 | SQL

The standard way to activate Windows 8.x is to go to Control Panel / System and Security / System, then activate windows with your product key.  Sometimes this can fail.  If it does, you can activate from a command line.   Run cmd as an administrator, then...

SQL Workaround for Using Like in an In Statement

by | Jun 5, 2014 | SQL

The like function is quite handy to use in SQL; however, it cannot be used in an “in” statement.  The “in” statement is effectively using “OR =”, and there is no equivalent that uses and “OR LIKE”. For example, lets say...

SQL Time data type add time limit

by | May 30, 2014 | SQL

The SQL TIME data type is handy for adding times to other times.  It does; however, have a limitation in that the highest time it will store is 23:59:59.9999999. This is great if you are adding dates and times simultaneously as the date will increase when you hit 24...