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 …
Execution Plan Arrows
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 …
Got Jobs?
I love when I get to demonstrate things I’ve written in the past for you the readers and myself. I often use my blog as a reference point because I’m …
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 …
OMG!!! I Might Be Speaking
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 …
Deploying the GP 2013 R2 Analysis Cubes
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 …
Truncate a table in SQL
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 …
Error Creating Company in Dynamics GP – Violation of Primary Key Constraint PKSY60100
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 …