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 2
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.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Feb 25, 2015
Commentary

Data Profiling to the Rescue by Pushing Metadata Boundaries

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....More
Jan 22, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....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) ×