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…
The Frog Blog
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Reiss McSporran |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Joe Billingham |  |
