SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause allows you to shorten your code by avoiding the repetition of identical parts of your window specifications.

Servers 145

Servers C++ Code Database 145

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

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. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here.

Servers 142

Servers Testing C++ Code 142

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? pgAdmin uses too many resources.

Open Source 262

Open Source Database Azure Cloud 262

Percona

DECEMBER 18, 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. Initially a standalone client for PMM Server, PMM Dump is now accessible in the PMM user interface.

Monitoring 89

Monitoring Open Source Servers Scalability 89

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. Find more information in the Telemetry on Percona Server for MySQL document. Take a look.

Open Source 82

Open Source Azure Servers Programming 82

Percona

JANUARY 3, 2024

If you are a database administrator or developer, you may encounter some issues that require external assistance. Whether you seek help from Percona Support or the Community, you must provide sufficient information about your database performance and configuration. A week later, PMM 2.0.41.0 was released with GUI for the PMM Dump.

Monitoring 92

Monitoring Open Source Database Servers 92

Percona

FEBRUARY 14, 2023

Recently, we released Percona Monitoring and Management 2.34 (PMM) which includes upgrades for backup and Database as a Service (DBaaS) features, and we are seeking ways to simplify PMM deployment. Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Monitoring 123

Monitoring Infrastructure Open Source AWS 123

Percona

FEBRUARY 15, 2023

Previously, I wrote about our Terraform provider to deploy Percona Server for MySQL ( Percona Server for MySQL: Automatic Cloud Deployment With Terraform ) and Percona Monitoring and Management ( Deploying Percona Monitoring and Management (PMM) With Terraform ). Download Percona Distribution for MySQL Today

Open Source 124

Open Source AWS Scalability Servers 124

HammerDB

MAY 26, 2022

HammerDB already provides pre-compiled packages from the download page so if you want to run HammerDB without building it then these packages are all you need. You may want to become familiar with all the underlying source code in C or wish to build a distribution where you can verify every single line of source code that goes into HammerDB.

C++ 113

C++ Database Open Source Servers 113

Dynatrace

OCTOBER 7, 2021

Serverless architecture shifts application hosting functions away from local servers onto those managed by providers. This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Serverless architecture: A primer. Application integration.

Serverless 276

Serverless AWS Lambda Storage 276

Dynatrace

DECEMBER 12, 2021

The National Vulnerability Database describes the exploit here. It results in remote code execution (RCE) by submitting a specially composed request. In summary, the Log4Shell exploit allows an attacker to instruct the vulnerable system to download, and subsequently execute, a malicious command. Public Internet Exposure.

Java 238

Java Internet Internet Database 238

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. For example, ensuring software stacks don’t use default accounts or passwords, error handling doesn’t reveal sensitive information, and application server frameworks use secure settings.

Open Source 194

Open Source Artificial Intelligence Internet Internet 194

Dynatrace

JULY 11, 2023

When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database. This backdoor enabled attackers to access MOVEit data and users, download files, insert an administrative user, which enabled attackers to bypass credentials.

Database 156

Database Government Games Servers 156

Percona

MAY 29, 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. This release of Percona Distribution for MongoDB is based on Percona Server for MongoDB 4.4.21-20

Open Source 79

Open Source Servers Scalability Database 79

Dynatrace

MAY 27, 2022

At Dynatrace Perform 2022 , David Walker, a Lockheed Martin Fellow, and William Swofford, a full-stack engineer at Lockheed Martin, discuss how to create a self-diagnosing and self-healing IT server environment using this AIOps combination for auto-baselining, auto-remediation, monitoring as code, and more.

Artificial Intelligence 183

Artificial Intelligence Innovation Servers Database 183

The Netflix TechBlog

OCTOBER 29, 2020

You only need to write platform-specific code where it’s necessary, for example, to implement a native UI or when working with platform-specific APIs. Almost 50% of the production code in our Android and iOS apps is decoupled from the underlying platform. Debugging Kotlin source code from Xcode.

Mobile 279

Mobile Cache Network Architecture 279

Dynatrace

DECEMBER 12, 2021

The National Vulnerability Database describes the vulnerability here. It results in remote code execution (RCE) by submitting a specially composed request. In summary, the Log4Shell vulnerability allows an attacker to instruct the vulnerable system to download, and subsequently execute, a malicious command.

Java 183

