Scalegrid

SEPTEMBER 5, 2024

Managing High Availability (HA) in your PostgreSQL hosting is very important to ensuring your database deployment clusters maintain exceptional uptime and strong operational performance so your data is always available to your application. The primary server is responsible for handling all write operations and maintaining data accuracy.

Availability 257

Availability Servers Database Open Source 257

Scalegrid

MAY 2, 2019

It comes as no surprise that Python developers commonly leverage MongoDB hosting , the most popular NoSQL database , for their deployments due to its flexible nature and lack of schema requirements. It is also recommended that SSL connections be enabled to encrypt the client-database traffic. Testing Failover Behavior.

Testing 55

Testing Network Database Servers 55

SQL Shack

SEPTEMBER 16, 2020

In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database. It uses the […].

Database 104

Database Availability Servers 104

DZone

MARCH 4, 2023

In any organization, it is a best security practice to have an SSL certificate installed on servers, applications, and databases. SSL Certificates and CA make communication secure between client and server or application. This article will focus on how to set up an internal CA for your organization.

Servers 130

Servers Database Systems 130

DZone

SEPTEMBER 26, 2023

Since you need to access multiple components (servers, databases, network infrastructure, applications, etc.) In this article, we’re going to take a look at how logging can help you make sense of your log data without much effort. Though it can feel like more trouble than it’s worth, sorting through logs is crucial.

Best Practices 255

Best Practices Analytics Network Infrastructure 255

The Netflix TechBlog

SEPTEMBER 18, 2024

Central to this infrastructure is our use of multiple online distributed databases such as Apache Cassandra , a NoSQL database known for its high availability and scalability. Over time as new key-value databases were introduced and service owners launched new use cases, we encountered numerous challenges with datastore misuse.

Latency 254

Latency Storage Cache Efficiency 254

Highly Scalable

MARCH 1, 2012

NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. At the same time, NoSQL data modeling is not so well studied and lacks the systematic theory found in relational databases. Document databases advance the BigTable model offering two significant improvements.

Database 279

Database Ecommerce Efficiency Engineering 279

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. In this article, I focus on the distinct predicate and the approximate percentile functions. A set of bit manipulation functions.

Servers 142

Servers Testing C++ Code 142

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. In this article I focus on windowing and NULL-related improvements. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This release has a number of T-SQL improvements.

Servers 145

Servers C++ Code Database 145

Scalegrid

AUGUST 30, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker.

Cache 232

Cache Ecommerce Social Media Database 232

SQL Shack

OCTOBER 6, 2021

This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances. Introduction The server performance depends on various factors such as CPU, Memory, and Storage configurations. SQL Server works on top of the operating system and works closely with these resources.

Database 88

Database Servers Operating System Storage 88

SQL Shack

OCTOBER 6, 2021

This article explains the internals of the Ghost cleanup task for SQL Server Databases. Broadly, we can divide these system processes into the […].

Database 83

Database Servers Monitoring Processing 83

SQL Shack

AUGUST 27, 2020

In this article, we will learn some basic tips for SQL Server performance tuning. Tuning the SQL Server performance will help to access data faster so the applications data interaction performances will enhance. SQL Server […].

Tuning 114

Tuning Servers Performance Database 114

SQL Shack

JULY 30, 2020

This is the 8th article in the series for SQL Server Always On Availability Groups. Introduction SQL Server Always On Availability Groups create a group of databases that fails over together in case the primary replica is unavailable. By default, SQL Server […]. By default, SQL Server […].

Availability 88

Availability Database Servers 88

SQL Shack

OCTOBER 12, 2020

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105

Servers Availability Database 105

Scalegrid

DECEMBER 6, 2023

In the digital age, data management has transformed from locally hosted servers to cloud solutions. 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 130

Database Cloud Hardware Storage 130

SQL Shack

FEBRUARY 17, 2021

In this article, we are going to talk about the modes of transactions in SQL Server. Introduction A transaction is the smallest work unit that is executed in the database and transactions also meet the properties of the ACID (atomicity, consistency, isolation and durability).

Servers 111

Servers Database Monitoring 111

DZone

FEBRUARY 12, 2024

Optimizing complex MySQL queries is crucial when dealing with large datasets, such as fetching data from a database containing one million records or more. Poorly optimized queries can lead to slow response times and increased load on the database server, negatively impacting user experience and system performance.

Performance 173

Performance Database Strategy Efficiency 173

SQL Shack

NOVEMBER 16, 2020

