Scalegrid

NOVEMBER 25, 2019

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.

Big Data 187

Big Data Database Open Source Azure 187

SQL Shack

NOVEMBER 23, 2020

In this article, we will talk about the query tuning features that were announced with SQL Server 2019. Introduction Sometimes, tuning the queries can be a tough task for database developers or administrators.

Tuning 76

Tuning Servers Database Development 76

Scalegrid

JUNE 11, 2019

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? Polyglot Persistence Trends : Number of Databases Used & Top Combinations.

Open Source 55

Open Source Database Cloud Infrastructure 55

Percona Community

MAY 9, 2019

At this year’s Percona Live I am talking about The State of Databases in 2019. As a Software Engineer in the thick of the Database landscape, there are two problems that I see repeatedly.

Database 52

Database Software Engineering Engineering Software 52

All Things Distributed

JULY 4, 2019

A few months ago, I wrote the post " Amazon Aurora ascendant: How we designed acloud-native relational database ," and now I'm excited to share some news about the people behind the service.

Systems 126

Systems Development Hardware Database 126

KeyCDN

MARCH 14, 2019

Here is a roundup of front end web development trends to keep an eye on in 2019. Frontend Frameworks If you’re not using a frontend framework like React, Vue.js, or Angular to help build your projects, then 2019 is a good year to start. IBM, Microsoft, and Amazon are all exploring new ways to use blockchains in 2019.

Development 101

Development Blockchain Serverless Social Media 101

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 79

Open Source Database Storage Scalability 79

SQL Performance

AUGUST 2, 2019

From the customer side, this has been the limit of what can be done*, until SQL Server 2019. Some information is available in the SQL Server 2019 release notes , and there was a demo from Bob Ward and Conor Cunningham during the first day of the PASS Summit keynote. Now that 2019 CTP 3.2 I have SQL Server 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

SQL Shack

MAY 13, 2020

In this article, we will learn latch contention issues that we might experience in the SQL Server TempDB database. Especially, we will mention the Memory-Optimized TempDB Metadata feature that was introduced with the SQL Server 2019. We will also discuss reasons and the solution method of these latch contention issues.

Database 68

Database Servers Performance Testing Testing 68

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013.

Open Source 244

Open Source Tuning C++ Database 244

Simform

JULY 24, 2022

In 2019, an IT outage at Lloyds Banking Group caused hundreds of thousands of payments to become stranded. The post Multi-region databases: The why, design principles, and what does AWS offer? Customers had to complain about troubles transferring money on Friday morning, which got annoying.

AWS 52

AWS Database Design Engineering 52

Scalegrid

JUNE 6, 2019

June 6, 2019 – ScaleGrid , the Database-as-a-Service (DBaaS) leader in the SQL and NoSQL space, has announced the expansion of their fully managed MySQL Hosting services to support Amazon Web Services (AWS) cloud. PALO ALTO, Calif.,

AWS 191

AWS Cloud Open Source Virtualization 191

SQL Performance

APRIL 27, 2020

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. Hyperscale databases are provisioned using vCores. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

SQL Performance

NOVEMBER 1, 2019

I helped Bob Ward ( @bobwardms ) with technical editing for his most recent book, " SQL Server 2019 Revealed ," and have been actively engaged with the product teams and my MVP peers throughout the CTP and RC cycles. Accelerated Database Recovery is in Standard Edition.

Servers 40

Servers Hardware Database Availability 40

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The database is also widely loved for PostgreSQL extensions which enable users to extend the functionality of their database. PALO ALTO, Calif.,

Azure 182

Azure AWS Open Source Database 182

Percona Community

MAY 14, 2019

During our presentation at Percona Live 2019 Intel and its software partners will introduce the audience to the work we’re doing to enable an open-source framework, we call Cloud Native Database. This is a collaborative effort between Intel, Rockset, PlanetScale, MariaDB and Percona.

Open Source 52

Open Source Database Cloud Storage 52

Scalegrid

JUNE 18, 2019

