See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
All things Data Related....
On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data
database consolidation appliance
Fast Track DW
HP Database Consolidation Appliance
master data management
Master Data Services
multi server management
reporting services integration
Service Pack 2
sharepoint 2010 integration
SQL Server 2005
SQL Server 2008
SQL Server 2008 R2
sql server 2008 r2 free training
SQL Server 2012
SQL Server 2014
sql server as service
SQL Server Migration
Tips & Tricks
Windows Server 2008 R2
Windows Server 2012
Browse by Tags
All things Data Related....
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: http://msdn.microsoft.com/en-us/library/dn673538.aspx In-Memory OLTP allows users to move...
29 Apr 2014
SQL Server 2014 Database as a Service Whitepaper
Database as a Service Reference Architecture Guide: SQL Server 2014 http://www.microsoft.com/en-us/download/confirmation.aspx?id=42321 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...
16 Apr 2014
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...
22 Nov 2010
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...
13 Jul 2011
SQL Server 2008 Clustering White Paper
This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for...
6 Aug 2009
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...
12 Oct 2010
Whitepaper: SQL Server 2008 Management Data Warehouse
A best practices whitepaper was recently released discussing the SQL Server 2008 Management Data Warehouse feature. It can be accessed at: http://msdn.microsoft.com/en-us/library/dd939169.aspx
22 Jul 2009
Whitepaper: Consolidation Using SQL Server 2008
Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server instances and databases, in their organization. A consolidation effort is a complex task that requires information, a detailed plan and timeline for success, and a strategy...
29 Oct 2009
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:/...
13 Aug 2011
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...
13 Jun 2011
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...
29 Oct 2009
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...
16 Jun 2010
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...
12 Nov 2010
© 2014 Microsoft Corporation.
Privacy & Cookies