Skip to articles

PROLOGIKA BLOG · IDEAS FROM THE FIELD

Making sense of data.
Sharing what we learn.

Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.

Explore the latest articles

Losing Identity

After 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 article

SSRS-SharePoint Integration in SP2 (the Good, the Bad, and the Ugly)

As 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 article

SharePoint Services 3.0 Released

Download location: http://www.microsoft.com/technet/windowsserver/sharepoint/download.mspx Demo: http://office.microsoft.com/en-us/sharepointtechnology/HA102055631033.aspx

Read article

Report Snapshots and rsReportNotReady

Two very useful features of Reporting Services (version 2000 and above) are snapshot execution and report history. Snapshot execution allows you to cache the report execution. Optionally, you can keep the cached reports in history, e.g. if the user wants to keep a copy of the report for historical analysis. Once a report is enabled for snapshot execution, you can generate the history snapshot by…

Read article

Visual Studio 2005 Team Edition for Database Professionals

The newly released CTP7 of Visual Studio 2005 Team Edition for Database Professionals (aka DataDude) now supports bi-directional schema updates. Once you generate the scripts from your database schema, you can choose either the database or the scripts as a source of changes and commit the changes to the target. Visual Studio 2005 Team Edition for Database Professionals requires Visual Studio 2005 Team Edition.

Read article

SQL Server 2005 SP2 CTP 2 Build Released Today

The second CTP (Community Technology Preview) build of the forthcoming SQL Server 2005 Service Pack 2 was released today. Besides bug fixes, SP2 includes major BI features and enhancements including: Reporting Services SharePoint 2007 integration – this one is a true enzilla (enhancement Godzilla) and deserves a separate post. Suffice to say that unlike the previous Explorer and Viewer webparts, SP2 will allow you to…

Read article

Office 2007 RTM’ed

Microsoft Corp. today announced the completion of the 2007 Microsoft® Office system code and confirmed its release to manufacturing (RTM).

Read article

Linked Attribute Hierarchies

In UDM, the cube space is defined by attribute hierarchies. Dimensions are just logical containers of attribute hierarchies. It will be great if the next release of SQL Server (Katmai) could expand further on the attribute nature of UDM and solve some nagging issues that modelers currently face. Let's consider an example. Say, you have Geography and Customer dimension tables (see the AdventureWorksDW database). It…

Read article

Drill Through Your Way

One of the most useful features of the SSRS 2005 Report Builder is the ability to generate reports on the fly. As long as there is a navigational path in the model, the end user can click on a drillthrough-enabled attribute to see more details. This feature is officially called infinite drillthrough. Sometimes, the automatic drillthrough reports may get in the way. For example, there…

Read article