SQL Shack

SEPTEMBER 27, 2021

Azure SQL Database is a popular choice for migrating your database from on-premises to cloud infrastructure. Azure SQL Databases has two pricing models – DTUs and vCores. DTUs based purchasing model The Database Transaction Unit (DTU) […].

Azure 90

Azure Database Infrastructure Cloud 90

Scalegrid

MARCH 30, 2021

March 30, 2021 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for Oracle Cloud Infrastructure (OCI) through their fully managed database hosting plans. PALO ALTO, Calif., Oracle […].

Database 243

Database Cloud Azure AWS 243

SQL Performance

APRIL 15, 2020

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. Unfortunately, my excitement was short lived for a couple of reasons.

Azure 96

Azure Database Tuning Network 96

Dynatrace

JULY 6, 2020

As adoption rates for Microsoft Azure continue to skyrocket, Dynatrace is developing a deeper integration with the platform to provide even more value to organizations that run their businesses on Azure or use it as a part of their multi-cloud strategy. Azure Batch. Azure DB for MariaDB. Azure DB for MySQL.

Azure 148

Azure Cloud Big Data Virtualization 148

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. Fully Managed #PostgreSQL Hosting on AWS and Azure Launches in Time For Legacy Migrations Click To Tweet. PALO ALTO, Calif.,

Azure 182

Azure AWS Open Source Database 182

DZone

JULY 6, 2023

Azure Cosmos DB is a highly scalable and globally distributed NoSQL database service offered by Microsoft. In this blog post, we will explore best practices and tips for optimizing performance in Azure Cosmos DB. In this blog post, we will explore best practices and tips for optimizing performance in Azure Cosmos DB.

Azure 258

Azure Performance Best Practices Strategy 258

Scalegrid

MARCH 2, 2021

When considering a new cloud provider, the big names come to mind - AWS, Azure, and Google Cloud. If you’re a developer, you might even be considering a dev-friendly cloud like DigitalOcean or Linode. But, did you know there’s a (relatively) new player in the cloud game? Oracle Cloud Infrastructure (OCI) is a cloud computing […].

Cloud 246

Cloud Database Azure Games 246

Dynatrace

AUGUST 28, 2020

This is the second part of our blog series announcing the massive expansion of our Azure services support. Part 1 of this blog series looks at some of the key benefits of Azure DB for PostgreSQL, Azure SQL Managed Instance, and Azure HDInsight. Fully automated observability into your Azure multi-cloud environment.

Azure 156

Azure Cloud Tuning Monitoring 156

SQL Shack

SEPTEMBER 7, 2021

This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance. Introduction Statistics plays a vital role in the query optimizer task to build a cost-effective and optimized query execution plan.

Azure 65

Azure Database Servers Performance 65

SQL Shack

JULY 14, 2020

In this article, I am going to explain how we can automate the index and statistics maintenance of Azure SQL Database using an Elastic Job Agent. The Microsoft SQL Server Agent component is used to automate the various tasks including database maintenance.

Azure 64

Azure Database Servers Availability 64

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., Cloud reliability has never been so important,” says Dharshan Rangegowda, Founder and CEO of ScaleGrid.

Azure 100

Azure Availability Open Source Virtualization 100

Scalegrid

APRIL 16, 2020

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? AWS , Azure. AWS , Azure.

Cloud 242

Cloud Azure AWS Database 242

The Polyglot Developer

NOVEMBER 8, 2022

So you’re building serverless applications with Microsoft Azure Functions, but you need to persist data to a database. What do you do about controlling the number of concurrent connections to your database from the function? The post Getting Started with MongoDB Atlas and Azure Functions using Node.js

Azure 64

Azure Serverless Database Design 64

SQL Shack

JULY 15, 2019

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 43

Azure Database Availability 43

The Polyglot Developer

FEBRUARY 17, 2023

This is a perfect scenario for a serverless function, like those built with Azure Functions. However, what happens when you need to include a database in the mix? In this tutorial we’ll explore how to create a serverless function with Azure Functions and the.NET runtime to interact with MongoDB Atlas.

Azure 59

Azure C++ Serverless Database 59

InfoQ

JUNE 26, 2023

Microsoft has recently unveiled several new features for Azure Cosmos DB to enhance cost efficiency, boost performance, and increase elasticity. These features are burst capacity, hierarchical partition keys, serverless container storage of 1 TB, and priority-based execution. By Steef-Jan Wiggers

Azure 83

Azure Serverless Performance Storage 83

Scalegrid

NOVEMBER 26, 2020

In fact, it is the number one key value store and eighth most popular database in the world. Redis is an advanced key-value store. It has high throughput and runs from memory, but also has the ability to persist data on disk. Redis is a great caching solution for highly demanding applications, and there are […].

Cache 130

Cache Azure Benchmarking Performance 130

Dynatrace

MARCH 27, 2024

As teams and their structure and metadata are often maintained in a dedicated database, such as Microsoft Entra ID (formerly Azure Active Directory) or ServiceNow. A dedicated workflow allows automatic synchronization of the database information with Dynatrace and keeps the ownership team information up-to-date.

Best Practices 201

Best Practices Azure Database Code 201

InfoQ

MARCH 24, 2021

Recently Microsoft announced Azure Monitor SQL Insights for Azure SQL in public preview. With the preview, customers will get a flexible canvas for telemetry collection, analysis, and rich custom visualization. By Steef-Jan Wiggers.

