Category: SQL Server 2008 R2

Building a Scale-Out SQL Server 2008 R2 Reporting Services Farm Whitepaper Now Available

Back in 2009, I wrote a 4-part series article on installing SQL Server 2008 Failover Cluster on Windows Server 2008 and, for the past two years, has been on the Top Ten Tips. I think one of the reason is because of the fact that we humans learn easily with the use of visuals (the […]

SQL Server 2008 R2 Service Pack 1 Has Been Released

I just found out recently that SQL Server 2008 R2 Service Pack 1 has been released. Microsoft KB article 2528583 lists all of the bugs that are fixed by the service pack. SQL Server MVP Aaron Bertrand blogged a few months back about the features that were added to the database engine. Hopefully, after installing […]

Building a Scale-Out SQL Server 2008 R2 Reporting Services Farm using Windows Network Load Balancing Part 2

Part 2 of the series is out. The rest will probably take quite some time as I’m still wrapping up a few items on the ASP.NET aspect of SQL Server 2008 R2 Reporting Services. Stay tuned

Building a Scale-Out SQL Server 2008 R2 Reporting Services Farm using Windows Network Load Balancing Part 1

For the past couple of weeks, I’ve been working on a series of articles on building a scale-out SQL Server 2008 R2 Reporting Services Farm. Part 1 of this series is already available on MSSQLTips.com. This was inspired by the SQL Server 2008 Failover Cluster installation series as I’ve been searching for available guides online […]