http://www.sqlmag.com/authors/author/author/5022653/rss/5022653en-USFri, 25 May 2012 10:24:35 GMTFri, 25 May 2012 10:24:35 GMThttp://www.sqlmag.com/article/performancetuning/query-performance-tuning-142267
By Denny Cherry
Performance tuning is half science and half art form. Learn about the science half of the tuning process.]]>Denny CherryTue, 22 May 2012 11:27:00 GMThttp://www.sqlmag.com/article/performancetuning/query-performance-tuning-142267http://www.sqlmag.com/article/sql-server/slow-sql-server-troubleshooting-142367
By Denny Cherry
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.]]>Denny CherrySat, 21 Apr 2012 13:33:00 GMThttp://www.sqlmag.com/article/sql-server/slow-sql-server-troubleshooting-142367http://www.sqlmag.com/article/project-plan-virtualization-sql-server-2008-r2-89/server-virtualization/Seven tips for the vSphere and Hyper-V platforms-139669
By Denham Cherry
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.]]>Denham CherryMon, 25 Jul 2011 08:00:00 GMThttp://www.sqlmag.com/article/project-plan-virtualization-sql-server-2008-r2-89/server-virtualization/Seven tips for the vSphere and Hyper-V platforms-139669http://www.sqlmag.com/article/project-plan-dbadmin-sql-server-2008-r2-79/sql-server-2008-r2/master-data-services-129266
By Denny Cherry
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.]]>Denny CherryMon, 25 Apr 2011 12:39:00 GMThttp://www.sqlmag.com/article/project-plan-dbadmin-sql-server-2008-r2-79/sql-server-2008-r2/master-data-services-129266http://www.sqlmag.com/article/sql-server/-configuring-sql-service-broker
By Denny Cherry
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.]]>Denny CherryWed, 22 Dec 2010 10:19:00 GMThttp://www.sqlmag.com/article/sql-server/-configuring-sql-service-brokerhttp://www.sqlmag.com/article/sql-server/configuring-sql-server-service-broker
By Denny Cherry
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.]]>Denny CherryMon, 13 Dec 2010 11:23:00 GMThttp://www.sqlmag.com/article/sql-server/configuring-sql-server-service-brokerhttp://www.sqlmag.com/article/virtualization2/sql-server-storage-in-the-virtual-world
By Denny Cherry
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.]]>Denny CherryMon, 16 Aug 2010 00:01:00 GMThttp://www.sqlmag.com/article/virtualization2/sql-server-storage-in-the-virtual-worldhttp://www.sqlmag.com/article/project-plan-dbadmin-sql-server-2008-r2-79/clustering/upgrading-a-sql-server-2005-cluster-to-a-sql-server-2008
By Denny Cherry
Minimize downtime when patching clusters by upgrading your SQL Server 2005 clusters to SQL Server 2008 to take advantage of its rolling upgrade functionality.]]>Denny CherryTue, 08 Dec 2009 00:00:00 GMThttp://www.sqlmag.com/article/project-plan-dbadmin-sql-server-2008-r2-79/clustering/upgrading-a-sql-server-2005-cluster-to-a-sql-server-2008http://www.sqlmag.com/article/project-plan-dbadmin-sql-server-2008-r2-79/configuration/set-up-a-sql-server-2008-cluster
By Denny Cherry
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.]]>Denny CherryTue, 25 Aug 2009 00:00:00 GMThttp://www.sqlmag.com/article/project-plan-dbadmin-sql-server-2008-r2-79/configuration/set-up-a-sql-server-2008-clusterhttp://www.sqlmag.com/article/iscsi/configuring-storage-for-your-sql-server-environment
By Denny Cherry
What you need to know about properly configuring your storage resources, and the storage solutions that work best with SQL Server.]]>Denny CherryTue, 10 Mar 2009 00:00:00 GMThttp://www.sqlmag.com/article/iscsi/configuring-storage-for-your-sql-server-environmenthttp://www.sqlmag.com/article/clustering/planning-and-implementing-a-sql-server-cluster
By Denny Cherry
Create a failover cluster to get SQL Server up and running quickly in the event of a hardware failure. ]]>Denny CherryMon, 24 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/clustering/planning-and-implementing-a-sql-server-clusterhttp://www.sqlmag.com/article/clustering/creating-mount-points
By Denny Cherry
If you have a very large SQL Server database and want to add drive space and I/O capacity to a drive, follow these instructions to creating a mount point within the drive.]]>Denny CherryThu, 25 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/clustering/creating-mount-points