White Papers

Explore our library of technical white papers. If you or your organization would be interested in submitting a white paper for publication, please contact us.

White Papers Icon

Data Catalogs – the case for SQL Server

December 2018

Data Catalogs – the case for SQL Server

Redgate

In the wake of new legislation, the way organizations handle personal data is under scrutiny like never before. This whitepaper discusses the importance of data catalogs, the benefits they bring to a business, and the capabilities and features required. It also outlines current and upcoming data privacy regulations which a data catalog can help you comply with.

Access White Paper

Enterprise‐Grade Data Management for Midsize Organizations

December 2018

Enterprise‐Grade Data Management for Midsize Organizations

IDC & ZAP

Download IDC’s white paper on the benefits of data management automation. It examines three key data challenges faced by organizations and five technologies and strategies that deliver better data management and analytics. Plus, three case studies.

Access White Paper

The Benefits of Adopting Compliant Database DevOps at PASS

November 2018

The Benefits of Adopting Compliant Database DevOps at PASS

Redgate

In the lead up to the General Data Protection Regulation (GDPR) coming into effect, PASS and Redgate teamed up to introduce new DevOps processes and ensure that the PASS database was compliant with these new regulations. Find out how together, they overcame the series of challenges presented by GDPR.

Access White Paper

The ROI of Database DevOps

October 2018

The ROI of Database DevOps

Redgate

With DevOps moving into the mainstream and more and more companies adopting it, the spotlight is turning to the database. If this last blocker in the process can be included, changes can be delivered faster, and errors when those changes are deployed can be avoided.

Access White Paper

Compliant Database DevOps and the role of DevSecOps

September 2018

Compliant Database DevOps and the role of DevSecOps

Redgate

This whitepaper details how and why DevOps can be applied to the database, and then outlines the steps necessary to include it in DevSecOps.

Access White Paper

A Zombie’s Survival Guide in a Changing Database World

August 2018

A Zombie’s Survival Guide in a Changing Database World

Quest

End the walking dead! Get survival strategies for managing cross-platform database environments.

Access White Paper

Five Reasons Your SQL Server is Slow

August 2018

Five Reasons Your SQL Server is Slow

IDERA

Learn the 5 most common things that cause your SQL Server to run more slowly than it should. These are issues that, once addressed, will allow your SQL Server instances to run faster. Best of all, very little work is required to fix them!

Access White Paper

The Top Guide to Learning Powershell

July 2018

The Top Guide to Learning Powershell

IDERA

Learn how to start using PowerShell with this in depth ebook. It covers almost any question you may have regarding PowerShell and its applications. This guide to learning PowerShell presents a wide range of topics which will leave you with an abundance of knowledge.

Access White Paper

Winning!

May 2018

Winning!

Quest

What’s the secret to DBA success? The playbook for optimized SQL Server management. Get your free copy today. And get ready to earn the recognition you deserve.

Access White Paper

Data Preparation

May 2018

Data Preparation

BARC

The goal of data preparation is to support business analysts and data scientists by preparing different kinds of data for their analytical purposes. This study is based on an empirical survey on the use of technologies for data preparation. 695 people worldwide completed the online survey in March and April 2017, answering questions on the drivers, use cases, benefits and challenges of data preparation.

Access White Paper

BI and Data Management In The Cloud

May 2018

BI and Data Management In The Cloud

BARC

This study examines current attitudes, issues and trends relating to the use of business intelligence and data management technologies in the cloud. We look at the drivers, benefits and challenges companies face when implementing cloud BI, as well as some of the common components, use cases and tasks seen in cloud BI deployments. The report also reveals the role vendors are playing in cloud BI, and the types of infrastructures organizations are choosing.

Access White Paper

Hadoop and Data Lakes

May 2018

Hadoop and Data Lakes

BARC

Answers and insights into the questions surrounding these trending technologies. Based on a 2016 survey of over 380 decision-makers, this report explores the current status of Hadoop and data lakes in general, as well as real experiences from Hadoop use cases across the globe.

Access White Paper

Big Data and Information Security

May 2018

Big Data and Information Security

BARC

Based on a 2016 survey of over 330 decision-makers, this study assesses the importance, status quo, developments, benefits and challenges of big data security analytics initiatives. In particular, it examines the burgeoning security analytics solutions market, current deployment levels of big data security analytics solutions and the potential benefits of big data security analytics.

Access White Paper

SQL Server in Simple Words

May 2018

SQL Server in Simple Words

IDERA

SQL Server Management Studio (SSMS) includes several features and capabilities that can help DBAs improve security, debug SQL code, and identify potential locking issues, among other things.

Access White Paper

DBA Juggling Act

April 2018

DBA Juggling Act

Quest

Managing database performance across platforms is tricky. But Quest is changing that with easy expert tips.

Access White Paper

SentryOne Tech Brief

April 2018

SentryOne Tech Brief

SentryOne

Learn how to optimize SSAS performance, including enhanced performance analysis for SSAS Tabular instances.

Access White Paper

Object Storage: The Key to Modern Data Protection

March 2018

Object Storage: The Key to Modern Data Protection

