Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. This blog article traces key developments that coincided with MongoDB’s move away from open source software, and it examines how SSPL influence might have lured others in the same direction.

Open Source 83

Open Source Programming Database Servers 83

SQL Performance

SEPTEMBER 16, 2021

To finish up my short series of articles on latches, this time I’m going to discuss a few other latches in SQL Server you might see occasionally but don’t merit a complete article by themselves. The post SQL Server Latches – Other Latches To Know About appeared first on SQLPerformance.com. The LOG_MANAGER Latch.

Servers 57

Servers Storage Efficiency Database 57

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The feedback from users was that “backup management is a must ” and “we need something that allows us to manage all of our database backups in one place, not server by server.”

Open Source 91

Open Source Database Operating System Programming 91

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. That issue is slow server response times. There’s very little browser optimisations can do to improve a page that is simply slow to build on the server. Encompassed in that wait time is everything the server needs to do to build the page.

Servers 87

Servers Performance Metrics Database 87

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. One of the reasons for that is because a PWA has the same code base. So unlike the case with native applications, the progressive web app needs to be coded only once. Alex Husar.

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? More after jump!

Performance 125

Performance Cache Servers Social Media 125

Dynatrace

JULY 23, 2019

When comparing Django and Flask , developers like to highlight that Django provides an all-inclusive experience for developers: you get an admin panel, database interfaces, ORM, and directory structure for your applications and projects out of the box. All the sample code including instrumentation is available on GitHub.

Monitoring 136

Monitoring Software Software Database 136

Tech News Gather

MARCH 30, 2022

It is a combination of programming languages, frameworks, libraries, patterns, servers, UI/UX solutions, software, and tools used by developers. In this article, we will see what technology stack to choose for your project? Structure-wise, the tech stack consists of two elements: Front-end or client-side and server-side or back end.

Technology 96

Technology Technology C++ Java 96

Percona

AUGUST 3, 2023

In this article, I want to discuss a couple of pretty new features in MySQL 8.0 — and an older one. Suppose you have SELECT * queries in your application code. As an experienced database developer, you should know that these kinds of queries should not exist in any production code. Here come the invisible columns.

Best Practices 79

Best Practices Open Source Code Engineering 79

SQL Performance

JULY 14, 2021

The code that I’ll be using in this article can be executed in any database, but in my demos, I’ll be using TSQLV5—the same sample database that I used in previous articles. In the conclusion section of last month’s article I posed a question as food for thought. V1 ; DROP TABLE IF EXISTS dbo.

Code 117

Code Database Servers Availability 117

SQL Performance

OCTOBER 18, 2022

Before SQL Server 2022, there was a workaround that enabled relying on index order, but besides being quite ugly, it had its cost, and the tradeoff wasn’t always acceptable. SQL Server 2022 introduces new ways to apply time-based grouping using the DATE_BUCKET and DATETRUNC functions. Optimization of Traditional Time-Based Grouping.

Servers 144

Servers Code Best Practices Database 144

SQL Performance

MAY 11, 2022

In my examples, I’ll use the sample database PerformanceV5. You can download the source code to create and populate this database here. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. For simplicity’s sake, you can prevent parallelism in all examples shown in this article.

C++ 133

C++ Database Servers Code 133

Dynatrace

NOVEMBER 23, 2020

Kubernetes Dashboard as a part of a comprehensive monitoring solution This article introduces the key building blocks to consider when designing your Kubernetes monitoring solution. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 160

Virtualization Infrastructure Monitoring Cloud 160

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. I wrote this article based on the Docker-maintained repository. What are MongoDB Docker Containers?

Scalability 60

Scalability Best Practices Servers Database 60

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 ).

C++ 109

C++ Database Servers Code 109

Scalegrid

JANUARY 9, 2024

This article delivers direct insights on solid security frameworks, agile defensive tactics, and compliance adherence, providing the blueprint to reinforce your enterprise against the rigors of the cloud. This process involves converting regular data into a coded form, which helps to protect its privacy and guard against cyber threats.

Strategy 130

Strategy Cloud Best Practices Government 130

Percona

JUNE 27, 2023

