Browse by Tags

• Analysis Services
• Business Intelligence
• Reporting Services

• SQL Server 2008 February CTP Is Out

  February CTP is out. It brings the much anticipated integration with Visual Studio 2008 and the new BIDS Report Designer. Download the February CTP here: http://www.microsoft.com/sql/2008/prodinfo/download.mspx Updated Books Online for February CTP are... Posted Feb 22 2008, 07:41 AM by tlachev with | with 1 comment(s) Filed under: Reporting Services, SQL Server 2008

• SQL Server 2008 Expected Q3 2008

  Francois Ajenstat, Director of Product Management for Microsoft SQL Server, tells us that SQL Server 2008 will be released in Q3 2008 while Release Candidate (RC) is expected in Q2. The February 27 th marketing launch date remains unchanged. Posted Jan 25 2008, 03:59 PM by tlachev with | with 3 comment(s) Filed under: SQL Server 2008

• Getting Rid of the Vista Credentials Prompt

  There could be 1001 reasons why IE asks you for credentials when you access a website configured for Windows Authentication and none of them has to do with Reporting Services itself. Windows Vista and IE 7 add yet another one. IE 7 will prompt you for... Posted Dec 06 2007, 06:47 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• Performance Improvements for MDX in AS 2008

  Here is a useful page from the SQL Server 2008 BOL that summarizes the SSAS performance improvements in Katmai pretty well. It also shows which functions are optimized. For example, the Lag function wasn't optimized in 2005 but now is. Posted Nov 25 2007, 11:01 PM by tlachev with | with no comments Filed under: Analysis Services, SQL Server 2008

• SQL Server 2008 November CTP Is Out

  The November CTP (CTP5) of SQL Server 2008 is out . Here are the most significant BI-related highlights that caught my attention. Reporting Services The standalone Report Designer has undergone a major facelift. It now sponsors a shiny Office 2007 ribbon... Posted Nov 19 2007, 01:14 PM by tlachev with | with no comments Filed under: Business Intelligence, SQL Server 2008

• Parameterized Parameter Prompts

  One new SSRS 2008 feature that international users will undoubtedly appreciate is parameterized parameter prompts. Previously, the parameter prompts were static. In SSRS 2008, you will notice the familiar function symbol (fx) next to the parameter prompt... Posted Oct 18 2007, 05:15 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• SSRS 2008 Variables

  As I mentioned in my Under the Hood post , the SSRS 2008 engine has been redesigned to perform on-demand report processing for better scalability. As a result, textbox values are calculated on-demand every time the containing page is rendered. Irrespective... Posted Sep 09 2007, 10:19 AM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• Under the Hood

  One of the major themes in SSRS 2008 is scalability. A significant effort will be made to ensure that SSRS scales well with large reports. Why is this needed? Recall that in SSRS 2005 (and 2000), report processing is instance-based. This means that the... Posted Aug 29 2007, 09:21 PM by tlachev with | with 1 comment(s) Filed under: Reporting Services, SQL Server 2008

• Charting the Future

  It is old news by now that Microsoft has acquired the intellectual rights to the Dundas Reporting Services controls, including the Dundas chart, map, gauge, and calendar. At this point, it is not known if all controls will make it to Katmai but the chart... Posted Aug 18 2007, 11:16 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• RDL Object Model on the Horizon

  As I mentioned in a previous blog , SQL Server 2008 will probably include an RDL Object Model. This is great news for developers who generate report definitions programmatically. No more custom RDL object models as the one I talked about during my TechEd... Posted Aug 14 2007, 06:10 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• SQL Server Katmai Reporting Services Forum

  In case you've missed it, the SSRS team has started a SQL Server Katmai Reporting Services forum and eagerly awaits your feedback. Posted Aug 13 2007, 10:10 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• Tablix – The Crown Jewel

  One of most important enhancements coming up in SQL Server 2008 Reporting Services is the new tablix region. In fact, I dare to predict that many folks will upgrade to SSRS 2008 just to get Tablix. What's tablix anyway? Tablix = Tabl e + Matr ix So... Posted Aug 12 2007, 10:34 PM by tlachev with | with 2 comment(s) Filed under: Reporting Services, SQL Server 2008

• The New Kid on the Block (aka Stand-alone Report Designer)

  The need for a stand-alone Report Designer is real. True, developers, including myself, enjoyed the VS.NET Report Designer. But novice users were overwhelmed with the complexity of the VS.NET IDE environment. In addition, not all IT shops rejoiced over... Posted Aug 07 2007, 07:13 AM by tlachev with | with 2 comment(s) Filed under: Reporting Services, SQL Server 2008

• The Perfect Host

  This is my first blog about SSRS 2008. The July CTP (CTP4) of SQL Server 2008 (aka Katmai) includes the new hosting model of Reporting Services. Gone is the dependency to IIS and all the management headaches associated with it. Instead, the SSRS Windows... Posted Aug 04 2007, 11:38 AM by tlachev with | with 1 comment(s) Filed under: Reporting Services, SQL Server 2008