SQL Performance

FEBRUARY 26, 2020

Azure SQL Database Managed Instance became generally available in late 2018. Organizations are taking advantage of having managed backups, lots of built-in security features, an uptime SLA of 99.99%, and an always up-to-date environment where they are no longer responsible for patching SQL Server or the operating system.

Azure 63

Azure Performance Storage Latency 63

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Dynatrace

JUNE 7, 2023

According to the Kubernetes in the Wild 2023 report, “Kubernetes is emerging as the operating system of the cloud.” ” In recent years, cloud service providers such as Amazon Web Services, Microsoft Azure, IBM, and Google began offering Kubernetes as part of their managed services. Ease of use.

Open Source 206

Open Source Social Media Infrastructure Operating System 206

Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Distribution for MySQL (PS- based variant) 8.1.0 Percona Server for MySQL 8.1.0-1

Open Source 77

Open Source Azure Servers Programming 77

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. Configuring storage in Kubernetes is more complex than using a file system on your host. The Kubernetes experience.

Virtualization 160

Virtualization Infrastructure Monitoring Cloud 160

Particular Software

JUNE 20, 2022

The key to a successful Cosmos DB system is its data partitioning strategy. Like the rows of shrubs in a hedge maze, the logical partitions that divide data must be carefully planned, because that affects the scalability of the system and defines the boundaries for logical transactions. In version 1.1

Azure 52

Azure Storage Strategy Tuning 52

Scalegrid

DECEMBER 6, 2023

The choice of self-managed cloud databases vs DBaaS is a common debate among those who are looking for the best option that will cater to their particular needs. Database as a Service (DBaaS) and managed databases offer distinct advantages along with certain challenges.

Database 130

Database Cloud Hardware Storage 130

ScaleOut Software

JULY 19, 2021

How are we managing the torrent of telemetry that flows into analytics systems from these devices? Incoming data is saved into data storage (historian database or log store) for query by operational managers who must attempt to find the highest priority issues that require their attention. The list goes on.

IoT 78

IoT Analytics Big Data Architecture 78

Scalegrid

MAY 13, 2020

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. What is an MPP Database?

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

ScaleOut Software

JANUARY 9, 2020

It’s not enough just to pick out interesting events from an aggregated data stream and then send them to a database for offline analysis using Spark. In addition, the platform provides fast, in-memory data storage so that the application can easily and quickly record both telemetry and analytics results for each store.

Logistics 52

Logistics Retail Analytics Azure 52

ScaleOut Software

JANUARY 9, 2020

It’s not enough just to pick out interesting events from an aggregated data stream and then send them to a database for offline analysis using Spark. In addition, the platform provides fast, in-memory data storage so that the application can easily and quickly record both telemetry and analytics results for each store.

Logistics 52

Logistics Retail Analytics Azure 52

ScaleOut Software

JANUARY 9, 2020

It’s not enough to just pick out interesting events from an aggregated data stream and then send them to a database for offline analysis using Spark. In addition, the platform provides fast, in-memory data storage so that the application easily can keep track of both telemetry and analytics results for each store.

Logistics 52

Logistics Retail Analytics Azure 52

High Scalability

APRIL 16, 2019

Thus, whenever a master MySQL goes down (whether due to a MySQL crash, OS crash, system reboot, etc.), This ensures that the system continues to be available to the applications. At ScaleGrid, we offer highly available hosting for MySQL on AWS and MySQL on Azure that is implemented based on the concepts explained in this blog series.

Availability 149

Availability Network Azure AWS 149

Dynatrace

SEPTEMBER 17, 2019

PostgreSQL & Elastic for data storage. Robert’s AWS & EKS admin team are monitoring most services with that capability but found it beneficial for them to have Dynatrace monitor Elastic File Storage (EFS). Dynatrace’s Response Time Hotspot Analysis automates the hotspot detection in highly distributed systems.

AWS 127

AWS Monitoring Ecommerce Lambda 127

Tasktop

JANUARY 9, 2020

Even better, we can glean valuable end-to-end system data that can be used for higher-level business-centric Flow Metrics , empowering you to generate more business value through your software delivery. . Furthermore, many SaaS vendors purge data periodically to save on storage, limiting your access to historical data.

Software 59

Software Software Metrics Database 59

ScaleOut Software

JUNE 22, 2020

Going back to the mid-1990s, online systems have seen relentless, explosive growth in usage, driven by ecommerce, mobile applications, and more recently, IoT. From Distributed Caches to Real-Time Digital Twins. For more than two decades, the answer to this challenge has proven to be a technology called in-memory computing.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

