CHOOSE
So in my blog post today I’m going to talk about the CHOOSE function inside of Microsoft SQL Server. This function was introduced with the release of SQL 2012 and …
Extracting Date Information in Microsoft Power BI–Part 1
In this post I’ll guide you through a couple of different methods for extracting date data from your data into Microsoft Power BI so that it can be used to …
Deploying the GP 2015 Analysis Cubes
I finally got around to testing the install of the GP 2015 Analysis cubes with SQL 2014. This process is exactly the same as deploying on GP 2013 R2 and …
Adding Indicators to a Report in SSRS
I’m working on building some sample reports using the test company inside of Dynamics GP 2015 and one of the things I wanted to do on some of my reports …
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 …
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 …
Dynamics GP Error Table
By a show of hands how many of you all realized that Dynamics has a table in the system database that stores a list of error codes and their associated …
Dynamics GP 2013 R2–Slipstreaming
So I’m siting for exam MB3-700 on April 6th and that means I need to setup a lab environment to go over my training to make sure I’m ready for …
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 …