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 articlesOpen Data Protocol (OData), previously known as ADO.NET Data Services, is quickly gaining popularity as a web protocol for querying and updating data. A few Microsoft products already expose their functionality as OData services, including SharePoint 2010, SQL Azure, and Reporting Services (see my blog about reports as data feeds). Therefore, chances are that you may need to report off OData services. As it stands,…
Read article
A coworker of mine complained that Integration Services doesn't let you debug script tasks on x64. I found an easy workaround to disable the x64 runtime. Right-click the project node and click Properties. Switch to the Debugging tab and change the Run64BitRuntime to False. Hit F5 and breakpoint will be hit.
Read articleRobert Bruckner announced that SQL Server 2008 R2 was released to manufacturing today. Robert summarized the most important most features. I covered them in my blog as well. I'll update this blog once I find out when R2 will be available on MSDN. UPDATE According to this Microsoft blog, R2 will be available for MSDN subscribers on May 3rd.
Read article
I have to admit that I am a performance buff. In a previous blog, I mentioned that the Xperf utility can help you gain additional understanding about the Analysis Services performance. Akshai Mirchandani from the SSAS team was kind enough to share his performance testing experience and recommended this utility. It turns out he was right – it is a real gem! Just after writing…
Read articleI will be speaking at the Atlanta Microsoft Database Forum group (Atlanta.MDF) on May 10th in Atlanta, GA . The topic will be What's New in Reporting Services 2008 R2. Given that SQL Server 2008 R2 (aka SQL Server 2010) will be released in May, timing is good. This is your chance to learn about and see the cool new features in action, ask tough…
Read articleA couple of years ago I was working on a KPI dashboard project where we had to display a bunch of KPIs produced by counting (distinct count) number of customers, accounts, etc. Even with SSAS 2008 we couldn't much to optimize the queries to render the page in a few seconds because we found that 50% of the execution time was spent in the storage…
Read articleIn a previous blog, I introduced one of the new SSRS 2008 R2 feature: reports as data feeds. As I said, the R2 release will include a new Atom Data Feed renderer to produce an Atom service document (*.atomsvc) which defines a feed(s) per data region. I also said that the main scenario for report feeds was to let the PowerPivot add-in for Excel (previously…
Read article
Scenario: You want to let end users view a report in Report Manager or SharePoint and "remember" the report parameter selection. You find that you cannot just tell the users to add the report URL to the browser favorites because the parameters are not exposed on the URL. This is by design and cannot be changed. Further, you discover that for some reason end users…
Read articleMicrosoft announced release dates for SQL Server R2, SharePoint 2010, Office 2010, and Visual Studio 2010. According to the Microsoft SQL Server Team Blog: SQL Server 2008 R2 (aka SQL 2010) will be listed on Microsoft's May price list, and will be available by May 2010 According the Microsoft SharePoint Team Blog: SharePoint 2010 and Office 2010 will be officially launched on May 12, 2010…
Read articleScenario: You use the Visual Studio ASP.NET ReportViewer and you can't figure out how to get the parameter values when the page posts back. I couldn't find a straightforward answer on the discussion list so I thought my findings could come useful. Solution: Depending on your scenario, you can choose one the following three approaches: 1. You can get the current parameter values after the…
Read article