ScaleOut Software

JUNE 22, 2020

Going back to the mid-1990s, online systems have seen relentless, explosive growth in usage, driven by ecommerce, mobile applications, and more recently, IoT. From Distributed Caches to Real-Time Digital Twins. For more than two decades, the answer to this challenge has proven to be a technology called in-memory computing.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

Scalegrid

JULY 29, 2019

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. Host MySQL on AWS , or MySQL on Azure with configurable instance sizes through the top two cloud providers in the world.

Database 166

Database Cloud Website Azure 166

Percona

DECEMBER 11, 2023

There are a wealth of options on how you can approach storage configuration in Percona Operator for PostgreSQL , and in this blog post, we review various storage strategies — from basics to more sophisticated use cases. For example, you can choose the public cloud storage type – gp3, io2, etc, or set file system.

Storage 100

Storage Strategy Cloud Azure 100

Percona

MAY 2, 2023

As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? mongodump --host=mongodb1.example.net

Best Practices 52

Best Practices Database Storage Servers 52

ScaleOut Software

APRIL 3, 2020

What’s missing is a flexible, fast, and easy-to-use software system that can be quickly adapted to track these assets in real time and provide immediate answers for logistics managers. By avoiding the need to create or connect to complex databases and ship data to offline analytics systems, it can provide timely answers quickly and easily.

Logistics 52

Logistics Analytics Scalability Cloud 52

ScaleOut Software

APRIL 3, 2020

What’s missing is a flexible, fast, and easy-to-use software system that can be quickly adapted to track these assets in real time and provide immediate answers for logistics managers. By avoiding the need to create or connect to complex databases and ship data to offline analytics systems, it can provide timely answers quickly and easily.

Logistics 52

Logistics Analytics Scalability Cloud 52

Scalegrid

MARCH 14, 2024

Understanding Hybrid Cloud Strategy A hybrid cloud merges the capabilities of public and private clouds into a singular, coherent system. Managing Costs Lower storage expenses in the public cloud and the ability to scale resources as needed enhance the cost-effectiveness of a hybrid cloud environment compared to on-premises infrastructure.

Strategy 130

Strategy Cloud Artificial Intelligence Infrastructure 130

ScaleOut Software

JULY 14, 2021

The Microsoft Azure IoT ecosystem offers a rich set of capabilities for processing IoT telemetry, from its arrival in the cloud through its storage in databases and data lakes. Acting as a switchboard for incoming and outgoing messages, Azure IoT Hub forms the core of these capabilities.

IoT 52

IoT Azure Analytics Serverless 52

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. Such demanding use cases place a great value on systems capable of fast and reliable execution, a need that spans across various industry segments.

Cloud 130

Cloud Virtualization Storage Efficiency 130

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency.

C++ 109

C++ Database Servers Code 109

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool? Top PostgreSQL GUI Tools.

Open Source 262

Open Source Database Azure Cloud 262

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency.

C++ 93

C++ Database Servers Code 93

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Scalegrid

JANUARY 8, 2024

For example, an application could use on-premises databases while also having access to ‘cloud bursting’ capabilities during times of high demand. This article will focus on the technology behind ScaleGrid’s Database-as-a-Service (DBaaS) solutions and how they align with multi-cloud and hybrid cloud structures.

Strategy 147

Strategy Cloud Scalability Artificial Intelligence 147

Dynatrace

FEBRUARY 9, 2022

Cloud vendors such as Amazon Web Services (AWS), Microsoft, and Google provide a wide spectrum of serverless services for compute and event-driven workloads, databases, storage, messaging, and other purposes. 3 End-to-end distributed trace including Azure Functions. Dynatrace news. New to Dynatrace?

Serverless 187

Serverless Azure Lambda AWS 187

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. of PostgreSQL hosting. use with PostgreSQL.

Strategy 182

Strategy Cloud Java Open Source 182

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90

Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. TDE can be applied at various levels, such as at the database, column, or cell level, depending on the organization’s specific security needs. Database-level encryption.

Database 93

Database Storage Servers Strategy 93

Particular Software

AUGUST 16, 2021

which provides saga and outbox storage for NServiceBus endpoints that is transactionally consistent with the business data you store in Cosmos DB. How do I move from Azure Tables to Cosmos DB? ?? Cosmos DB is the primary database service provided by Azure. But what does it mean for a NoSQL database to have an SQL API?

Azure 52

Azure Serverless Storage Database 52

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. Azure Lsv2 Details. Memory (GiB).

Azure 42

Azure Virtualization Storage Benchmarking 42