SQL Server 2008 R2 Archives - Page 2 of 2

Installing AdventureWorks Analysis Services Database

February 26, 2011

SQL Server 2008 Analysis Services, SQL Server 2008 R2

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,…

Filtering Techniques for SQL Server 2008 R2 Reports

February 20, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL server Reporting Services

No Comments

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…

Chart Reports in SQL Server 2008 R2 reporting services

February 17, 2011

Kalyan Bandarupalli

SQL server 2008, SQL server 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…

Tabular Reports in SQL Server 2008 R2 Reporting Services

February 15, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL server 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…

Database Mail Configuration in SQL Server 2008 R2

February 13, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008

No Comments

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…