July 19, 2007
Thought I’d share with you something strange I found while using named queries in the DSV layer in SQL Server Analysis Services.
I have developed quite a complex layer of connected tables in my DSV. As development had evolved (with the customers demand) I found myself turning 3 of my regular tables into named queries. The named queries were basically using the same table twice in an inner join to compare the state of the entity in two different times in the table. After this change, my process time for the cube and the dimensions grew from about...
July 15, 2007
About a week a go (I admit I'm only catching up to it now…) Microsoft released the SQL Server 2005 Best Practices Analyzer. The tool analyzes and monitors the SQL Server Profiler files. It uses a predefined list of recommendations to determine if there are potential issues in the database environment.
Now if you're like me, then after downloading and installing the tool, you can't help but think to yourself "yeah great, but how do I use it?..." Well all you need to do after that is run the SQL Server Profiler and run the program on the trace...
July 14, 2007
Well I admit I started writing this blog so I could be in touch with a larger community, but truth be told, I’m finding this blog has become a means for me to write stuff down somewhere so as not to forget them… J
Let’s face it, even at the age of 27 I have a hard time remembering everything. So what can I do? Notebooks with lists always seem to magically disappear or simply not be there just when you need them. Web pages, on the other hand, are always accessible – any place any time – and never...
July 7, 2007
Today I thought I'd tackle a subject even more complicated that SSAS Best Practices (yes, it's possible!), so today's topic is BI in the government (though you were probably quick enough to get that from the title..)
As you may have read in my first post, I work for the Tel Aviv Jaffa municipality. Panorama hosted an event not too long ago with a panel. It so happens that Avi Ketko, head of the whole computing service in the Tel Aviv municipality (which would translate into my boss's boss's boss J) said something in that panel which didn't...