Thomas LaRock is a Head Geek at SolarWinds and a Microsoft® Certified Master, Microsoft Data Platform MVP, VMware® vExpert, and former Microsoft Certified Trainer. He has over 20 years’ experience in the IT industry as a programmer, developer, analyst, and database administrator. LaRock has spent much of his career focused on data and database administration, which led to his being chosen as a Technical Evangelist for Confio Software in 2010, where his research and experience helped to create the initial versions of the software now known as SolarWinds® Database Performance Analyzer. LaRock has served on the board of directors for the Professional Association for SQL Server® (PASS), and is an avid blogger, author, and technical reviewer for numerous books about SQL Server management. He now focuses on working with customers to help resolve problems and answer questions regarding database performance tuning and virtualization for SQL Server, Oracle®, MySQL®, SAP®, and DB2®. He’s made it his mission to give IT and data professionals longer weekends.

author:

Database

VMDK versus RDM: Which One Do I Need for SQL Server?

March 26, 2014

When it comes to disk configuration options for virtualized servers running on VMware, you have two options: VMFS virtual file-based disk (VMDK) or a raw device mapping (RDM). Which one do you need? VMware has published reports that suggest that, with vSphere 5.1, there …


author:

Database

Hardware or Code? SQL Server Performance Examined

January 24, 2014

CPUs are running faster now than ever before, solid-state drives are replacing spinning disks, and database servers have terabytes of RAM. Because these resources are plentiful and increasingly affordable, it can seem tempting to solve database performance issues with hardware. But consider this example: …



author:

Database

Connect to Windows Azure Virtual Machine Using SSMS

December 18, 2013

In 2013, Microsoft made it available for customers to utilize virtual machines running in Windows Azure. This allowed customers to run an on-premises version of SQL Server, but have the instance hosted in the cloud. The natural question then became, “How do I connect …



author:

Database

5 Things You Didn’t Know About SQL Agent

November 27, 2013

Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent. The purpose of the SQL Agent is to serve as a job scheduler. Many experienced DBAs use jobs running inside the SQL Agent to perform routine tasks such …



author:

Database

Improve SQL Server Performance by Looking at Plan Cache (Part 3)

October 3, 2013

You can use the information in the SQL Server plan cache to research performance issues and investigate opportunities for performance improvement. In this three-part article series, we’ve examined several important opportunities you have in mining information from the plan cache, including eliminating single-use plans …