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

Databases 101: Choosing the Right Database

August 20, 2018

In my last post, we talked about the different types of databases available on the market for you to choose from. With over 300 options, it is hard to know which one is the right database. Today, we are going to help you with …


author:

Database

Five Common Problems with SQL Server

July 12, 2018

I’ve been working with SQL Server since what seems like forever ++1. The truth is I haven’t been a production DBA in more than 6 years (I work in marketing now, in case you didn’t know). That means I will soon hit a point in …


author:

Database

Six Ways to Protect your Database Backups

June 15, 2018

I often see forum posts from accidental administrators who want to know how to recover data without a backup. The short answer is, “Now is a good time to work on your resume.” The longer answer is, “Recreate all your data.” But the truth …


author:

Database

Be Responsive and Responsible

June 13, 2018

Over the years, I’ve read more than a few articles about the qualities that are found in the best administrators. These articles focus on soft skills, but sometimes will list hard skills as well. In all those years, and in all those articles, I …


author:

Database

The Future Isn’t in Databases, But in the Data

June 11, 2018

In the past year I have earned a couple of certificates from the Microsoft Professional Program. One certificate was in Data Science, the other in Big Data. I’m currently working on a third certificate, this one in Artificial Intelligence.   You might be wondering …


author:

Database

Collecting and Alerting on Deadlocks for SQL Server

December 7, 2016

SolarWinds DPA can collect a count of the number of deadlocks to be displayed as a resource graph. For Ignite versions prior to 8.2, you can update two files in order to start collecting the number of deadlocks. Enabling DPA to Collect Deadlock Information …


author:

Database

Why DPA Uses SQL Server Trace Flag 2861 and Zero Cost Plans

December 7, 2016

About zero cost plans in SQL Server OK, first thing first, what is a “zero cost plan” in SQL Server?  I did some digging around and found the following links, which I would encourage you to read before continuing with this post: http://msdn.microsoft.com/en-us/library/ms181055.aspx http://support.microsoft.com/kb/325607 …


author:

Database Systems

Using VSAN to Maximize Database Performance

September 28, 2015

Earlier this year I had the opportunity to speak at VMWorld in San Francisco. The session title was Using Virtual SAN to Maximize Database Performance, and in that session I spent time focusing on performance as well as recovery. Why would recovery be a …


author:

Networks Systems

Learning to Pivot

September 18, 2015

The role of information technology inside of corporations is not new; it has existed for decades. With each passing year we see acceleration in the speed and complexity of changes to our roles as IT professionals. Industries as a whole tend to resist change. …