New Storage and SQL Server capacity planning article for SharePoint Server 2013

The much anticipated, Storage and SQL Server capacity planning and configuration (SharePoint Server 2013) article is now live on TechNet. The product group invested many hours of testing both SQL Server 2008 R2 SP1 and SQL Server 2012 with SharePoint Server 2013. Use the resulting data in this article as a guideline to help you plan and deploy SQL Server in your…


​Microsoft BI Solution Builder: Business Intelligence tools and capabilities are available

Recently, Microsoft released the BI Solution Builder (, an online tool that you can use to find out what business intelligence capabilities are available to you based on what your organization currently owns. It’s quick and easy to use, and it can help you put your BI environment to work in short order. For example,…


SQL Server 2012 Enterprise Test Lab Guide published

The Test Lab Guide: Install SQL Server 2012 Enterprise is a new building block Test Lab Guide (TLG) that steps you through the default installation of SQL Server 2012 Enterprise on APP1 or another domain member server in the Base Configuration test lab. There are step-by-step instructions for the following: Configuring the Base Configuration test…


The first Test Lab Guide (TLG) for SharePoint Server 2010 is published!

I am proud to announce the publication of the first Test Lab Guide (TLG) for SharePoint Server 2010, titled Test Lab Guide: Configure SharePoint Server 2010 as a Single Server with Microsoft SQL Server. This document in the Microsoft Download Center describes how to install and configure SharePoint Server 2010 on a single server with…


Fabulous SQL Server connection troubleshooting article in the TechNet Wiki!

Check out How to Troubleshoot Connecting to the SQL Server Database Engine in the TechNet Wiki. Author Rick Byman takes you step-by-step though the troubleshooting process when you get the “Connect to Server” error. I strongly encourage you to bookmark this article and use it for the next time you see this type of error….


Find active databases used by SharePoint Server 2010

One of the best ways to know what databases your SharePoint deployment uses is to keep a record and add database names each time you create a new database.This isn’t always easy as there usually isn’t enough extra time during the day to keep records. Plus, more often than not your SharePoint database maintenance tasks tend to occur…


Extra! Extra! Apple iPad Users Can Now View SharePoint Business Intelligence Content

In the recent blog post, December 2011 CU for SharePoint 2010 has been released, Senior Escalation Engineer for SharePoint Stefan Goßner provides an overview of Cumulative Update 2011-12 (CU 2011-12) for SharePoint Server 2010 (thanks, Stefan!). For SharePoint business intelligence users, CU 2011-12 for Microsoft SharePoint Server 2010 is particularly exciting because it opens the…


Book excerpt: "Collaboration Meets Business Intelligence"

Chapter 2 of the new McGraw-Hill book, Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010, is now available on TechNet. Written by Philo Janus and Stacia Misner, this book highlights the Microsoft business intelligence (BI) tools that are available today and provides comprehensive guidance for developing BI solutions. Chapter 2,…


SQL Server 2008 R2 Reporting Services Integration in SharePoint 2010

Taking two powerful applications and integrating them can yield powerful results. Such is the case with SQL Server and SharePoint Server. And with the SharePoint Server 2010 and SQL Server 2008 R2 releases, the enhanced integration is significant. The main benefit in integration is that it allows you to view, store, and manage report server…


Revamped business intelligence scenario hub on TechNet

The Microsoft Business Intelligence Center ( on TechNet has just been revamped. It is now a content hub featuring six end-to-end scenarios that highlight cross-product integrations for BI solutions. What makes this new hub unique is that it is a pilot for the new five-bucket lifecycle that TechNet is adopting, based around the Microsoft Operations…