In this 36th article for SQL Server Always On series, we will explore various dynamic management views (DMV’s) for monitoring the AG replicas. Introduction SQL Server Always On Availability Groups gives you the ability to safeguard the SQL databases and implements a solution for high-availability and disaster recovery.

Availability 122

Availability Servers Monitoring Database 122

SQL Shack

AUGUST 23, 2021

In this article, we will go through some details about SQL Server statistics. The first step into SQL Server statistics The query plan is a set of instructions that describes how a query will be executed by the database engine. The query plans are created by the query optimizer in SQL Server and it requires […].

Servers 109

Servers Database Engineering Performance 109

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. Not available.

Open Source 244

Open Source Tuning C++ Database 244

SQL Shack

FEBRUARY 10, 2021

In this article, we will talk about fundamental details of the transactions in SQL Server. Introduction A transaction is the logical work unit that performs a single activity or multiple activities in a database. Transactions may consist of a single read, write, delete, or update operations or a combination of these.

Servers 110

Servers Database Performance Monitoring 110

SQL Shack

NOVEMBER 19, 2020

In this 37th article for SQL Server Always On Availability Groups, we will explore useful dynamic management views for monitoring availability replicas and databases. This article […].

Availability 90

Availability Monitoring Database Servers 90

SQL Shack

AUGUST 16, 2019

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.

Database 79

Database Servers Monitoring 79

SQL Shack

OCTOBER 4, 2021

This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA. Introduction SQL Server system database – MSDB stores SQL Server agent jobs, History, schedules, database mail, service broker, backup, and restore History.

Database 97

Database Servers Systems Processing 97

SQL Shack

AUGUST 27, 2021

This article explores Persist sampling rate feature for automatic SQL Server statistics update. Introduction DBA should always focus on the optimal database performance as it is directly related to the application’s performance. Indexes help DBA to optimize queries based on the user data requirements. […].

Servers 109

Servers Database Monitoring Performance 109

SQL Shack

NOVEMBER 9, 2021

This is the second article in the series of Migrating SQL Server Objects using SSDT 2017. In this article, we will learn how to copy user stored procedures created in the SQL Server master database. You can […].

Database 81

Database Servers Monitoring Performance 81

Dynatrace

MARCH 29, 2024

Get insights into Google BigQuery service metrics – Hub article This Dynatrace extension leverages data collected from the Google Operations API to constantly monitor health and performance of Google BigQuery services.

Google 273

Google Innovation Cloud Analytics 273

SQL Shack

SEPTEMBER 29, 2020

In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups. Previously, to access data from […].

Servers 99

Servers Availability Virtualization Database 99

DZone

MARCH 17, 2023

For example, imagine a simple e-commerce application that includes a mobile app, web server, and database. This article will dive into how front-end developers can leverage OpenTelemetry to improve observability and efficiently troubleshoot issues like this one. That's where OpenTelemetry comes in.

Mobile 189

Mobile Efficiency Database Servers 189

SQL Shack

APRIL 7, 2021

This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases. Introduction As a database professional, you confront the performance issues with databases. It is essential to […].

AWS 74

AWS Database Servers Processing 74

Scalegrid

JANUARY 3, 2020

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance.

Monitoring 164

Monitoring Metrics Servers Database 164

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 119

Servers Best Practices Database Open Source 119

SQL Shack

MAY 12, 2021

This article intends is to give helpful SQL Server performance tuning advice to those who want to learn performance tuning. Introduction One day a rooky database administrator has said to me: Understanding and solving SQL performance issues require an enormous amount of work.

Tuning 101

Tuning Servers Performance Database 101

Scalegrid

AUGUST 15, 2019

In this article, we are going to compare 6 of the top MongoDB Graphical User Interfaces that help developers increase their productivity and manage their database. Should have an excellent way to measure server and query performance. SQL Import/Export that supports major databases: Oracle, SQL Server, MySQL, and PostgreSQL.

Database 40

Database Servers Availability Monitoring 40

SQL Shack

DECEMBER 29, 2021

In this article, we will learn how we can detect which operations cause to fill up SQL Server tempdb through the dynamic management views. What is SQL Server tempdb used for? Tempdb is one of the system databases, that is used by many activities in SQL Server to temporarily store data. Such as when a […].

Servers 100

Servers Monitoring Database Systems 100

SQL Shack

FEBRUARY 28, 2020

In this article, we will discuss a number of interview questions that you could be asked about the SQL Server Always On Availability Groups feature when attending an interview for the SQL Server database administrator role.

Availability 98

Availability Servers Database 98