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 articlesBack to my When (null) is not Null post, there is a undocumented breaking change in SQL Server 2005 SP2 which you should be aware of. In response to the customer demand, SP2 treats aggregate rows as detail rows. As a result, if the report doesn’t use the Aggregate() function, the report will show all rows. For those using the Aggregate function, there will be…
Read articleI am back from an one-week vacation to Clearwater, Florida followed by TechEd 2007 US in Orlando. Overall, nothing earth – shattering on the BI arena from TechEd 2007. Product groups are between releases so most of the content was SQL Server 2005-based with a few sneak previews of some of the good stuff to come in Katmai. My presentation attracted a fairly large crowd.…
Read articleIf you target the SSRS Report Builder as an UDM client you may find the following two workarounds (aka hacks) useful. Both hacks require manually updating the SMDL definition. Alas, so much about model auto-generation L. Multi-grain Relationships Don't Appear If a dimension joins a measure group at a higher grain the corresponding Report Builder role is excluded from the model. Steps to repro: Open…
Read articleSQL Minds has released Companion for MS Analysis Server. Companion for MS Analysis Server is a product that helps with the health monitoring and performance tuning of Microsoft SSAS 2005. The product offers historical baseline, custom aggregations and their usage, meta data browsing, cube browsing, various reports on SSAS inner workings, trace information on slowest SQL, DMX, MDX and XMLA requests, processing information broken down…
Read articleThe ASP.NET ReportViewer control has a HyperlinkTarget property which may give false expectations. You may believe that this property applies to all hyperlinks, including links to drillthrough reports. For example, you may attempt to set the HyperlinkTarget to _blank to open a drillthrough report in a new window. However, you will be disappointed to find that drillthrough reports ignore the HyperlinkTarget property completely. That's because…
Read articleA little known but very useful SSRS feature which debuted in SQL Server 2005 SP2 is that the SSRS Windows service automatically upgrades the report catalog (ReportServer database) if required. As I discussed in this blog, you may need to swap the report catalog for testing or troubleshooting purposes. In the past, you had to manually upgrade the catalog from a previous version using the…
Read articleMy breakout TechEd session BIN305 - Applied Microsoft SQL Server 2005 Reporting Services is scheduled for June 4 at 10:30 AM - 11:45 AM in room S320 A. That's right – let's talk reporting right after the keynote! I hope to see some of you there.
Read articleI've added two more RS blogs to the Reporting Services link section. The Reporting Services Team blog is used by the RS team as a whole. The Reporting Services User Education blog is used by the education group on the Reporting Services team. It's managed by a former colleague and friend of mine, Matt Mayer, who joined the Reporting Services team a year ago. The entire…
Read articleThe March release of SQL Server 2005 samples is available for download. Note that Microsoft has moved all SQL Server 2005 samples (standard and open source) to the CodePlex website. The documentation is still on MSDN. So, GotDotNet is dead, long live CodePlex!
Read articleIf you follow the Microsoft .NET roadmap, you have probably heard about the forthcoming Language Integrated Query (LINQ) in .NET 3.0. LINQ will add query capabilities directly into the CLR and will be supported by both VB.Net and C#. This means that you will be able to use standard query operators directly from within your code! To help you get started with LINQ, Marco Russo…
Read article
