System OutOfMemoryException when deploying SSIS .ispac
If you’ve tried deploying a .ispac using the Integration Services Deployment Wizard, you may have come across the following error:
By default SQL Server uses the 32-bit version of the […] Continue Reading…
Creating Power BI Layouts using PowerPoint
First question, why bother with layouts?Using layouts in Power BI allows a user to make their visuals stand out better, the page looks professional and more appealing to its […] Continue Reading…
Capturing Insert and Update Counts from Merge
This post shows hows how you can capture and store the number of records inserted, updated or deleted from a T-SQL Merge statement.
This is in response to a question […] Continue Reading…
Power BI Sentinel
We all know and love Power BI, because of it’s power and ease of use, there’s a good reason why it’s number 1 in the Gartner Quadrant. But how […] Continue Reading…
SSAS Tabular Deployment Wizard fails Newtonsoft.Json error
The Scenario
Deploying an Analysis Services Tabular model to SSAS Azure using the Analysis Services Deployment Wizard. Both Visual Studio 2017 & SQL Server 2017 installed on the client.
Try and […] Continue Reading…
Lookups and If Conditions in Azure Data Factory v2 (ADFv2)
Azure Data Factory v2 (ADFv2) has some significant improvements over v1, and we now consider ADF as a viable platform for most of our cloud based projects. But things […] Continue Reading…
Sampling data in Data Lake U-SQL for Power BI
Being able to hook Power BI directly into Azure Data Lake Storage (ADLS) is a very powerful tool (and it will be even more so when you can link […] Continue Reading…
Showing December to December to see opening values for a year in SSAS/MDX
I came across an interesting MDX challenge this week; within a cube’s Date dimension, how to show December twice, once where it should be and again as the opening […] Continue Reading…
SQL Server 2016 Licensing Changes, SP1, v.Next CTP1, etc.
By now you’ve probably heard the exciting news announced at today’s Microsoft Connect conference; SQL Server licensing is changing, significantly, from SQL 2016 SP1.
The functionality of SQL Server Standard, […] Continue Reading…
What is U-SQL?
By now you may have heard about U-SQL, the new kid on the query language block. But what is U-SQL? Where is it? What’s it for?
I was lucky enough […] Continue Reading…