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…
LogParser Performance Inserting into SQL Server
Recently I’ve been using LogParser a lot to import log files, such as W3C logs from an IIS web server. The distasteful format of these files is made palatable […] Continue Reading…
SQL Relay Interview
A while back Richard Douglas interviewed me regarding my role as Chair of the SQL Relay 2013 conferences.
You can read the resulting interview here!
There’s only two weeks to go […] Continue Reading…
SQL Relay 2013
SQL Relay 2013 is only a month away!
If you’ve not signed up yet to SQL Relay 2013 then you’d better get in there quick, as 2 of the 8 […] Continue Reading…
MDX Between Start Date and End Date
How do you use MDX to find the number of items between two dates, when the start date and end date are different role playing dimensions?
I had an interesting […] Continue Reading…
Database Management PhD survey
If you’re involved in database management, can you spare 20 minutes to complete a survey?
Victoria Holt is studying for her PhD, and would very much appreciate it if you […] Continue Reading…
SSIS Expression Editor and Tester
I stumbled upon a gem of a tool this morning, written by Darren Green (blog | twitter) of SQLBits & Bids Helper fame; the SSIS Expression Editor and Tester.
Kudos […] Continue Reading…
Querying dimension members in MDX
Today we’re back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX?
This could be used for example to populate a […] Continue Reading…
The Frog Blog
I'm Alex Whittles.
I specialise in designing and implementing SQL Server business intelligence solutions,
and this is my blog! Just a collection of thoughts, techniques and ramblings on SQL Server, Cubes, Data Warehouses, MDX, DAX and whatever else comes to mind.
