SQL Server 2008 R2 Best Practices Analyser

Yes the SQL Server best practices analyser is back and it can be used to analyse your SQL Server 2008 or 2008 R2 instances. The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions: Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance…

2

SQL Server 2008 R2 and SQL Azure Whitepapers

Kerberos/Double hop with SSRS From a infrastructure implementation of Microsoft BI solutions, one of the most difficult things to get right can be authentication between multiple servers in a scale out solution. This is known as the ‘double hop’ situation. A new white paper released in April 2010 outlines how to configure and troubleshoot a…

3

SQL Server 2008 R2 has RTMed

We are very excited to share that today, Microsoft released SQL Server 2008 R2 to manufacturing! Customers can expect availability in the next few weeks through Microsoft’s distribution channels. For more information, visit www.sqlserverlaunch.com. SQL Server 2008 R2 enhancements continue to support mission-critical workloads providing a trusted, scalable platform, increased developer and IT efficiency and…

3

Whitepaper: PowerPivot Planning and Deployment

An comprehensive whitepaper regarding the installation and deployment of PowerPivot has been recently released by the SQL CAT Team. It can be accessed from the below site: http://sqlcat.com/whitepapers/archive/2010/04/14/microsoft-sql-server-2008-r2-powerpivot-planning-and-deployment.aspx Direct link to whitepaper: Microsoft SQL Server PowerPivot Planning and Deployment Summary: Microsoft® SQL Server® PowerPivot technology redefines how IT departments deliver and succeed with BI. This…

1

FREE Online SQL Server 2008 R2 Training

Three of the six RTM SQL Server 2008 R2 e-clinics are ready; the final three will arrive in mid-April: · Introduction to Microsoft® SQL Server® 2008 R2 Master Data Services / This two-hour clinic describes the capabilities of Microsoft SQL Server 2008 Master Data Services, including the following topics: Master Data Services concepts, hierarchies and…

4

Update for SQL Server 2008 Developer Training Kit – Now includes SQL Server 2008 R2 material

Download it from – http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d  SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL…

1

SQL Server 2008 R2: Multi Server Management Feature Survey

As we are nearing to the release of SQL Server 2008 R2, I have been presenting about its new features and one that reasonates well amongst the DBAs is the multi server management. DBAs see this as a great way of getting insight into planned consolidated SQL Server environements. It not only helps from understanding…

1

Really Scale with SQL Server 2008 R2

You have no doubt heard that with SQL Server 2008 R2 and Windows Server 2008 R2 we can now address 256 processors. This is all good in theory – now see a video showing off some of the latest hardware from Unisys running pre-release versions of SQL Server 2008 R2. With this combination you can…

2

Want to try PowerPivot for Excel 2010, but don’t have access to Excel 2010

Well then follow the below link and you can launch an virtual lab that takes you through the PowerPivot add-in. The only thing you need to install is an ActiveX control to let you access the virtual lab environment. https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d

1

Application and Multi-Server Management features in SQL Server 2008 R2

SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and productivity. Investments in application and multi-server management will help organizations proactively manage database environments efficiently at scale through centralized visibility into resource utilization. Such investments can help streamline consolidation and upgrade initiatives across the application lifecycle—all with tools that make it…