Java Internet Internet Database 183

Dynatrace

JANUARY 19, 2020

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. No ABAP code instrumentation or injection is performed.

Monitoring 153

Monitoring Best Practices Infrastructure Servers 153

Smashing Magazine

NOVEMBER 2, 2021

Creating A Magento PWA: Customizing Themes vs. Coding From Scratch. Creating A Magento PWA: Customizing Themes vs. Coding From Scratch. PWAs have been around for over five years, yet native applications outnumber them both in the quantity ratio and how many times users download them. Alex Husar. 2021-11-02T12:00:00+00:00.

Code 74

Code Cache Retail Mobile 74

Smashing Magazine

SEPTEMBER 28, 2022

Every unnecessary bit of JavaScript code you bundle and serve will be more code the client has to load and process. The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. How will you serve blazingly fast code, then?

Cache 125

Cache Performance Servers Social Media 125

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

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. looking out for MongoDB Inc.

Open Source 83

Open Source Programming Database Servers 83

Dynatrace

MAY 31, 2019

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. No ABAP code instrumentation or injection is performed.

Monitoring 160

Monitoring Best Practices Infrastructure Programming 160

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

Dynatrace

JULY 2, 2020

With Dynatrace being able to handle thousands of connected agents, services, containers, servers, and individual user tracking, synthetic monitoring measurements and ingesting external data monitoring becomes a breeze . Part IV: Maintaining configuration as code and configuration management. How large is “large scale”?

Virtualization 178

Virtualization Monitoring Servers Architecture 178

Percona

JULY 19, 2023

Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $ cd $HOME $ wget [link] $ tar -xvzf percona-server-8.0.32-24.tar.gz mkdir ~/percona-server-8.0.32-24/plugin/ulid/ 24/plugin/ulid/ $ cd ~/percona-server-8.0.32-24/plugin/ulid/

C++ 82

C++ Servers Benchmarking Best Practices 82

Percona

DECEMBER 12, 2022

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Download Percona Distribution for PostgreSQL 12.13. Download Percona Distribution for PostgreSQL 11.18. Take a look!

Open Source 63

Open Source Azure Database Servers 63

Percona

OCTOBER 16, 2023

This is something that is available in other databases but not provided in upstream, vanilla Postgres. The server should inform you that it is already installed. If you create a new database, you will have to re-create the extension side of it as below. Download Percona Distribution for PostgreSQL Today! What is TDE?

Open Source 114

Open Source Testing Database Design 114

Percona

DECEMBER 15, 2023

A database role can have a number of attributes that define its privileges and interact with the client authentication system.One such attribute is the CREATEROLE attribute, which is important to PostgreSQL database management of users and roles.

C++ 96

C++ Database Open Source Systems 96

Percona

APRIL 3, 2023

SET WITHOUT OIDS; A list of tables with the problem is in the file: tables_with_oids.txt Failure, exiting postgres@xx.xx.xx.xx:~$ more tables_with_oids.txt In database: abs_test public.craft public.ports In database: postgres public.oid_test We can use the below SQL to find tables with OID, and it also generates the DDL to remove.

C++ 104

C++ Database Cache Storage 104

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

Dynatrace

JANUARY 20, 2020

We do this by reporting on every T-code execution of every SAP user (SAP T-code, or transaction code, is a shortcut key that provides direct access to the desired transaction from anywhere within the SAP system). Was it the server, the network, or the database that caused the degraded response time?

Monitoring 152

Monitoring Performance Infrastructure Network 152

Percona

AUGUST 30, 2023

If a PostgreSQL user wants to change these values, they need to recompile the PostgreSQL from the source code. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. But changing this is possible only at the server startup. But they are generally used by client tools.

Database 105

Database Servers Open Source Tuning 105

Smashing Magazine

MAY 5, 2021

Smaller HTML means less time for Google to download and process those long strings of text. Usually, the HTML code size is not a big issue, especially for small pages, not data-intensive, or pages that are not SEO-oriented. Part of having a small LCP is to let the user download as small HTML as possible. React got the data.

Google 110

Google Architecture Servers Speed 110

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Marked in red in Figure 1 is a server with less than 30% of CPU usage. These color-coded states on panels are available in PMM 2.32.0

Cloud 121

Cloud Serverless AWS Storage 121

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 85

Availability Open Source Architecture Database 85