2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

Scalegrid

Wondering which databases are trending in 2019? Get the latest insights on MySQL , MongoDB , PostgreSQL , Redis , and many others to see which database management systems are most favored this year. SQL Databases. NoSQL Databases. NoSQL Database Use: 39.52%.

What is Greenplum Database? Intro to the Big Data Database

Scalegrid

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Reducing Your Database Hosting Costs: DigitalOcean vs. AWS vs. Azure

Scalegrid

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on their database hosting.

Azure 239

TiDB Dashboard: Easier Troubleshooting for Distributed Databases

DZone

It's challenging to troubleshoot issues in a distributed database because the information about the system is scattered in different machines. TiDB is an open-source, distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads.

Reducing Your Database Hosting Costs: DigitalOcean vs. AWS vs. Azure

High Scalability

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs.

Azure 235

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. MySQL on DigitalOcean is a natural fit, but what’s the best way to deploy your cloud database? higher throughput over DigitalOcean Managed Databases across all thread counts.

Comparing PostgreSQL DigitalOcean Performance & Pricing – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

ScaleGrid is a fully managed DBaaS that supports MySQL, PostgreSQL and Redis™, along with additional support for MongoDB® database and Greenplum® database. Along with many popular cloud providers, DigitalOcean also provides a Managed Databases service. So, which database service is right for your application? PostgreSQL is one of the fastest growing databases, and #4 database in the world by popularity.

2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence

High Scalability

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular?

Millions of tiny databases

The Morning Paper

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information.

Making it Easier to Manage a Production PostgreSQL Database

Scalegrid

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. If you are planning to build a large 24/7 operation, the ability to easily operate the database once it is in production becomes a very important factor. This is a standard built-in feature in many of the new NoSQL databases, and PostgreSQL would do great to take a leaf out of their books when it comes to operations.

2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

High Scalability

Wondering which databases are trending in 2019 ? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Get the latest insights on MySQL , MongoDB , PostgreSQL , Redis , and many others to see which database management systems are most favored this year.

Optimizing Database Performance and Efficiency

DZone

It's easy for modern, distributed, high-scale applications to hide database performance and efficiency problems. It is a recursive method that can be used at any scale, from a data center with many types of databases cooperating as one, to a single server and drilling down to a single query.

How to Setup a WordPress MySQL Database in the Cloud

Scalegrid

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. As any WordPress developer knows, each installation requires a database in the backend, and MySQL is the database of choice for storing and retrieving your WordPress data. Unlimited Databases. How to Setup Your MySQL Database & Admin User for WordPress.

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

Scalegrid

PostgreSQL is an open source relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. 2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combos & Top Reasons Used Click To Tweet.

Towards multiverse databases

The Morning Paper

Towards multiverse databases Marzoev et al., The central idea behind multiverse databases is to push the data access and privacy rules into the database itself. A policy just needs to be a deterministic function of a given update’s record data and the database contents.

ScyllaDB Trends – How Users Deploy The Real-Time Big Data Database

Scalegrid

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. We’ve heard a lot about this rising database from the DBA community and our users, and decided to become a sponsor for this years Scylla Summit to learn more about the deployment trends from its users. Databases Most Commonly Used with ScyllaDB. This number is more inline with our recent 2019 Open Source Database Trends Report where 56.9%

Oracle database insights Early Adopter Release

Dynatrace

With OneAgent installed on an application server, Davis, the Dynatrace AI causation engine, continuously analyzes all database statements within the context of your applications. Resolve performance problems rooted in the Oracle database layer. Why is your database statement slow?

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

High Scalability

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

SQL Clone for Unit Testing Databases

DZone

Sometimes, when you are performing unit or integration tests whilst developing code, you need to be able to do something extreme, such as mangling a test database or two, repeatedly, each time subsequently restoring it to its original state before running the next test. database performance sql testing unit testing clone

Updated Azure SQL Database Tier Options

SQL Performance

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. HyperScale Database. Serverless Database.

Azure 56

Database Design and Logical Asseveration for SQL Query Optimization

SQL Shack

Database design and Logical Asseveration play a vital role in database performance and SQL Query optimization. Both have different parameters to make your database and the query accurate. Database Design Database design plays an essential role in the database performance side.

Bandwidth-friendly Query Profiling for Azure SQL Database

SQL Performance

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. database_id , sqlserver.

Azure 82

