SQL Server “Denali” CTP3 Product Guide

So you have downloaded Denali CTP3 from – https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/ and now want to know what are the new bits in it. To help answer this question we have released a product guide to help you through this process. This product guide can be downloaded from – http://www.microsoft.com/download/en/details.aspx?id=27069 The SQL Server Code Name “Denali” CTP3 Product…


Whitepaper: SQL Server 2008 R2 Analysis Services Operations Guide

A comprehensive (108 pages) whitepaper has recently been released that describes describes how operations engineers can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. Download Link: SQL Server 2008 R2 Analysis Services Operations Guide


New on Technet – BI Scenarios site

The Microsoft BI team have put together a great site on Technet, that has end-to-end guidance on how to implement BI solutions in your organizations. Additional scenarios will be added regularly, so add this site to your favourites and keep on visiting frequently. You can also leave comments on the topics you are looking for…


Database Development Guidance Paper published by the Application Lifecycle Management Rangers

  Recently, on codeplex the Application Lifecycle Management Rangers from Microsoft have made available guidance on database development practices when using Visual Studio 2010 database projects. This practical guidance is focused on the following topics: Solution and Project Management Source Code Control and Configuration Management Integrating External Changes with the Project System Build and Deployment…


Whitepaper: SQL Server High Availability Whitepaper by SQL CAT Team – Failure Is Not an Option: Zero Data Loss and High Availability

  When it comes to financial transactions of customers and their money, it is absolutely imperative that none of these transactions is ever lost due to an IT system failure (or any other type of failure). This white paper shows you how to create a Microsoft SQL Server infrastructure that enables operation for zero data…


Whitepaper: SQL Server’s Price/Performance

Following whitepapers have been released/updated and discuss SQL Server’s great low TCO and Enterprise capabilities. It is a must read for anyone looking for a database platform that can provide the best value.   Do Not Pay Too Much For Your Database Licenses: update from previous white paper entitled Understanding DB Pricing that shows SQL…


Master Data Services Portal on MSDN

Master Data Services portal page is now live on MSDN! This portal  presents information about MDS from many different sources, including Microsoft, third-party, and community contributions. The following table outlines the kind of information we’re sharing with users on the page: Section Description Getting Started Features links to introduce customers to MDS, help them find…


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…