Analysis Services Query Performance Top 10 Best Practices
I came across this little gem which I haven’t noticed so far. A nice summary of the 10 things you should do to optimize the UDM query performance. The best […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Protect UDM with Dimension Data Security
SQL Magazine published the first part of my article Protect UDM with Dimension Data Security in its July issue. This article explains the fundamentals of dimension data security. I am […]
Trust Relationships
If you use VS.NET deployment to deploy your SSAS project from one domain to another, you may get the following obscure error message on deploy. The trust relationship between the […]
Aggregate Rows and SP2
Back to my When (null) is not Null post, there is a undocumented breaking change in SQL Server 2005 SP2 which you should be aware of. In response to the […]
TechEd 2007 US Memoirs
I am back from an one-week vacation to Clearwater, Florida followed by TechEd 2007 US in Orlando. Overall, nothing earth – shattering on the BI arena from TechEd 2007. Product […]
A Couple of Report Builder – UDM Hacks
If you target the SSRS Report Builder as an UDM client you may find the following two workarounds (aka hacks) useful. Both hacks require manually updating the SMDL definition. Alas, […]
Companion for MS Analysis Server
SQL Minds has released Companion for MS Analysis Server. Companion for MS Analysis Server is a product that helps with the health monitoring and performance tuning of Microsoft SSAS 2005. […]
Not All Hyperlinks are Born Equal
The ASP.NET ReportViewer control has a HyperlinkTarget property which may give false expectations. You may believe that this property applies to all hyperlinks, including links to drillthrough reports. For example, […]
SQL Server 2005 SP2 Brings Self-upgrading Catalogs
A little known but very useful SSRS feature which debuted in SQL Server 2005 SP2 is that the SSRS Windows service automatically upgrades the report catalog (ReportServer database) if required. […]
My TechEd Session Scheduled
My breakout TechEd session BIN305 – Applied Microsoft SQL Server 2005 Reporting Services is scheduled for June 4 at 10:30 AM – 11:45 AM in room S320 A. That’s right […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