Azure 73

Azure Monitoring Design Scalability 73

DZone

FEBRUARY 5, 2023

Cosmos DB is a multimodal database in Azure that supports schema-less storage. Cosmos DB can be a good candidate for a key-value store. By default, Cosmos DB containers tend to index all the fields of a document uploaded. We can limit the index properties only to id and partitionkey to make the container a pure key-value store.

Azure 243

Azure Storage C++ Performance Testing 243

High Scalability

JUNE 27, 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?

Open Source 196

Open Source Database Cloud Strategy 196

SQL Shack

APRIL 24, 2020

This article gives an overview of viewing execution plans in the Azure Data Studio. Introduction Database administrators use a query execution plan for troubleshooting query performance issues. Suppose one day a user calls you and says my query is running slow.

Azure 82

Azure Database Performance Monitoring 82

SQL Shack

JULY 18, 2019

In this article, we will review how to set up auto-failover groups in Azure SQL Server and how failover group is different from active geo-replication in Azure. Auto-failover group is an Azure SQL database feature that replicates one or a group of databases to the secondary Azure SQL server in the cross-region.

Azure 60

Azure Servers Database Availability 60

SQL Performance

FEBRUARY 26, 2020

Azure SQL Database Managed Instance became generally available in late 2018. General Purpose provides up to 8 TB of high-performance Azure Blob storage, while Business Critical provides up to 4 TB of super-fast local SSD storage. Memory is allocated at approximately 5.1 GB per vCore. With only having 5.1 GB 8 vCores = 6.28

Azure 63

Azure Performance Storage Latency 63

Dynatrace

JANUARY 31, 2024

The RAG process begins by summarizing and converting user prompts into queries that are sent to a search platform that uses semantic similarities to find relevant data in vector databases, semantic caches, or other online data sources.

Cache 206

Cache Azure Infrastructure Monitoring 206

InfoQ

JULY 14, 2023

Mei-Chin Tsai, Vinod discuss the internal architecture of Azure Cosmos DB and how it achieves high availability, low latency, and scalability. By Mei-Chin Tsai, Vinod Sridharan

Latency 52

Latency Azure Availability Scalability 52

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. You'll see the types referenced as Family in the Azure Portal when sizing a VM. The various types are: General purpose – Balanced CPU-to-memory ratio, small to medium databases. VM Sizing Considerations.

Azure 76

Azure Benchmarking Storage Virtualization 76

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. Point-in-time recovery Point-in-time recovery (PITR) allows you to reduce your Point Recovery Objective by restoring or rolling back the database to a specific transaction or time. But snapshots cannot provide you with the same RPO as native database mechanisms.

Database 66

Database Storage Open Source AWS 66

SQL Performance

APRIL 26, 2019

If so, you may have heard about the Azure SQL Database DTU calculator , and you may have also read about how it has been reverse engineered by Andy Mallon. Database – Log Bytes Flushed/sec. When I looked through the SentryOne database, I found that 3 of the 4 counters were already being captured by default.

Azure 40

Azure Database Metrics Servers 40

Scalegrid

JUNE 9, 2020

June 9, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for their MySQL , PostgreSQL and Redis™ solutions on DigitalOcean. This launch is in addition to their current DigitalOcean offering for MongoDB® database , the only DBaaS to support this database on DigitalOcean.

Availability 227

Availability Open Source Benchmarking Database 227

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Most Kubernetes clusters in the cloud (73%) are built on top of managed distributions from the hyperscalers like AWS Elastic Kubernetes Service (EKS), Azure Kubernetes Service (AKS), or Google Kubernetes Engine (GKE). Java, Go, and Node.js

Open Source 344

Open Source Java Operating System Programming 344

Dynatrace

MARCH 8, 2022

In addition to existing support for AWS Lambda , this expansion includes Microsoft Azure Functions, Google Cloud Functions, as well as managed Kubernetes environments, messaging queues, and cloud databases across all major cloud providers. Dynatrace Launches DevSecOps Automation Alliance Partner Program.

Code 183

Code Software Software Serverless 183

Dynatrace

APRIL 10, 2023

shifted most of its ecommerce and enterprise analytics workloads to Kubernetes-managed software containers running in Microsoft Azure. “We set up Dynatrace dashboards to help us see the response times of the database and the orders being placed on a day-to-day basis. . ” Three years ago, Tractor Supply Co.

Cloud 173

Cloud Ecommerce Performance Retail 173

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

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 Redis on Azure service. Redis, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 37

Azure Cloud Open Source Virtualization 37

Scalegrid

OCTOBER 31, 2019

If you need help setting up high availability for your PostgreSQL clusters, check out our fully Managed PostgreSQL on AWS , PostgreSQL on Azure , and PostgreSQL Enterprise solutions to automate your database management in the cloud an on-premise.

Availability 187

Availability Azure AWS DevOps 187

Tasktop

JANUARY 13, 2021

Tasktop integrated the organization’s ITSM tool— ServiceNow —to its Agile development tools— Atlassian Jira and Microsoft Azure DevOps —to optimize its ability to resolve users’ problems faster across all systems. Some teams use Jira, and others use Azure DevOps depending on the product value stream.

Azure 52

Azure DevOps Healthcare Metrics 52