Denny Cherry

Denny
Cherry

Denny Cherry has more than a decade of experience managing SQL Server and is currently the senior DBA at Phreesia. He is a Microsoft MVP and holds several Microsoft certifications, including being an MCM.

Articles
Encryption
SQL Server Backup Encryption
When used properly, database backup encryption is a great way to protect database backups from being viewed by unauthorized people.
VMware High Availability in SQL Server
When VMware's vSphere platform is configured within a cluster at the host level, vSphere provides a certain degree of high availability, without any high availability configurations within the guest OS or SQL Server.
Using Solid State Disks in SQL Server Storage Solutions
When you use solid state disks (SSDs), you need to change the way you think about designing storage for production SQL Server machines.
7 Considerations for Server Consolidations
Although consolidating databases on a single server might seem like an easy task, it typically isn't. Here are seven considerations to keep in mind when you're preparing for a consolidation.
database word cloud
Upgrading Clusters to SQL Server 2012 When AlwaysOn Availability Groups Will Be Used
When upgrading a SQL Server 2008 R2 (or earlier) cluster to SQL Server 2012, there's an additional decision that needs to be made ahead of time if you'll be using SQL Server 2012's new AlwaysOn Availability Groups.
puzzle pieces and red computer mouse
Query Performance Tuning 2
Performance tuning is half science and half art form. Learn about the science half of the tuning process.
slow yellow road sign on tree in tropics
Troubleshooting Slow Servers 1
Missing indexes, an inadequate storage I/O subsystem, or a slow network are only some of the possible reasons why a SQL Server database engine might slow down, which is why finding the true cause of a performance bottleneck is vital.
Optimizing SQL Server Performance in a Virtual Environment
Running SQL Server on virtual machines has become a common practice. Here are seven tips for achieving optimal performance when running SQL Server on a VMware vSphere or Microsoft Hyper-V platform.
Synchronizing Disparate Data with Master Data Services
Although setting up SQL Server 2008 R2’s Master Data Services (MDS) is very complex, MDS can provide a robust platform for synchronizing data between disparate systems.
Configuring SQL Service Broker
Six little query types—that's all it takes to configure SQL Server Service Broker to take advantage of asynchronous data processing. This technique lets you build applications that don't require an immediate response to an executed command. We'll show you how to make a little T-SQL go a long way.
Configuring SQL Server Service Broker
Six query types—that's all it takes to configure Service Broker to take advantage of asynchronous data processing. This technique lets you build applications that don't require an immediate response to an executed command. I'll show you how to make a little T-SQL go a long way.
woman reaching for folders in the sky
SQL Server Storage in the Virtual World
No matter whether you're going to use Microsoft Hyper-V or VMware vSphere, knowing about your storage options can help you determine which one provides storage access at the right speed at the lowest possible cost with the least administrative overhead.
Upgrading a SQL Server 2005 Cluster to a SQL Server 2008 7
Minimize downtime when patching clusters by upgrading your SQL Server 2005 clusters to SQL Server 2008 to take advantage of its rolling upgrade functionality.
Set Up a SQL Server 2008 Cluster 4
Add high-availability to your SQL Server 2008 environment by following these steps to configure a Windows Server 2008 cluster and install SQL Server 2008 instances on the cluster nodes.
computer disk with data in background
Configuring Storage for Your SQL Server Environment 4
What you need to know about properly configuring your storage resources, and the storage solutions that work best with SQL Server.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Fork in walking path
Aug 28, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 2: Putting AlwaysOn into Context

Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
start here sign
Aug 26, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 1: Introduction

While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
Man deciding which door to choose
Aug 15, 2014
Sponsored

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×