SSRS 2008 R2 Hosting « SQL 2008 Hosting News (SuperBlogAds Network)

SQL Server 2008 R2 Hosting :: Chart Reports in SQL Server 2008 R2 reporting services

By Jose Sharp, on January 20th, 2012%

This post discuss about configuring the AdventureWorks Analysis Services Database in SQL Server 2008 R2. You can download the sample databases from here. By default when you install the setup you would not see the analysis services database, you need to do some configurations to get it appear in analysis services database.

To deploy the analysis services . . . → Read More: SQL Server 2008 R2 Hosting :: Chart Reports in SQL Server 2008 R2 reporting services

SQL 2008 R2 Reporting Services Hosting :: Filtering Techniques for SQL Server 2008 R2 Reports

By Jose Sharp, on June 16th, 2011%

It is important to consider to filter report data based on user’s selection criteria as many databases contain large amounts of data. This post discusses different techniques to filter report data using report parameter concepts. By using the filters on reports, it greatly reduces the network traffic and helps the report to render efficiently.

We are using . . . → Read More: SQL 2008 R2 Reporting Services Hosting :: Filtering Techniques for SQL Server 2008 R2 Reports

SQL 2008 R2 Reporting Services Hosting :: Tabular Reports in SQL Server 2008 R2 Reporting Services

By Jose Sharp, on June 8th, 2011%

It is important to understand the reporting options available in SQL Server 2008 R2 to provide an appropriate report layout to meet the business requirements and needs of our end users. This post briefly discusses about different report layout types available and explains in detail the steps to create a Tabular Report. It also explains how . . . → Read More: SQL 2008 R2 Reporting Services Hosting :: Tabular Reports in SQL Server 2008 R2 Reporting Services

SSRS 2008 R2 Hosting :: Solving ReportViewer Rendering Issues in IIS 7

By ricardo, on April 12th, 2011%

Applies to:

- Internet Information Services 7.o (IIS7)
- Microsoft Report Viewer Redistributable 2005

Symptoms:

- Unable to render ReportViewer on ASP.NET Web pages while running on IIS7.
- You have no problem viewing your reports when running on debug mode with your Visual Studio 2005.
- You are able to view your reports on Report Manager but not able to view . . . → Read More: SSRS 2008 R2 Hosting :: Solving ReportViewer Rendering Issues in IIS 7

SQL 2008 R2 Hosting – Top IMPORTANT Features in SQL 2008 R2

By ricardo, on March 31st, 2011%

With all the new features in SQL 2008 R2, here are the major ones getting all the press:

PowerPivot
Parallel Data Warehouse
Application and Multi-Server Management
StreamInsight
256 core support

There is so much written on the ones above, I wanted to concentrate on talking about other new features in SQL 2008 R2. So, in no particular order:

1. SMB support – . . . → Read More: SQL 2008 R2 Hosting – Top IMPORTANT Features in SQL 2008 R2

SQL 2008 R2 Hosting :: Working with Case Insensitive Data

By ricardo, on March 24th, 2011%

Today, I have faced a very simple but still annoying problem. I was asked by a client that queries are not working correctly with given WHERE clause. Actually database was design as case insensitive but SOMEHOW on application side there were some business logics which client needs case sensitive inputs (Just like password) and comparisons.

Here is . . . → Read More: SQL 2008 R2 Hosting :: Working with Case Insensitive Data

SQL 2008 R2 Hosting :: Setting Up Maintainance Plans in SQL 2008 R2

By ricardo, on March 16th, 2011%

One of the repetitive tasks that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in SQL Server 2008 R2

You can use the following steps to . . . → Read More: SQL 2008 R2 Hosting :: Setting Up Maintainance Plans in SQL 2008 R2

SSRS 2008 R2 Hosting :: Maps, Data Bars, Indicators and Sparklines in SSRS 2008 R2

By Jose Sharp, on February 10th, 2011%

In this post, we are going to look into another data visualization enhancement called the Data Bars. This has been available in MS Excel for quite some time now so it is good to see this make it’s way in SSRS as well. We can go to the report manager and click on the “Report . . . → Read More: SSRS 2008 R2 Hosting :: Maps, Data Bars, Indicators and Sparklines in SSRS 2008 R2

MSSQL 2008 R2 Web Hosting :: A Look Inside New Features in SQL Server 2008 R2

By ricardo, on January 26th, 2011%

If you are looking for SQL Server 2010 you are not going to find it. The version released this year is instead SQL Server 2008 R2 and while there aren’t any massive improvements aimed specifically at the developer you’ll find the general improvements make it easier to create applications that do what your users want.

Of the . . . → Read More: MSSQL 2008 R2 Web Hosting :: A Look Inside New Features in SQL Server 2008 R2

SSRS 2008 R2 Hosting :: Centralize and Control Data Access in SSRS 2008 R2

By Louise Lahm, on November 19th, 2010%

Problem

Reporting is a common and frequent requirement of any business practice and often reports are developed by business users as well as the IT department of the organization. Data Source and Data Sets are two major entities used in any report development using SQL Server Reporting Services (SSRS) whether the report is developed using Business Intelligence . . . → Read More: SSRS 2008 R2 Hosting :: Centralize and Control Data Access in SSRS 2008 R2

SQL 2008 Hosting News (SuperBlogAds Network)