Jacki Moody | Tech Tips

SQL Workaround for Using Like in an In Statement

by Jacki Moody | 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 Jacki Moody | 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...

Install 3.5 .Net Framework on Windows 8.1

by Jacki Moody | May 5, 2014 | Windows

Windows 8.1 comes with Windows 4.5 .Net framework, but not 3.5 .Net framework. In order to install it, you go to Control Panel / Programs / Uninstall a program / Turn Windows features on or off The top option will be .NET Framework 3.5 (includes .NET 2.0 and 3.0)...

Powershell Copy Active Directory Group Membership

by Jacki Moody | May 2, 2014 | Active Directory, PowerShell

Recently I had a request to copy group membership from multiple groups into one single group. This was because the application they were using did not support group nesting, it would only support granting permissions to a single Active Directory group. I came up with...

Get Lync Online 2013 Policies Via PowerShell

by Jacki Moody | Apr 21, 2014 | PowerShell

Lync Online 2013 lets you grant policies to individual users. You cannot add your own policies, change the existing ones, or update the global policy. You can view the polices that exist and choose one of them to apply to users. As of today, there are three policies...