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 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
New Power BI Designer unifies the “power” tools
Jun 3, 2015
Article

Power BI Preview Gaining Market Momentum

As summer nears, the Power BI Preview is making bigger waves with every weekly release. Popular data sources and a plethora of Power BI Designer enhancements are being released at light speed pace. Check out the highlights on what has been released and what we might see next....More
Evolution of SQL Server continues
Jun 3, 2015
Article

What is Coming in SQL Server 2016 for Business Intelligence 1

Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades for business intelligence in numerous presentations at both //build and Ignite conferences....More
May 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 25: Final Remarks on Backups

In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage database backups against AlwaysOn Availability Group databases. Most of the information I’ve provided was pretty basic or elementary – along with some additional guidelines for things to watch out for when managing backups. Which is to say that backups are never something you can simply take for granted and they’re never something you just take lightly....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) ×