Now that SQL Server 2014 is out – wondering how you can leverage the power of In-Memory OLTP for your applications

Take a look at this great whitepaper recently published that discusses common patterns for implementing and leveraging the new In-memory OLTP capabilities of SQL Server 2014. Download the whitepaper from: In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. For performance critical workloads,…


SQL Server 2014 Database as a Service Whitepaper

Database as a Service Reference Architecture Guide: SQL Server 2014 This guide to building the infrastructure for hosting Microsoft® SQL Server® Database as a Service (DBaaS) is not limited to a particular type of hardware. By using the features of SQL Server 2014 and Hyper-V® virtual machines with Microsoft System Center 2012, a hosting…


SQL Server “Denali” CTP3 Product Guide

So you have downloaded Denali CTP3 from – 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 – The SQL Server Code Name “Denali” CTP3 Product…


Whitepaper: Implementing SQL Server Parallel Data Warehouse using Kimball Approach

Summary: This white paper explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse, and how you would incorporate this new product as the cornerstone of your DW/BI system. For readers who are not familiar with the Kimball approach, we begin with a brief…


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


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…


SQL Server virtualisation improvements with SLAT in Intel and AMD

Recently I had query around documentation that discusses the benefits of running SQL Server in a virtualised environment on modern hardware with SLAT or second level address translation. The below graph shows that (see the solid red line) the relative throughput for hardware with SLAT & Windows Server 2008 R2 (required for SLAT support) degrades…


Whitepaper: High Availability with SQL Server 2008

This white paper describes the technologies available in SQL Server 2008 that can be used as part of a high-availability strategy to protect critical data. As well as describing the technologies in detail, the white paper also discusses the various causes of downtime and data loss, and how to evaluate and balance requirements and limitations…