I found a short but very useful MDX Performance article on sqlserveranalysisservices.com. I know I am guilty of breaking not once the first rule (Don’t Filter on Member Property Values). Maintained by Richard Tkachuk (Lead Program Manager on the SSAS team), this site offers other interesting tips and insights.
Read articleChris Webb, whose latest book “MDX Solutions” is a must-read for everyone who’s serious about Analysis Services 2005 and MDX, has written a review for my book “Applied Microsoft Analysis Services 2005”. Thank you, Chris!
Read articleMicrosoft has released a post-SP1 hotfix which addresses various bugs and issues in SQL Server 2005 and its add-on services.
Read articleDevX published my article "Create Reports from Any Data Source Using SQL Server Reporting Services Custom Data Extensions". Learn how to develop a custom data extension to bind server reports to ADO.NET datasets.
Read articleOne of the most exciting (but not well known and documented) extensibility areas of SSRS 2005 is custom report items (CRI). As its name suggests, custom report items allow you to implement your own reporting controls when the standard SSRS report items (textbox, chart, table, matrix, etc.) are not enough. For example, the attached screenshot shows a report that uses a CRI I wrote to…
Read articleDownload the April 2006 refresh of the SQL Server 2005 samples and databases.
Read articleSQL Server 2005 SP1 was released yesterday. Kudos to Microsoft for releasing SP1 on time! As the conventional wisdom goes, one should postpone deployment of production applications until the first service pack has been released. Well, that time has come to pass. May your SQL Server 2005-based solutions be successful!
Read articleMicrosoft is planning to ship the SP1 version of SQL Server 2005 by the end of the month, according to an April 6 letter that Microsoft senior vice president Paul Flessner, wrote to customers. In the same letter, Paul Flessner announces a new SQL Server Edition, the SQL Server Evywhere Edition, that will be used for occasionally connected applications.
Read articleIt looks like the OLAP browser I've been dreaming about may not that be that far away. I hope that ProClarity will make make their browser more modular so it can be embedded in Windows Forms and web applications. Here is another interesting link about the acquisition.
Read articleBob Meyers (the mastermind behind the RS 2005 Report Builder) tells us how to implement horizontal data filtering in the Report Builder model – a topic which is not covered by the product documentation. I highly recommend Bob’s blog.for more Report Builder insights.
Read article
