Newsletters




Rob Mandeville

Rob Mandeville

Rob Mandeville is a senior DBA at SolarWinds, experienced with major RDBMS vendor engines. Earning an MIS degree from Regis University, he was invited to join the teaching staff right after graduation where he taught database technologies for several years. He has worked in the technology, aerospace, and government industries supporting Oracle, SQL Server, DB2, MySQL, and PostgreSQL databases on Linux, Windows, and Unix systems. More recently, Mandeville has shifted his focus to database performance and evangelizing best practice performance tuning methods. Mandeville remains passionate about database technologies in general and performance in particular.

Articles by Rob Mandeville

How do we define database workload? Good question! I've researched many approaches to this question and still don't have a definitive answer or way to measure. Let's dive into some of the research and personal thoughts I've had around this topic.

Posted April 09, 2019

There are a lot of folks out there who make a living (many of them quite a good one) doing database performance tuning. Why? Tuning requires a high degree of knowledge and performance skill, is time-consuming, and means knowing the right diagnostics to collect when performance hits occur. Because of these and many other reasons, database performance experts thrive—and let's not forget about job security.

Posted February 08, 2019

As we enter a world of machine learning and data science, are there any gotchas or negatives? It sounds as if it is all sunshine and rainbows, but, as the title to this post alludes, there are.

Posted October 10, 2018

Shark attacks and ice cream sales follow the very same trajectory when charted. When ice cream sales go up, so do shark attacks. When ice cream sales decrease, shark attacks decrease. With a correlation coefficient of very close to 1, we can deduce that sharks like to attack after we've recently had ice cream!

Posted August 08, 2018

Our data capture and retention requirements continue to grow at a very fast rate, which brings new entrants in the SQL and NoSQL market all the time. However, not all data is created equal. Companies recognize that disparate data can and should be treated differently. That means the way we persist that data can be extremely varied. Now, enter applications that need to access all that data across a very heterogeneous landscape, and we get to the point where we're reinventing the data access wheel every time someone needs to spin up another application or introduce another data source.

Posted June 01, 2018

Moving to automation means many decisions and modifications will occur without human involvement. Alterations are likely to occur that are not to the benefit of the end user (we will not get this 100% right in its nascence). Data "owners" will need very good information about what was adjusted, when it changed, and whether it was ultimately good for the user experience. The right tools will be needed as uptime, resource consumption/capacity, and relative health become basic "pay-to-play" propositions managed by automation. As end user experience continues to trump all other concerns in the application world, taking the end user vantage point will be central to monitoring autonomous changes.

Posted April 12, 2018

Sponsors