BIML – What is it?
I’ve noticed a growing trend over the last year – the ever growing presence of BIML (Business Intelligence Markup Language). So what is it? What does it do? And […] Continue Reading…
Why you should start presenting at conferences
Have you presented a session at a user group or a conference? No? then read on to find out why you need to change that.
Many of the readers of […] Continue Reading…
SSAS Tabular String Imported as Integer
Let me start by saying that I think the SSAS Tabular model is great. But…. there are a number of problems that Microsoft still need to get ironed out.
Not […] Continue Reading…
Excel doesn’t open CSV files correctly from sp_send_dbmail
A nice little nugget today for anyone who uses SQL dbmail to send data in csv attachments.
Sometimes, depending on your language settings, CSV files don’t open correctly in Excel. […] Continue Reading…
Analysis Services Tabular or Multidimensional? A performance comparison
Can SSAS Multidimensional be faster than SSAS Tabular for distinct counts on large datasets?
We’ve all seen how fast the SSAS Tabular model can work – it’s an in-memory, heavily […] Continue Reading…
SSAS Tabular performance – NUMA update
How does the SSAS 2012 Tabular model performance change when you add more CPU sockets / NUMA nodes?
In my last post (SSAS Tabular NUMA and CPU Cores Performance) I […] Continue Reading…
Renaming an SSAS Tabular Model
I came across a frustrating problem today. I’d just finished processing a large tabular cube (SQL Server 2012), which had taken 11 hours in total.
On trying to connect to […] Continue Reading…
SSAS Tabular – NUMA and CPU Cores Performance
[UPDATE] After further investigation, I found that the tests in this post were inacurate and the results unreliable. Updated NUMA test results here
In my last post (SSAS Tabular Performance […] Continue Reading…
SSAS Tabular performance – DefaultSegmentRowCount
I’m currently investigating a poorly performing Tabular model, and came across some interesting test results which seem to contradict the advice in Microsoft’s Performance Tuning of Tabular Models white […] Continue Reading…
Dimension ProcessAdd in SSAS
When you have very large dimensions in SQL Server Analysis Services (SSAS) cubes, the time taken to process them can cause a problem. This post builds upon an excellent […] 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 |  |
