SQL Server 2008 R2

Extended Protection available in SQL Server 2008 R2

We use Internet Protocol Security (IPSec) within the trusted domains, but use the Negotiate Security Support Provider for our web applications. What other security methods can we employ with SQL Server?

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.

For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...

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.

Reporting Services 2008 R2: Geospatial Visualization – Part I

Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services. This step-by-step tutorial demonstrates the creation of a Map Report.

Configure Windows Firewall for SQL Server 2008 Integration Services in Windows Server 2008 R2

I have installed SQL Server 2008 on Windows Server 2008 R2 and I am unable to connect to SQL Server 2008 Integration Services Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Integration Services in Windows Firewall for user connectivity.

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.

How to enable SSIS as data source type on SQL Server Reporing Services SSRS 2008 R2

when you create a data source in SSRS 2008 R2 (Nov CTP), you won't be able to get SSIS listed as a data source type. Therefore applications that are already using it as a data source or applications that require it as a data source get stuck. Let's learn how to enable and get SSIS listed back as a data source in SSRS 2008 R2.