Over the past 7 or 8 years, I’ve gone from “0 to 60” when it comes to database design, development, ETL and BI. Most of the skills I’ve learned were a result of mistakes I’ve made, and I’ve been mostly…
Now that I’m doing some more development of dashboards in the Power View interface, I thought it might be helpful to post about some of the date “gotchas” I’ve run in to with the development interface. Power View is very…
I was attempting to create a database diagram with the SSMS 2012 diagramming tool today and ran into the following issue: “Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)” with…
While rehearsing my demo for my upcoming session at SQL Saturday Boston this weekend, #sqlsat500 where I will be lecturing and demonstrating Scratching the Surface of Power View, I noticed a quirky issue where I wasn’t able to drill through…
Have you run in to issues where your SSRS column headers just won’t scroll with the data? How about losing the column headers when you go to your next page? Well, there seems to be some ambiguity about this topic,…
Recently I came across a challenging issue with calculating a time span within a group inside an SSRS Report. I am working on an issue where I need to be able to calculate labor pace operations per hour, and the…
A little while back, the boys from Pragmatic Works (www.pragmaticworks.com) came up to Boston for their “Master” level training series on SSRS. I attended the class, and wanted to share my experience so other interested people can get a preview…
I just recently presented at my first SQL Saturday event, SQL Saturday#334 – The Boston BI Session, and wanted to share my experience for future first-timers in the hopes it might help them with their presentations. Special thanks to Mike…
Recently ran into trouble because our Active Directory environment was upgraded to 2012, and I could no longer deploy packages to our SQL Server 2014 SSIS Catalog due to the following error: A .NET Framework error occurred during execution of…
Just recently I came across some odd behavior when trying to connect to my SQL 2012 server via and SSIS package and ultimately SSMS from an external connection. I’ll cut to the chase and tell you that the error I…