August 2015

The Essential DBA Playbook for Optimized SQL Server Management

Dell Software

Discover the essentials of optimizing SQL Server management in your organization. Learn how DBAs like you can put in place strategies for focusing methodically on the hardware, software, workflow and cultural issues within your control.

July 2015

Why HP platforms for BI with Microsoft SQL Server 2014


In the past, only large companies could afford the technology and infrastructure to implement data warehouses and business intelligence systems. Microsoft SQL Server 2014 and HP ProLiant servers have become the platforms of choice for many organizations to address these challenges.

June 2015

Demystify Tempdb Performance & Management


Learn how to provide the optimum balance between performance, reliability, and manageability. This Whitepaper covers best practices and tips to use, monitor, and configure tempdb.

April 2015

Hadoop for Hybrid Cloud


An increasing number of enterprises are either currently using or are planning to use cloud deployment models to expand their IT infrastructure. Organizations are looking for an open and flexible platform that enables them to deploy Big Data and Hadoop solutions on-premises, in the cloud and in a hybrid environment. This paper provides an introduction to hybrid clouds and outlines the requirements that enterprises need to consider as they migrate their big data architectures to a hybrid cloud deployment model with Hortonworks Data Platform, HDInsight and Azure.

April 2015

Optimizing Microsoft SQL Server 2014 on Cisco UCS


This white paper describes how Cisco UCS optimizes Microsoft SQL Server 2014 workloads. Cisco UCS’s advanced architecture provides the optimum platform for both physical and virtual SQL Server deployments. Cisco UCS enables you to simplify and standardize your SQL Server 2014 implementations as well increase performance, scalability, and availability.

March 2015

Performance Baselines and Benchmarks for Microsoft SQL Server

SQL Sentry

The challenges in collecting baselines can be daunting, but the benefits of having them are worth the time and energy. Discover why in this white paper by SQL Server MVP Kevin Kline.

February 2015

A Modern Data Architecture with Apache Hadoop


Get the full picture of how Hadoop can be integrated within your data center. See how Hadoop integrates with existing systems and how to query with familiar SQL tools.

January 2015

Go Beyond Basic Up/Down Monitoring

Dell Software

Microsoft Systems Center Operations Manager (SCOM) is great at telling you whether your server is healthy or not, but it doesn’t provide much beyond that. This white paper explores SQL Server monitoring available in SCOM as well as some of its limitations when it comes to really understanding and managing database performance. Then it shows you how to go beyond simple up/down monitoring with predictive performance diagnostics, providing best practices for monitoring and troubleshooting your SQL Server environment and maximizing your investment in SCOM.

December 2014

Troubleshooting SQL Server Wait Stats

SQL Sentry

SQL Server MVP Kevin Kline discusses the most common problems facing IT teams who focus their performance troubleshooting activities solely on wait statistics. This can serve as a useful and effective template for performance troubleshooting which you will be able to use over and over again whenever SQL Server performance is called into question.

October 2014

SQL Server Management Perfected

Dell Software

Organizations today are using multiple database platforms, embracing cloud technologies, and generating enormous volumes of data, and users have increasingly high expectations for availability and performance. This white-paper outlines a solution to help DBAs proactively find and address SQL Server performance issues, even as budgets tighten and IT environments grow in complexity.

August 2014

Cisco Unified Computing Systems: Meet the Challenges of Microsoft SQL Server Workloads


Optimization of Microsoft SQL Server workloads requires more than robust hardware capable of graceful performance under demanding conditions. This white paper provides an overview of the considerations that systems administrators and DBAs need to be familiar with when sizing, planning, and scaling modern SQL Server workloads and the unique advantages of the Cisco Unified Computing System in addressing these requirements.

July 2014

Top Ten Tips for Optimizing SQL Server Performance

Dell Software

This white paper by SQL Server experts Patrick O'Keeffe and Richard Douglas discusses 10 of the most important things you need know about SQL Server performance.

July 2014

SQL Server, SharePoint & Windows Alerts: A New Take on Alerting

SQL Sentry

This new white paper by SQL Server MVP Kevin Kline discusses how the basic alerting system included with SQL Server behaves. The white paper also shows how SQL Sentry's alerting functionality overcomes many of these limitations and those of many other alerting systems.