Databases Archives - Software Reviews, Opinions, and Tips

How to Migrate a SQL Server Database to Azure

May 27, 2022

For many organizations who traditionally had to adopt expensive and usually relatively inflexible on-site database solutions, the increasing adoption of database-as-a-service (DBaaS) providers is a welcome alternative, as DBaaS offers a flexible, cloud-based database option through subscription services. Among DBaaS platforms, Microsoft Azure® SQL Database has become a go-to option for organizations hoping to move … Read more How to Migrate a SQL Server Database to Azure

4 Leading Database Certifications for Database Administrators in 2022

February 14, 2022

As a database administrator (DBA), you need to demonstrate your skills on a daily basis. However, if you have no formal training or certification, it can be challenging to land a new job or achieve an internal promotion. Fortunately, there are various highly-regarded database certifications for the leading databases. Whether you work primarily with SQL … Read more 4 Leading Database Certifications for Database Administrators in 2022

SQL Server – Query plan was not collected

February 11, 2022

Description from The SentryOne community Why was a query plan not collected? SQL Sentry uses a complex algorithm to perform matching of cached execution plans from SQL Server to Top SQL events. This article describes some of the more common reasons that a match may not have been found for a specific batch or statement. … Read more SQL Server – Query plan was not collected

Issues with Performance Counter Collection

February 10, 2022

Description from The SentryOne community One of the things we’ve come to understand in our dealings with the Windows operating system as it relates to performance monitoring is that the performance counter system is very fragile. It doesn’t take much at all to set it off kilter and most of the time you won’t even … Read more Issues with Performance Counter Collection

Database Cloud Service Solutions

January 4, 2021

Database cloud services are becoming increasingly popular. This is because they offer a range of benefits, including improved innovation and agility, lower risks, and fewer costs. Once you’ve chosen your database cloud provider, you’ll have to consider how you should manage and monitor your cloud computing database. This guide provides a brief overview of what … Read more Database Cloud Service Solutions

Best PostgreSQL Tools for Queries, Migration, and GUI Administration

January 1, 2021

The PostgreSQL database is one of the most advanced databases available, which is why it’s essential for it to be appropriately managed and maintained. This guide reviews some of the most popular and well-regarded Postgres admin tools on the market, with particular consideration of the best PostgreSQL query tool, PostgreSQL migration tool, and Postgres GUI … Read more Best PostgreSQL Tools for Queries, Migration, and GUI Administration

Redis Cluster Management Tool

September 1, 2020

This guide will help you understand the basics of Redis and Redis cluster management, in addition to providing a list of the best Redis management tools. For those who don’t have time to read the full list, I believe SolarWinds^® Database Performance Monitor (DPM) tops the ranks as the most efficient, user-friendly, and sophisticated Redis manager available on the market. A 14-day free trial is available for download.

Amazon AWS Performance Testing – Complete Tool for AWS Performance Testing

September 1, 2020

Amazon Web Services (AWS) is a service that provides cloud computing, including computing services, storage and databases, networking, analytics, application services, IT management, deployment and developer tools, and mobile and IoT tools. The breadth of AWS is so wide, it’s been rapidly adopted in many enterprises. In fact, AWS is the leading provider of cloud computing services, owning about one-third of the market as of February 2020.

Cloud Database Management

August 31, 2020

Cloud computing is the driving force behind many successful services, because it offers businesses computing resources at scale. Database management can be an expensive and complicated operation, and many agile-minded teams aren’t satisfied with the slow progress of database development. That’s where cloud database management comes in. This guide outlines the basics of cloud database management and reveals how a cloud database management tool can help you achieve your goals.

NoSQL Database Comparison—Best and Most Popular NoSQL Databases

August 29, 2020

While traditional databases store their data in tabular relations, NoSQL databases, also known as non-SQL databases, do not. NoSQL databases were originally designed for modern web-scale databases but are now in widespread use in big data and real-time web applications. Commonly used data structures include graph, key-value, wide column, and document stores.