Denny Cherry

Owner and Principal Consultant,
Denny Cherry & Associates

Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. His areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2014, including the Microsoft Certified Master, plus Microsoft Windows Server (NT4 - 2012 R2), Microsoft Cluster Services (2000-2012 R2), and Microsoft Load Balancing Services (2000-2012 R2), and he's been a Microsoft MVP for several years. He also has extensive experience in the use of EMC Navispear, EMC PowerPath, HP/Compaq SmartStart, HP/Compaq RAID Utilities, and EMC DRU, and he is both an EMC expert, and a VMWare vEXPERT. Cherry has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies. Twitter: @mrdenny

SQL Server Backup Encryption 3
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
Sep 15, 2016

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
Jul 6, 2016

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More

Sponsored Introduction Continue on to (or wait seconds) ×