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…
Rock Paper Scissors Lizard Spock
I want to share with you some genius level work by Phil Quinn (blog | twitter), who is furthering the boundaries of […] Continue Reading…
Find first order date in MDX
I had an interesting question the other day; “how do I find the date of the first order/activity for a given customer/employee/product etc in MDX”?
Well you’ll be pleased to […] 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.
