Tag: database management

author:

Database

Five Must-dos of Database Performance Management

June 19, 2018

Here is an interesting article from my colleague Joe Kim, in which he explores database performance management. Databases are complex, multifaceted, and vital to the health of every agency. They are the heart of every data center and arguably one of the most important …


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 …


Video

SolarWinds Lab Episode 65: Orion Database Maintenance

May 16, 2018

In this episode, Head Geeks Thomas LaRock and Destiny Bertucci will explore the exciting world of database maintenance for your Orion installations. Back to Video Archive Episode Transcript Hello and welcome to this edition of SolarWinds Lab, where Destiny and I are going to …


author:

Database

The Future is Always Bright

December 15, 2017

In my last couple of posts, I’ve tried to paint a picture of the past and present of database management and monitoring. We’ve seen that good database performance has everything to do with knowledge, which, as we all know, is power. In our case, …


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 …