SQL 101–Table Alias

Welcome to the first in my randomly ordered SQL 101 series.  This main goal of this series to is provide an entry level guide to some of the basics in …

EXEC SP_HELP TABLES!

So quick update for the moment.  I’ve recently been trying to dissect a database that has a lot of tables to revamp some queries.  The thing I found my self …

Fun Facts!

Turns out that Microsoft Dynamics GP 2015 does not support Microsoft SQL 2016 CTP 3.3.  It appears to be something with the ODBC connections that it doesn’t like.  The message …

Dynamics GP Security Script

So if you work with Dynamics GP in any form of administrative role you understand the cost associated with a user license for your company.  So what I like to …