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 …
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 …
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 …
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 …
So I have started working on getting more involved in the database development side of things with emphasis on slow queries that shouldn’t be. It’s important to note that I’m …
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 …
In 2015 one of my goals was to network more with the SQL community both locally at my local users group but also branch out a bit to some events …
One of the most amazing aspects for my management team is their ability to leverage a lot of the built-in reporting tools that come packaged with Microsoft Dynamics GP. The …
So one of the things I am working on is creating a shell database of an existing LOB database we have in production. To accomplish this I need to erase …
That is a mouthful to say the lease. So one of the projects I’m working on is migrating our Dynamics GP 2010 database off the existing SQL 2008 R2 server …