Our yml file: development: # Configure available database clients. Alternatively, you can define the following: # # Define the name of the default database that Mongoid can connect to. # (required). database: test # Provide the hosts the default client can connect to. The user's database roles. The user's database roles.

C++ 100

C++ Servers Database Network 100

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. PostgreSQL popularity is skyrocketing in the enterprise space.

Strategy 182

Strategy Cloud Java Open Source 182

MachMetrics

DECEMBER 27, 2019

TTFB is typically reduced via server-side optimizations, such as enabling caching and database indexes. The post Year in Web Performance: 2019 appeared first on MachMetrics Speed Blog. There is obviously a huge amount of work that needs to be done here concerning web performance. The hosting plan you select also plays a big role here.

Performance 52

Performance Speed Website Mobile 52

Scalegrid

OCTOBER 2, 2019

October 2, 2019 – ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Hosting on Azure for Redis™ service. PALO ALTO, Calif.,

Azure 100

Azure Availability Open Source Virtualization 100

Alex Podelko

APRIL 18, 2021

Blog post from April 30, 2019, Reducing variability in performance tests on EC2: Setup and Key Results , address that specific issue. David will also talk at the Workshop on Education and Practice of Performance Engineering (WEPPE) about Performance Engineering and Database Development at MongoDB.

Performance Testing 182

Performance Testing Testing Performance Education 182

O'Reilly

FEBRUARY 18, 2020

Growth is still strong for such a large topic, but usage slowed in 2018 (+13%) and cooled significantly in 2019, growing by just 7%. But sustained interest in cloud migrations—usage was up almost 10% in 2019, on top of 30% in 2018—gets at another important emerging trend. Still cloud-y, but with a possibility of migration.

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. Need help managing complex database environments? This structure makes for faster data access.

Virtualization 81

Virtualization Speed Database Efficiency 81

Scalegrid

JANUARY 24, 2019

January 24, 2019 – ScaleGrid , a rising leader in the Database-as-a-Service (DBaaS) space, has just announced support for Redis Clusters on their fully managed Redis hosting plans. PALO ALTO, Calif., Highly Available #Redis Clusters with Automated Sharding Launches at ScaleGrid Click To Tweet.

Availability 113

Availability Open Source AWS DevOps 113

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 212

Database Traffic Transportation Open Source 212

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 197

Database Traffic Open Source Transportation 197

The Morning Paper

SEPTEMBER 19, 2019

We’ve been covering papers from VLDB 2019 for the last three weeks, and next week it will be time to mix things up again. MongoDB is an important database, and this paper explains the tunable (per-operation) consistency models that MongoDB provides and how they are implemented under the covers.

Blockchain 46

Blockchain Hardware Google Analytics 46

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Use the following code to create the Employees table in the tempdb database, populate it with sample data, and create a supporting index: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Employees ; GO. CREATE TABLE dbo. Employees. (

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117

Dynatrace

JANUARY 19, 2020

Having released this functionality in a Preview Release back in May 2019, we’re now happy to announce the General Availability of our SAP ABAP monitoring extension. SAP database performance: Query response time, percentage of time spent in the database, and the number of database calls executed by the SAP server.

Monitoring 153

Monitoring Best Practices Infrastructure Servers 153

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. PostgreSQL supports multiple concurrent users and can handle complex database operations without downtime or data loss. What is PostgreSQL used for?

Healthcare 80

Healthcare Open Source Social Media Innovation 80

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. SQL Server 2019 introduces batch mode on rowstore support, so you can get batch-mode processing even if there's no columnstore indexes present on the data.

Best Practices 108

Best Practices Servers Database Azure 108

Dynatrace

SEPTEMBER 7, 2019

Database tracing using Couchbase Node.js in November 2019 as it reached end-of-life on June, 27th 2019. support has been extended and will reach end-of-life in November 2019. x (End of general support by Pivotal in August 2019) OneAgent version 1.179 is the last version that supports PCF version 2.3.x.

Java 101

Java Traffic AWS Monitoring 101

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

SEPTEMBER 12, 2019

In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Suppose for example that you want to query the Sales.Orders table in the TSQLV5 sample database. Implicit grouping with PIVOT. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103