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 articlesAs an update to my previous post, SQL Server 2005 SP2 is now officially available. The SP2 build is 9.00.3042. A SP2 landing page is available too that includes links to the SP2 release, KB articles, marketing information about the benefits of SP2. As a personal contributor to Service Pack 2 (mainly in the areas of Reporting Services SharePoint integration and Analysis Services), I hope…
Read articleThanks for Russell Christopher's blog, we now know that the final release of SQL Server 2005 Service Pack 2 is very close to going live. I will update this blog when the download link is known. I listed the SP2 major BI-related enhancements in this blog. The most significant ones (RS-SharePoint integration, enhanced Excel OLAP and data mining features) makes SP2 a major milestone in…
Read articleIt's time for my annual presentation for the Atlanta.MDF group. This time, the topic will be the SSRS-SharePoint integration mode with SQL Server 2005 Service Pack 2 which I blogged about before. I've uploaded the PowerPoint slides to my website.
Read articleNow 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 article