Cloudian

In this report, learn about the science of data protection and the advantages an object storage system provides in keeping your data safe, easily recoverable, and highly available.

Access White Paper

Continuous Delivery Whitepaper

March 2018

Continuous Delivery Whitepaper

Redgate

Continuous integration and automated deployments become possible with database DevOps, paving the way to a complete continuous delivery process. Importantly, the biggest roadblock isn’t the hardware or software you require, it’s the development practices and strategies that need to change to accommodate it. This whitepaper gives some practical tips to introducing continuous delivery and including the database in your DevOps journey.

Access White Paper

SSIS Data Integration Lifecycle Management

February 2018

SSIS Data Integration Lifecycle Management

Enterprise Data & Analytics

In order to practice DevOps with SSIS, enterprises must be able to easily access code configurations and process metadata. SSIS Catalog Browser was designed to surface configurations and metadata stored in the SSIS Catalog. The goal? Present all the data on a single surface. Operations professionals need not know “where to dig” to find configurations and process metadata; they need only know how to expand nodes in a tree view control. The remainder of this whitepaper compares and contrasts the viewer that ships with SSIS and SSIS Catalog Browser, a free utility that is part of the DILM Suite.

Access White Paper

How to Become a SQL Server Database Administrator

February 2018

How to Become a SQL Server Database Administrator

IDERA

This whitepaper discusses the details about how to become a SQL server database administrator and how to acquire the necessary skills for that job.

Access White Paper

The 2018 State of Database DevOps

January 2018

The 2018 State of Database DevOps

Redgate

In the latest survey, over 700 IT professionals across a range of sectors, in organizations of every size around the globe were asked about their plans to adopt DevOps, how they thought the database fitted into the picture, and what they thought the biggest challenges were. Download the latest survey and you’ll discover a wealth of facts including: the main drivers for automating the delivery of database changes, the challenges of integrating database changes into a DevOps process, and the impact database DevOps has on regulatory and compliance requirements.

Access White Paper

The Four Roadblocks of Data Preparation

January 2018

The Four Roadblocks of Data Preparation

Quest

Ever wish you could automate data preparation, so you could focus more on data analysis? In this complimentary e-book, you’ll learn how to make those frustrating, manual tasks a distant memory. With our expert’s tips, you’ll quickly overcome the barriers to rapid data analysis, including: an overwhelming amount of data sources, too many tools, data governance and compliance issues, and bottlenecks caused by tedious, outdated processes.

Access White Paper

DBA Playbook for Optimized SQL Server Management

January 2018

DBA Playbook for Optimized SQL Server Management

Quest

Designed to help DBAs like you put in place strategies for focusing methodically on the hardware, software, workflow and cultural issues within your control.

Access White Paper

Tools for the Evolving Database Administrator

November 2017

Tools for the Evolving Database Administrator

Quest

Learn about the history of the database, a snapshot of the current database market, and the priorities of today's DBAs as they manage increasing numbers of different kinds of database environments.

Access White Paper

SQL Server Data Governance Report 2017

November 2017

SQL Server Data Governance Report 2017

Redgate

Read this free 22-page report from Redgate Software to learn how over 500 SQL Server professionals handle the challenges of data governance. It covers the challenges data professionals face, top business blockers, the role of regulation, including GDPR, and how DevOps and tooling can help. Read it now.

Access White Paper

Solving database deployments with Database DevOps

October 2017

Solving database deployments with Database DevOps

Redgate

This speed of delivery is critical to business success, as it allows you to quickly respond to the needs of your business and customers and keep up with the competition. By extending DevOps practices to your SQL Server databases you can start to gain consistency across your applications and databases, increase efficiencies through your development and operations teams and remove that last bottleneck.

Access White Paper

SQL Server Database Replication

August 2017

SQL Server Database Replication

QUEST

SharePlex, the golden standard for database replication from Quest, helps minimize planned and unplanned outages for your SQL Server databases through battle-tested near real-time data integration.

Access White Paper

The Build vs Buy Challenge: Insight into a Hybrid Approach

July 2017

The Build vs Buy Challenge: Insight into a Hybrid Approach

Melissa

Maintaining high quality data is essential for operational efficiency and meaningful analytics. But, when dealing with multiple sources of data, data quality becomes complex, so you need to know when you should build a custom data quality tools over canned solutions. Read our whitepaper for more insight.

Access White Paper

DBA PLAYBOOK FOR OPTIMIZED SQL SERVER MANAGEMENT

July 2017

DBA PLAYBOOK FOR OPTIMIZED SQL SERVER MANAGEMENT

Quest

This essential DBA playbook is designed to help DBAs like you put in place strategies for focusing methodically on the hardware, software, and workflow issues within your control. Learn more!

Access White Paper

10 SQL PERFORMANCE TIPS

May 2017

10 SQL PERFORMANCE TIPS

Quest

Performance optimization on SQL Server can be challenging. We're here to help with these tips.

Access White Paper

2-TIER VS 3-TIER APPLICATION ARCHITECTURE

April 2017

2-TIER VS 3-TIER APPLICATION ARCHITECTURE

