Earlier today I came up when executing a SSIS package on a workstation that recently had SQL Server Data Tools for Visual studio 2012 installed. It says, “Method not found: ‘Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils.IsVisualStudio2012ProInstalled()’.       I found a fix for this solution here. The steps are as follows: Open the Developer Read more

    Earlier this week I encountered a new Power Query error when I attempted to update a Power Query that I had previously created to load a Power Pivot model. Unfortunately, when queries are changed after a Power Pivot model is created, the underlying metadata does not automatically refresh. Read more

About every month or so a new group of students tour the Pragmatic Works office. They’re a part of the Pragmatic Works foundation, a non profit organization created to help unemployed, underemployed, and returning veterans gain the skills needed to gain access into the IT industry as database developers. I Read more