Percona Alerting was introduced in Percona Monitoring and Management (PMM) 2.31, and it brought a range of custom alerting templates that makes it easier to create Alert rules to monitor your databases. GF_SMTP_HOST: Host address of your SMTP server. GF_SMTP_USER: Username for SMTP authentication. Alerts.Firing | len }} {{ if gt (.Alerts.Resolved

Monitoring 78

Monitoring Open Source Database Servers 78

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 ).

C++ 93

C++ Database Servers Code 93

O'Reilly

JUNE 13, 2023

After fixing some obvious errors, I ran the program–and while it told me (correctly) that my number was non-prime, when compared to a known good implementation of Miller-Rabin, ChatGPT’s code made many mistakes. It didn’t generate any code, but provided a link to the Wolfram Alpha result page that described how to test for primality.

Google 83

Google Programming Database Testing 83

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. 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. Test Environment. BountyAmount.

Servers 86

Servers Tuning Database Efficiency 86

Smashing Magazine

SEPTEMBER 17, 2021

In this article, I’ll be explaining how I’ve used Gatsby Functions and the Stripe API to enable secure “Pay what you want” contributions that help fund my open-source project MDX Embed. Third-party services like the ones mentioned above will only accept requests that are sent server-side. Paul Scanlon. 2021-09-17T09:00:00+00:00.

Open Source 114

Open Source Serverless Software Software 114

SQL Performance

OCTOBER 9, 2019

My good friend Aaron Bertrand inspired me to write this article. In this article I cover a number of T-SQL features that are either often entirely overlooked, or that support parameters or capabilities that are often overlooked. In my examples I'll use a sample database called TSQLV5. EOMONTH has a second parameter.

C++ 111

C++ Database Servers Code 111

Smashing Magazine

AUGUST 28, 2020

In this article we’re going to be learning about the following: Installation of Django. This article will guide you through understanding Django’s pre-built commands, files and basics. Learn more django-admin uses here ; it is a little beyond the scope of this article. The startproject and startapp commands. Installing Django.

Virtualization 143

Virtualization Database Code Processing 143

Dynatrace

JULY 2, 2019

For instance, alert me when an error 999 is detected in application server logs or any HTTP 500 error from the web server access log. Automatic failure detection works well in most cases especially for web services and when developers follow good coding practices. Code. …. }. Code. …. }. Uncaught exceptions.

Tuning 115

Tuning Artificial Intelligence Code Java 115

SQL Performance

AUGUST 11, 2021

In this article, I cover two methods for bucketizing date and time data. Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. In my examples, I’ll use the sample database TSQLV5. DATE_BUCKET.

Azure 139

Azure Code Database Servers 139

SQL Performance

MARCH 29, 2022

When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. The bigint type isn’t used for server-side parameterization.

Cache 90

Cache Servers Database Testing 90

Percona

APRIL 21, 2023

In this article, we will discuss errant Transaction /GTID and how we can solve them with the Orchestrator tool. 3306, I created a test database: mysql> create database test; Query OK, 1 row affected (0.00 3306 0s ok 5.7.41-44-log 44-log rw ROW GTID + 192.168.56.20:3306 3306 0s ok 5.7.41-44-log 3306 0s ok 5.7.41-44-log

C++ 86

C++ Monitoring Database Open Source 86

Dynatrace

AUGUST 9, 2023

Instead, we want to focus on detecting and stopping attacks before they happen: In your applications, in context, at the exact line of code that is vulnerable and in use. Some of our applications were treating environment variables in an insecure way or communicating with the Kubernetes API server with improperly configured service accounts.

Analytics 192

Analytics AWS Strategy Infrastructure 192

SQL Performance

JULY 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54

C++ Servers Database Code 54

Smashing Magazine

NOVEMBER 19, 2021

For example, later in this article, we’ll be developing a web toy that flips a webpage upside down making it readable for Australians. When developing locally, it can be a pain to simulate wildcard domains and we’ll be touching on this a fair bit later on in this article but it is something important to keep in mind. More after jump!

Servers 83

Servers Website Code Best Practices 83

SQL Server Performance

JANUARY 3, 2019

In this article series we will focus on the primary points of T-SQL performance tuning. Temp Tables and Table Variables Most database developers are used to breaking down code into small chunks using temp tables or table variables […].

Tuning 40

Tuning Servers Database Code 40

SQL Performance

AUGUST 14, 2019

This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. In my examples I'll use a sample database called TSQLV5. Previously I covered determinism , subqueries and joins. Transactions. (

Best Practices 108

Best Practices Servers Database Azure 108

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

tRPC

MAY 4, 2021

I've not published any articles about, so I'm just writing this intro to get the ball rolling (but we have already somehow reached >530 ? Expect articles & video intros to come! In short - tRPC gives you end-to-end type safety from your (node-)server to your client, without even declaring types. on GitHub).

Servers 52

Servers Code Database 52

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. This article is dedicated to such a case—specifically, a standard SQL feature related to window functions called the GROUPS window frame option. So you have to come up with a supported alternative.

C++ 112

C++ Code Azure Database 112

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40