Nitrosphere

Your choice of application architecture can directly impact end user performance. Learn key criteria for building applications optimized for performance across disparate networks.

Access White Paper

THE GUIDE TO LEARNING POWERSHELL

April 2017

THE GUIDE TO LEARNING POWERSHELL

IDERA

This 3-part eBook introduces you to the PowerShell console and explains how to configure it, including font colors and sizes, editing and display options. Plus, deep-dive into into defining function parameters, creating new functions, and adding help to your functions.

Access White Paper

Quest’s Spotlight performance management driven by Azure SQL Database

March 2017

Quest’s Spotlight performance management driven by Azure SQL Database

Quest

With Spotlight, using Microsoft Azure and Azure SQL Database, SQL Server database administrators can monitor, detect, diagnose, and provide a way to resolve performance issues in SQL Server, whether they’re sitting at their desks or are working from home.

Access White Paper

THE STATE OF DATABASE DEVOPS REPORT

January 2017

THE STATE OF DATABASE DEVOPS REPORT

Redgate

As software teams face pressure to speed up delivery, DevOps is gaining momentum. But how many extend DevOps practices to database development? Read the results of a survey of 1000 SQL Server users.

Access White Paper

Data Masking: What You Need to Know

October 2016

Data Masking: What You Need to Know

NET2000

A paper focused on the practical issues involved in the preparation of de-identified HIPAA compliant databases. Included are specific worked examples of data masking practices which can assist with meeting the Safe Harbor data requirements.

Access White Paper

W.B. MASON PARTNERS WITH HPE

July 2016

W.B. MASON PARTNERS WITH HPE

HPE

Read how W.B. Mason embarked on an infrastructure transformation to support its business with HPE Superdome X running Microsoft Windows®.

Access White Paper

5 Reasons Your SQL Server is Slow

June 2016

5 Reasons Your SQL Server is Slow

IDERA

This white paper, authored by MCM Robert L Davis, is a guide to the 5 most common things that might be causing your SQL Server to run more slowly than it should. These are issues that, once addressed, will allow your SQL Server instances to run faster. Best of all, very little work is required to fix them.

Access White Paper

Shutting the Door on SQL Server 2005

March 2016

Shutting the Door on SQL Server 2005

KROLL ONTRACK

After a decade on the market, support for all versions of SQL Server 2005 is officially coming to an end on April 12, 2016. Are you prepared?

Access White Paper

The Real World of the Database Administrator: How DBAs Like You Are Managing Their Data.

February 2016

The Real World of the Database Administrator: How DBAs Like You Are Managing Their Data.

DELL

We joined forces with Unisphere Research and Database Trends and Applications to ask hundreds of DBAs some interesting questions ― and you’ve got to see their answers.

Access White Paper

Top 10 SQL Performance Booster with Your Own Hardware

November 2015

Top 10 SQL Performance Booster with Your Own Hardware

IDERA

A key component of maintaining successful applications is to stay ahead of performance requirements. This white paper provides a list of the Top 10 ways you can improve SQL Server performance with hardware you already own.

Access White Paper

The Essential DBA Playbook for Optimized SQL Server Management

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.

Access White Paper

5 DBA Mistakes That Can Cost You Your Job

August 2015

5 DBA Mistakes That Can Cost You Your Job

Idera

Everyone makes mistakes. Database Administrators (DBAs) are no exception to that rule. When DBAs make mistakes, they are often the ones who find it first and have to fix it. This whitepaper, authored by MCM Robert L Davis, is a cautionary guide to the most common mistakes that database administrators make that can cost them their jobs.

Access White Paper

In-Memory Analytics Versus Disk-Based OLAP Analytics & Blending the Two

July 2015

In-Memory Analytics Versus Disk-Based OLAP Analytics & Blending the Two

PYRAMID ANALYTICS

This paper explores the pros and cons of an in-memory analytics solution versus a multidimensional, disk-based, OLAP analytics solution, and the benefits of combining them in your environment.

Access White Paper

Demystify Tempdb Performance & Management

June 2015

Demystify Tempdb Performance & Management

Idera

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.

Access White Paper

Hadoop for Hybrid Cloud

April 2015

Hadoop for Hybrid Cloud

Hortonworks

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.

Access White Paper

Optimizing Microsoft SQL Server 2014 on Cisco UCS

April 2015

Optimizing Microsoft SQL Server 2014 on Cisco UCS

Cisco

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.

Access White Paper

Data Management and Analysis - Cisco and Microsoft: Optimal Infrastructure Strategies

February 2015

Data Management and Analysis - Cisco and Microsoft: Optimal Infrastructure Strategies

Cisco and Microsoft

Enterprises are seeking a simplified, integrated approach that provides efficient, flexible infrastructures that can be deployed, managed, moved to the cloud, and scaled as needed to support advanced applications and workloads. Working together, Cisco and Microsoft satisfy today’s data management demands by creating integrated infrastructures that provide support for a diverse set of applications and use cases, including big data, data management, large-scale data warehousing, and analytics backed by IT management and insights.

Access White Paper

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids