PROLOGIKA BLOG · IDEAS FROM THE FIELD
Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.
Explore the latest articlesNow that I've read the Analysis Services Performance Guide (or shall we call it a mini-book) which I announced in my previous blog, I found it to be a great read. I'd recommend it to anyone who would like to get more insights not only about performance tuning UDM but also about the inner workings of the server. Some caveats… The guide doesn't answer the…
Read articleThe highly-anticipated Analysis Services 2005 performance whitepaper is finally here. I found a few things intresting glancing at it: This is a colossal work spanning some 120 pages (no wonder it took so long [:)]. The guide was written by the top architects on the SSAS team. It specifically references SQL Server 2005 SP2 probably because SP2 brings many performance optimizations to SSAS. The guide mentions a new aggregation utility (Appendix C)…
Read articleSometimes, you may need to have a configuration setting that is stored outside UDM. For example, you may need to store a connection string to a database that will supply the allowed set for dynamic security. As with SSRS, you can use the msmdsrv.exe.config file for this purpose like so: <configuration> <startup> <requiredRuntime version="v2.0.50727" safemode="true" /> </startup> <runtime> . . . </runtime> <appSettings> <add key="connectionString"…
Read articleIts UDM support limitations withstanding (a partial list here), the Report Builder should definitely be on your list if your requirements call for ad-hoc reporting from an SSAS 2005 cube. Here are some Report Builder features that I particularly like: Ability to pre-filter the data on the report before the report is run. In comparison, Excel takes the optimistic approach to load all dimension members…
Read articleAs you probably know by now, Microsoft has recently released Service Pack 1 of Visual Studio.NET 2005. Since the Report Viewer controls are owned by the VS.NET team, it turned out that they have been updated also. Many bug fixes have been implemented. The new features include: Report Viewer ASP.NET Control Enhancements Reset method to reset the control to its default values. Both ASP.NET and…
Read articleIn the spirit of the season, the SQL Server team give us the third (and probably last before the final release) CTP3 build (version 9.00.3033.0000) for the forthcoming SQL Server 2005 Service Pack 2.
Read articleThe December 2006 edition of the SQL Server 2005 Samples and Database is available for download.
Read articleAfter installing CTP2 of SQL Server 2005 SP2, I started getting a rather annoying exception when attempting to launch the Report Builder. An application for this deployment is already installed with a different application identity. I've noticed that this happens when I run the Report Builder form a server that has CTP2 installed and then I run it from my local machine that doesn't have…
Read articleAs noted before, a major SSRS enhancement in the SQL Server 2005 Service Pack 2 is integration with SharePoint v3.0 and Microsoft Office SharePoint Server. After the RTM release of SQL Server 2005, the SSRS team has been hard at work to implement this feature. Starting with the newly released CTP2 build of SQL Server 2005 Service Pack 2, the SharePoint integration mode is available…
Read articleDownload location: http://www.microsoft.com/technet/windowsserver/sharepoint/download.mspx Demo: http://office.microsoft.com/en-us/sharepointtechnology/HA102055631033.aspx
Read article
