TechBubbles Microsoft Technology BLOG

CategorySQL server 2008

Installing AdventureWorks Analysis Services Database

    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 database perform the...

Filtering Techniques for SQL Server 2008 R2 Reports

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 same data source and query that...

Chart Reports in SQL Server 2008 R2 reporting services

  Charts are effective way to visualize the aggregated values. This post discuss about creating a chart, Pie and Gauge reports using SQL server 2008 R2 Reporting Services. You will notice a significant difference in chart types in SQL 2008 R2 compared to SQL 2005. Choosing Chart types: The important point while choosing a report type is – choose a chart type that meets the need and adds...

Tabular Reports in SQL Server 2008 R2 Reporting Services

  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 to sorting and drilldown features to your report...

Database Mail Configuration in SQL Server 2008 R2

  This post explains the configuration steps that require to send an email from SQL server 2008 R2. It is useful if we could send an email from SQL Server to our administrators and end users. Database Mail is SQL server component that uses Simple Mail Transfer Protocol (SMTP) to send email messages. After setting up the Database email we can test the email and mail-log. 1. Open the SQL...

Data Binding for Silverlight Application

This post explains loading data into Silverlight form using ADO.NET Data Services service. We need to do the following tasks to achieve this

Creating an ADO.NET Data Services project
Creating a Silverlight application and referring the created service above

Creating the ADO.NET Data Services project 
1. Create an empty web application using Visual Studio 2010 as follows

TechBubbles Microsoft Technology BLOG

Follow me


Tag Cloud