Databases

The latest News and Information on Databases and related technologies.

Choose the right time series database | Aiven Info Bytes

Aug 16, 2021 By Aiven In Aiven

You have a load of time-stamped data coming in and you realize you need a time series database. But which one should you choose? Watch the video to find out! ABOUT AIVEN We help organizations fuel the continuous innovation needed to create awesome, data-intensive applications by using the leading open source technologies. After building expertise managing mission-critical data infrastructure for companies like F-Secure and Nokia, Aiven’s founders noticed that cloud adoption was increasing but infrastructure solutions were either proprietary or difficult to translate into business results.

View Video

Aiven

Read more about Choose the right time series database | Aiven Info Bytes

Visibility Into Distributed Availability Groups With SQL Sentry

Aug 12, 2021 By Roan Urquhart In SolarWinds

I began my career as an associate software development engineer in June of 2020, and during my short time in the industry, I’ve had the opportunity to build and troubleshoot continuous integration and continuous development (CI/CD) pipelines, work on many different technologies within several SolarWinds®, formerly SentryOne, products, and learn proper engineering practices.

Read Post

SolarWinds

Read more about Visibility Into Distributed Availability Groups With SQL Sentry

Why Observability Requires a Distributed Column Store

Aug 12, 2021 By Alex Vondrak In Honeycomb

Honeycomb is known for its incredibly fast performance: you can sift through billions of rows, comparing high-cardinality data across thousands of fields, and get fast answers to your queries. And none of that is possible without our purpose-built distributed column store. This post is an introduction to what a distributed column store is, how it functions, and why a distributed column store is a fundamental requirement for achieving observability.

Read Post

Honeycomb

Read more about Why Observability Requires a Distributed Column Store

How to Troubleshoot Apache Cassandra Performance Using Metrics and Logs in Debugging

Aug 12, 2021 By Scott Fitzpatrick In Sumo Logic

In the era of data abundance, there exists a significant need for database systems that can effectively manage large quantities of data. For certain types of applications, an oft-considered option is Apache Cassandra. Like any other piece of software, however, Cassandra has issues that could potentially impact performance. When this happens, it’s critical to know where to look and what to look for in the effort to quickly restore service to an acceptable level.

Read Post

Sumo Logic

Read more about How to Troubleshoot Apache Cassandra Performance Using Metrics and Logs in Debugging

Exploring Your Data Universe

Aug 10, 2021 By John Morehouse In SolarWinds

You can learn a lot about an organization by looking at their data. For example, if I see “LoanToValue” (LTV) or “CollateralValue,” I could surmise they deal with financial data—specifically loans—in some fashion. Developers and database administrators with domain knowledge about the intrinsic meaning of the data are precious friends. These individuals understand the meaning behind the data and how it works within the applications of the organization.

Read Post

SolarWinds

Read more about Exploring Your Data Universe

What is time series data? | Aiven Info Bytes

Aug 6, 2021 By Aiven In Aiven

You might be wondering, “What’s so special about time series data? Why do I need it?” When you start to look at the amount of data produced in our lives in just a single day, the need for a new database model soon becomes clear.

View Video

Aiven

Read more about What is time series data? | Aiven Info Bytes

Compliance in your Database DevOps pipeline - continuous classification with SQL Data Catalog

Aug 5, 2021 By Redgate In Redgate

Keeping classifications up to date across a constantly evolving structured data landscape is a difficult task, however it can become part of your DevOps process instead of simply offering further red tape to your development teams. Join Chris Unwin, a solution engineer at Redgate Software, to see how you can include SQL Data Catalog within your upstream DevOps process so that nothing in your Production environments is ever without classification.

View Video

Redgate

Read more about Compliance in your Database DevOps pipeline - continuous classification with SQL Data Catalog

Generating DDL Statements to Recreate Single Objects

Aug 5, 2021 By Monica Rathbun In SolarWinds

Every database administrator (DBA) is—first and foremost—human. And everyone makes mistakes. It’s not the absence of mistakes but rather how you prepare for those mistakes that makes you a great DBA. Luckily, there are many ways to prepare for those mishaps, whether the errors are made by you or someone else on your team. One commonly made mistake is to drop an object in a database or accidentally delete data.

Read Post

SolarWinds

Read more about Generating DDL Statements to Recreate Single Objects

A Complete Guide of Database Monitoring

Aug 4, 2021 By Antonia Shehova In VirtualMetric

A database is a collection of organized information for easy access and management. Computer databases generally consist of aggregated data or files that contain information about customers, transactions, or inventories. Regular monitoring of the database’s performance is necessary to ensure that it is running properly and to detect issues as they arise. Here is a short database monitoring guide that can assist you in choosing the right tools.

Read Post

VirtualMetric

Read more about A Complete Guide of Database Monitoring

A DBA's Perspective: What Is DevOps?

Aug 4, 2021 By Monica Rathbun In SolarWinds

If you’ve worked in IT in recent years, you’re no doubt familiar with the term “DevOps.” Accelerating the pace of development and faster delivery of new features is the goal. DevOps involves integrating the development life cycle with Agile methodology. DevOps practices applied to database operations is now commonly referred to as DataOps.

Read Post