Database Technologies

Find here Microsoft IT's early adopter experiences, best experiences, and lessons learned from our own deployments of Database Technologies solutions within our global enterprise. By leveraging our best practices, you can make decisions about how best to plan for, deploy, and manage Microsoft solutions in your own environment.

• Microsoft IT Builds a Field Dashboard to Improve Business and Marketing Operations (Published May 07, 2013)
• 343 Industries Gets New User Insights from Big Data in the Cloud (Published May 02, 2013)
• Using New Features found within SQL Server 2012 (Published October 02, 2012)
• Microsoft IT Uses SQL Server 2012 to Drive Broad Business Insight and Speed Application Time to Market (Published June 26, 2012)
• Designing & Maintaining SQL Server Transactional Replication Environments (Updated June 21, 2012)
• Disaster Recovery Using SQL Server 2012 AlwaysOn (Published May 31, 2012)
• SQL Data Compression Provides Improved Performance and Capacity Management (Published May 11, 2012)
• Inside Microsoft IT - Implementing Disaster Recovery in the Datacenter (Published April 23, 2012)
• How Microsoft IT Centralized Disaster Recovery in the Datacenter (Published April 13, 2012)
• IT Showcase On: Business Intelligence (BI) (Published December 12, 2011)
• Microsoft Cuts Costs and Improves Access to Information with Enhanced Data Warehouse (Published December 12, 2011)
• How Microsoft IT Centralized Disaster Recovery (Published December 12, 2011)
• Developing a Strategy to Simplify Planning and Improve Performance and Reliability (Updated September 22, 2011)
• Protecting Server Data with System Center Data Protection Manager 2010 (Published June 28, 2011)
• How Microsoft IT Implemented Disaster Recovery in the Datacenter (Published June 09, 2011)
• Microsoft Deploys Innovative Solution That Reports Near-Real-Time Data (Published June 07, 2011)
• Microsoft IT CIO Office Scorecards – Delivering Dashboards from KPI Catalog to the Masses (Video published May 04, 2011)
• Creating Scorecards to Report Organizational Rhythm of Business (Published April 01, 2011)
• Microsoft IT CIO Office Scorecards – Delivering Dashboards from KPI Catalog to the Masses (IT Pro Webcast published March 22, 2011)
• Delivering Data as a Service from the SQL Azure (Cloud) and self-service BI at Microsoft (Published March 01, 2011)
• Realizing Performance Improvements Using 64-bit SQL Server 2008 (Published February 25, 2011)
• Delivering Revenue Reports Faster and Reducing Costs by Automating Business Rules (Published December 10, 2010)
• Enterprise Scale Clickstream Analysis Running on SQL Server 2008 R2 Parallel Data Warehouse (Published December 10, 2010)
• Reducing the Costs of Enterprise Data Warehouse Creation and Data Acquisition (Published November 15, 2010)
• Deploying SQL Server 2008 R2 Parallel Data Warehouse at Microsoft (Published November 05, 2010)
• Microsoft IT Accelerates Migration of Microsoft.com to the Windows Azure Platform (Published September 02, 2010)
• Automated Data Quality Checks Using SQL Server and Visual Studio (Published June 29, 2010)
• Microsoft IT's Top 10 SQL Server 2008 Features (Published June 11, 2010)
• Enterprise Data Warehouse: A Patterns Approach to Data Integration (Published May 26, 2010)
• Upgrading a 6.5-Terabyte SAP ERP SQL Server Database to Support Microsoft Worldwide Operations (Published April 21, 2009)
• SQL Server Consolidation at Microsoft (Updated April 02, 2009)
• How Microsoft IT Upgraded a Multi-Terabyte Database from Yukon to Katmai (Published August 20, 2008)
• How Microsoft IT Leverages SQL Server 2008 SSIS Data Flow Enhancements (Published May 26, 2008)
• Managing Line of Business Applications using Microsoft System Center Operations Manager 2007 (Published March 19, 2007)