Dynamic Data Masking with SQL 2016 and Dynamics GP 2016 – 3

When I started this topic I honestly didn’t think it would become a multiple part series, but alas here we are.  This post focuses on some questions that were asked by various users who’ve read the previous posts. Q. Can a user update data that has been masked? A. In the case of Dynamics GP…

Dynamic Data Masking with SQL 2016 and Dynamics GP 2016 – 2

Welcome back campers!  Todays post will guide you through implementing Dynamic Data Masking inside of Dynamics GP 2016 via Microsoft SQL 2016.  I again would like to iterate this is not an alternative to traditional data security.  DDM only modifies the display of the data in the result set of a query.  Lets have a…

Dynamic Data Masking with SQL 2016 and Dynamics GP 2016

This has been a big year for Microsoft.  We’ve seen the release of Microsoft SQL Server 2016 and the release of Microsoft Dynamics GP 2016.  These products come with a huge list of amazing improvements.  Today I want to talk about Dynamic Data Masking inside of SQL 2016 and GP 2016.  You  can find the…

Dynamics GP Integration Manager–Faster Integrations

In working with Microsoft Dynamics GP chances are you are going to need to import data into GP using the Dynamics GP Integration Manager or other methods using SSIS.  Now my second assumption is that during this process the import can take a bit of time, especially if you are importing large amounts of data…

Back at it!

These past 10+ months have been very crazy for my wife and I.  We moved into our 1st house, then just two weeks ago had our very first child.  So my time to get new blog post up has been almost none.  Now that Chris is here and we’ve got a routine started I’m going…

Exporting a smartlist in gp 2016

One of the new features in GP 2016 is the ability to export out a custom Smart List item you designed.  Below I’ll walk you through the quick and easy way to export the object so that you can import it at a later time. So I have modified the Employees smart list in GP. …

EMPLOYEE ARCHIVE UTILITY IN DYNAMICS GP 2016 PART 2

Welcome back campers!  This will be the conclusion to the previous post. So in the last post we had archived the Carrol because she was laid off, now business has picked back up and we need to get her back in GP.  Now normally you would have to enter the information again, but with the…

Dynamics GP SQL Error Codes Report

So as I wrote about in a pervious blog post in the Dynamics table there is a table that contains a list of SQL error codes.  There are 1043 of them to be exact.  So today I got around to creating an SRS report that you can type in the error code and search the…

Employee Archive Utility in Dynamics GP 2016 Part 1

In todays post we are going to look at using the Employee Archive utility inside of GP 2016.  This utility is really handy and will allow you to delete the inactive employee from GP thus eliminating scrolling through old employees. To locate the tool click on Microsoft Dynamics GP > Tools > Utilities > Human…

Sorting Data in Power BI Desktop–Sort By Column

One of the things I like about Power BI is the way I can sort my data.  Take the report below. In it we can see that I am showing revenue based on month, but you’ll notice quickly that my months do not show in the correct order.  They are shown alphabetically instead of Jan…

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 while I don’t use it all that often I thought it would be nice to bring it up. The image below is exactly what comes…

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 help you slice your data.  There are a couple of different methods to achieve this which we will cover in a 2 part blog series. …