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

SQL Server 2005 SP1 Released

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

SQL Server 2005 SP1 Due in a Couple Weeks

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

Microsoft to Acquire ProClarity

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

Implementing Data Security in a Report Model

Bob 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

SQL Server 2005 Service Pack 1 CTP Available

Microsoft has released a Community Techology Preview (CTP) build of SQL Server 2005 SP1. The release date of the final (RTM) bits of SP1 is not announced yet but it shouldn't be that far away (most likely within a month or so).

Read article

Public CTP of SQL Server Express To Be Available Soon

Today, Microsoft announced that SQL Server Express Advanced will be available publicly instead of distributed as a private beta. The CTP (Community Technology Preview) build could be downloaded here (link will be live soon).   You can post question and comments in the SQL Express MSDN Forum or enter bugs and feature requests on the MSDN Product Feedback Center.

Read article

Prologika Forums to be Upgraded Tonight

Telligent has done it again! Community Server 2.0 is out and it's too sleek to ignore. I am planning to upgrade Prologika Forums to CS 2.0 tonight. If all is well, tomorrow Prologika Forums will have a facelift and more features. I hope the upgrade process won’t last too long and won’t cause service interruptions.

Read article

Phantom Data Extensions

There are two “shy” data extensions that come with RS 2005 but you won’t see when you create a data source. The first one (SSIS data extension) enables interesting integration scenarios with SQL Server 2005 Integration Services. It allows you to author reports that use data generated by running an Integration Services (SSIS) package. The second one is the SAP data extension for integrating SSRS…

Read article

Where Is My Cartridge?

A little known fact about the SSAS data architecture is that it uses “cartridges” to communicate with the data source. In brief, a cartridge is a XSL stylesheet that defines capabilities of a data source, as well as the rules for optimizing the SQL statements for relational querying and writing. SSAS 2005 ships with set of cartridges for Jet, SQL 70, SQL 2000, Oracle, Teradata,…

Read article

MDX Solutions Book on the Horizon

Chris Webb tells us that the MDX Solutions book, which we co-wrote with other MDX gurus, is soon to be released. Based on the resources available on the publisher's website, the book looks like a very promising read and I am looking forward to get my hands on it. Unfortunately, during my Applied Microsoft Analysis Services 2005 book project, I didn't have the time to fully research the vast…

Read article