Distributed Algorithms in NoSQL Databases

Highly Scalable

These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases.

Measuring database scaling & density on Nutanix HCI platform.

n0derunner

What Density can we achieve Vs The theoretical max How does database performance behave as more DBs are consolidated? Experiment setup The goal was to … The post Measuring database scaling & density on Nutanix HCI platform. Nutanix database density postgres scaling

2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence

Scalegrid

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular? Polyglot Persistence Trends : Number of Databases Used & Top Combinations. 2019 Top Databases Used.

Understanding Graph Databases in SQL Server

SQL Shack

A graph database is a type of NoSQL database that is based on graph theory. Graph databases are ideal for storing data that has complex many to many relationships. In this article, we will study the very basics of graph databases with the help of a simple example. Characteristics of a Graph Database A graph […]. DBAtools Graph database Monitoring Reports

Open Source Database HA Resources from Severalnines

High Scalability

Severalnines has spent the last several years writing blogs and crafting content to help make your open source database solutions highly available.

How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development

High Scalability

Database-as-a-Service (DBaaS) is quickly gaining in popularity across the tech world. These software platform solutions helps users easily manage their database operations without having to really understand any of the abstractions. This allows developers, DBA’s and DevOps engineers to quickly automate their backups, create new SQL and NoSQL clusters, and monitor the performance of their databases for their application without requiring any internal database expertise.

DevOps 198

Database Migration: Challenges, Need & Process

Simform

Database Migration is one of those. If you are planning a migration, what are the challenges involved during database migration? Let me walk you through the essentialities before performing database migration. Custom Software Development Database

SQL Server TempDB database and Latch Contention

SQL Shack

In this article, we will learn latch contention issues that we might experience in the SQL Server TempDB database. We will also discuss reasons and the solution method of these latch contention issues.

Azure SQL database Geo-Replication

SQL Shack

In this article, we will review how to set up Geo-Replication on Azure SQL databases. Geo-Replication is an Azure SQL database feature that allows you to create a readable secondary database in the same region or cross-region.

Azure 63

How to detect and prevent unexpected growth of the TempDB database

SQL Shack

In this article, we will discuss the best practices that should be followed in order to keep the TempDB database in a healthy state and prevent any unexpected growth of the database, in addition to the procedure that can be followed to detect this unexpected growth once occurred.

Updating graph databases with Cypher

The Morning Paper

Updating graph databases with Cypher Green et al., Our understanding of updates in the popular graph database model… is still very rudimentary. Violations of atomicity and non-deterministic update behaviour certainly don’t sound like the kind of things you want in a database!!

Using Database Metrics to Predict Application Problems

SQL Shack

Summary Database metrics can be collected, maintained, and used to help predict when processes go awry so problems can be resolved before they become severe.

Database compression on Nutanix

n0derunner

What space savings should you expect when running databases with default compression in a Nutanix cluster? The TPCx-HCI benchmark mimics a database consolidation setup, meaning that there are many databases per host. Compressability.

Database Resolutions for 2018

VoltDB

So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB.

Database Resolutions for 2018

VoltDB

So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB.

Bringing DevOps to the Database

Baron Schwartz

Applying DevOps principles and practices to the database can make software development processes faster, better and cheaper. Yet most companies do not include their databases in their DevOps initiatives because they face a variety of challenges to make it work.

Optimizing Database Performance and Efficiency

Baron Schwartz

It’s easy for modern, distributed, high-scale applications to hide database performance and efficiency problems.

Bring Your Own Cloud (BYOC) vs. Dedicated Hosting at ScaleGrid

Scalegrid

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider?

Cloud 176

Bringing DevOps to the Database

Baron Schwartz

Databases are special because they’re stateful, and DevOps reflects this: in practice, databases are a lot harder to “DevOps” (as a verb) than other parts of the stack. In more detail, What research shows about DevOps, databases, and company performance.

SQL Server Update Statistics using database maintenance plans

SQL Shack

This article explores SQL Server Update Statistics using the database maintenance plan. Introduction SQL Server query optimizer uses statistics to build an optimized execution plan.

AWS RDS SQL Server – Monitoring database instances

SQL Shack

In this article, we will review how to monitor AWS RDS SQL Server database instances and setup email notifications using event subscriptions and CloudWatch alarms. Database monitoring is one of the important tasks of a database administrator to ensure availability and performance.

AWS 63