FILTER BY…
Resource Type:





Topic:







Product:













Welcome to the Resource Center

1-30 of 234 results
Infographic : Why Use SQL Diagnostic Manager?
Get excellent SQL Server performance with SQL Diagnostic Manager. Here's how.
Webcast : 4 Techniques to Manage SQL Server Sprawl
Too many servers and not enough time! SQL Server has so many features and options that managing just one server can be challeng...
Whitepaper : Why Your AlwaysOn Solution is Not Always On
This whitepaper is an intermediate guide for DBAs on avoiding pitfalls that can cause unexpected failures with AlwaysOn technologi...
Whitepaper : Troubleshooting Locking with DMVs
This whitepaper is an advanced guide for DBAs on the troubleshooting locking problems in SQL Server using Dynamic Management Views...
Whitepaper : Windows Azure SQL Data Sync
This white paper introduces you to SQL Data Sync and walks you through an example on how to setup a topology that keeps a local da...
Whitepaper : Performance Enhancements Made with SQL Server 2014
It is second to human nature to question and get the best out of everything. It is in our DNA to see how we can maximize on our cu...
Whitepaper : Moving SQL Server to a Virtual Platform
This whitepaper is a guide for DBAs on moving SQL Server from a physical environment to a virtual environment. Virtualization ...
Whitepaper : Windows Azure SQL Database Architecture
Read this white paper which discusses the internal architecture of Windows Azure SQL Database and some of the key concepts that SQ...
Whitepaper : Windows Azure SQL Reporting
Read this white paper which discusses Windows Azure SQL Reporting. This feature of the Azure platform allows you to manage and run...
Whitepaper : Top 10 SQL Performance Boosters with Your Own Hardware
A key component of maintaining successful applications is to stay ahead of performance requirements. The more an application is us...
Whitepaper : Demystify Tempdb Performance & Management
In this white paper, MCM Robert L Davis demystifies the best practices that work some of the time, but not all of the time, when i...
Whitepaper : SQL Server Statistics Primer
This white paper is an introductory guide for DBAs about SQL Server statistics. It covers how to use them, how to maintain them, a...
Whitepaper : Top 5 New Features of SQL Server 2014
SQL Server 2014 was released to manufacturing on April 1, 2014 and with this version, as well as past versions, Microsoft has intr...
Whitepaper : Introduction to Windows Azure SQL Database
As Microsoft continues to invest heavily in its Windows Azure platform, many DBAs and developers are beginning to understand one o...
Whitepaper : Essential Performance Tools for SQL Server DBAs
Optimizing SQL Server performance can be a daunting task. Especially so for an increasing number of reluctant DBAs faced with the ...
Whitepaper : Establishing and Setting Thresholds for a SQL Server Environment
This white paper is a guide for DBAs about determining the proper thresholds for monitoring a SQL Server environment.
Whitepaper : Solutions to the Most Common Methods of SQL Server Intrusion
Understanding how SQL Server can be infiltrated is the key to understanding how to prevent intrusions. Some of the common methods ...
Whitepaper : Reduce SQL Server Security Vulnerabilities with SQL Secure
Today, business is about data. Databases and the data they store are arguably the most valuable assets in any given enterprise. So...
Whitepaper : Top SQL Server Backup Mistakes (and How to Avoid Them)
You already know that backing up your SQL Server databases is essential to minimize data loss in the event of a failure. However, ...
Whitepaper : 5 DBA Mistakes That Can Cost You Your Job
Robert Davis reviews 5 mistakes that DBAs should avoid to protect data and their job.
Whitepaper : 5 Most Common Critical SQL Integrity Issues
A crucial part of managing SQL Server is performing regular integrity checks — but what do you do when corruption exists?
Whitepaper : How To Deal With An Inherited SQL Server
Your first week with a new SQL database can be daunting. Let Andy Warren walk you through best practices for prioritizing those fi...
Whitepaper : 3 Tips for Managing Large Numbers of SQL Server Jobs
This whitepaper is a guide for DBAs on managing and scheduling large numbers of SQL jobs across a SQL Server enterprise.
Whitepaper : Waiting on Waits
These days DBAs rely heavily on third-party tools to present information about performance and utilization in a graphical and very...
Whitepaper : 5 Reasons SQL Server Health Checks Are Life Savers
SQL Server Health Checks have garnered a great deal of notoriety over the last 5 years. What was originally a niche offering more ...
Whitepaper : 5 Reasons Your SQL Server is Slow
Robert Davis explores 5 reasons why your SQL Server may be slow and provides insights on how to fix them.
Whitepaper : Top 5 SQL Server Cluster Setup Mistakes
Windows Failover Clustering can keep your SQL Server databases online and your customers happy when hardware or operating system ...
Whitepaper : Security and Compliance Solutions for SOX and COBIT
Microsoft SQL Server database security guidelines are defined by the following tools and organizations: Center for Internet Secur...
Whitepaper : The SQL Server Security Threat - It's Closer Than You Think
As we’ve see over the past decade, database-related security breaches can’t be taken lightly. One of the greatest threats to datab...
Whitepaper : SQL Server Fragmentation Explained
As the data in Microsoft SQL Server tables changes their indexes change. Over time these indexes become fragmented. This fragmenta...