Create CNN-style Map in Reporting Services

This article demonstrates how to use US Census' TIGER/Line shapefile to display CNN-style map in Reporting Services.

Understanding SQL Server 2008 R2 Fixed Database Level Roles

To easily manage the permissions in SQL Server databases, Microsoft has provided several roles in SQL Server which are security principals that group other principals.

Getting Started with Data Bars in SQL Server 2008 R2 Reporting Services

I'm looking at several new visualization features in SQL Server 2008 R2 Reporting Services and the data bar looks like something that I could really use. Can you provide an example of how to use this in a report?

Upgrading Data Tier Applications in SQL Server 2008 R2

Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take?

Deploying Data-Tier Applications of SQL Server 2008 R2

SQL Server 2008 R2 Data-Tier Applications make database development, deployment and management much easier. When you create and build a Data Tier Application, it creates a single, self-contained unit of deployment called a DAC package. Arshad Ali shows you how to deploy the created DAC package and discusses the different methods of deployment.

SQL Server 2008 R2

New Features in Reporting Services 2008 and 2008 R2

Quietly, Microsoft has been making radical improvements to Reporting Services; but precisely what was introduced, and when? We asked Bill Pearson, the well-known BI expert, to come up with a definitive survey of the more recent changes and how they help the user of Reporting Services.

Shared Datasets in SQL Server 2008 R2

Shared Datasets are one of the features introduced in SQL Server 2008 R2. This article demonstrates how to implement Shared Datasets as well their use-case scenarios.

Free e-book: Introducing Microsoft SQL Server 2008 R2

For a limited time, you can download this 10-chapter e-book: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner.

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.