SQL Server 2008 SP2 is available for download.

The major enhancements are :

  • 15K partitioning improvement
  • Reporting Services in SharePoint Integrated Mode
  • SQL Server 2008 R2 Application and Multi-Server management Compatibility with SQL Server 2008
  • SQL Server 2008 Instance Management
  • Data-tier Application (DAC) support

The Team Explorer 2008 for VS 2008 doesn’t connect to TFS 2010 default.

Here are different steps for the connection:

1. Install Visual Studio 2008
2. Install Team explorer 2008 for Visual Studio 2008
3. Install or reinstall Visual Studio 2008 SP1
4. Install patch for compatibility Team Explorer 2008 to TFS 2010

Once completed steps, we can connect to TFS 2010.

There is one difference to connect to TFS 2010 with Team Explorer 2008 compared to Team Explorer 2010.
In Team Explorer 2008, we must specify the project collection for see the different projects.

When a query is executed, it’s possible that’s returns no data.
By default, Reporting Services display the header and footer without content.

Rather than displaying an empty tablix, we can write a message that replace it.

In property view for tablix, we have a region “No Rows”. It allows to define different properties when the table has no data such as color, font, …
It’s “NoRowsMessage” property which can specify the message.

The result :

By default, Reporting Services provides various export formats.

User aren’t always interested all these formats. We can hide the formats that are not useful. That this, you must open the configuration file “rsreportserver.config” located in the directory “Report Server” for website.

By default in SQL Server 2008, it is “C:\Program Files\Microsoft SQL Server\MSRS10.MSSQL2008\Reporting Services\ReportServer”.

In this file, export formats are defined in tag “Render”. To hide or not, we set the visible attribute to true or false for each render

For example, we will show that the PDFs and Excel formats.

<Configuration>
  <Extensions>
    <Render>
      <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>
      <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>
      <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>
      <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>
      <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
      <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
      <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
      <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>
      <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>
      <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering" Visible="false"/>
    </Render>
  </Extensions>
</Configuration>

The result :

Warning: if you change an option in this configuration file, the change take effect for the entire site “ReportServer” in Reporting Services.

Microsoft announced SQL Server 2008 R2 RTM.

  • 3 may : for technet and MSDN subscribers
  • 13 may : for worldwide

Source : http://blogs.technet.com/microsoft_blog/archive/2010/04/21/SQL-Server-2008-R2-Helping-Customers-Get-More-Value-Out-of-Their-Data.aspx

Powered by WordPress Web Design by SRS Solutions © 2012 Mathieu Nanoux Design by SRS Solutions