Smashing Magazine

SEPTEMBER 17, 2021

Gatsby Functions open up a whole new world for front-end developers as they provide a way to write and use server-side code without the hassle of maintaining a server. Third-party services like the ones mentioned above will only accept requests that are sent server-side. website.com , and www.my-website.com/api

Open Source 115

Open Source Serverless Software Software 115

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. What is PostgreSQL used for? Is PostgreSQL enterprise-ready?

Open Source 78

Open Source Healthcare Social Media Database 78

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. Use the following code to create a table called dbo.T1, and a view called dbo.V1 Use the following code to query the view: SELECT * FROM dbo.

Code 117

Code Database Servers Availability 117

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

High Scalability

FEBRUARY 1, 2022

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Apply here.

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

DECEMBER 9, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Apply here.

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

AUGUST 24, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Apply here.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

OCTOBER 27, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Apply here.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 29, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Apply here.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Apply here.

Education 100

Education DevOps Infrastructure Benchmarking 100

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

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

Percona

JULY 24, 2023

With the use of this snapshot CLI, you can now build your backup strategy using the snapshot tools at your disposal or include PBM into your existing strategy, even using existing snapshots of Percona Server for MongoDB ! Of course, each release also includes bug fixes and refining some of the existing features.

Availability 75

Availability Open Source Strategy Storage 75

High Scalability

MARCH 18, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Scalability Infrastructure 100

High Scalability

MARCH 18, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Scalability Infrastructure 100

High Scalability

JULY 15, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JUNE 29, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JUNE 8, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

MAY 18, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Scalability Infrastructure 100

High Scalability

APRIL 7, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Scalability Infrastructure 100

SQL Performance

MAY 11, 2022

By following some basic tips you can sometimes reduce the number of explicit sort operators, which can, of course, have a major impact on the performance of the query. In my examples, I’ll use the sample database PerformanceV5. You can download the source code to create and populate this database here.

C++ 133

C++ Database Servers Code 133

High Scalability

MARCH 18, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps AWS Scalability 100

Percona

APRIL 21, 2023

3306, I created a test database: mysql> create database test; Query OK, 1 row affected (0.00 So with injecting an empty transaction, the Orchestrator will inject the empty transaction from the top, it will replicate to the bottom, and that GTID will be ignored by the replica server, which already has it. 3306 0s ok 5.7.41-44-log

C++ 83

C++ Monitoring Database Open Source 83

SQL Performance

OCTOBER 9, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. The EOMONTH function was introduced in SQL Server 2012. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT.

C++ 111

C++ Database Servers Code 111

Smashing Magazine

NOVEMBER 19, 2021

We’ll be focusing on three places where you can get the wildcard: Server Side In getServerSideProps , Client Side With useEffect , Server Side On API Routes And Edge Functions. Server Side In getServerSideProps. It is, of course, still handy to know. Server Side On API Routes And Edge Functions. More after jump!

Servers 84

Servers Website Code Best Practices 84

SQL Performance

AUGUST 11, 2021

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. This code generates the following output: 2021-02-12 00:00:00.0000000. DATE_BUCKET.

Azure 139

Azure Code Database Servers 139

Particular Software

JANUARY 27, 2020

Since it exists in Windows 10 and Windows Server 2019, MSMQ will continue to live on until at least 2029—and much longer assuming it isn't removed from future versions of Windows. Microsoft would of course prefer you use MSMQ's younger sibling, Azure Service Bus , but there are a lot of other options out there. for more details.

Transportation 98

Transportation Azure Open Source Systems 98

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. DROP TABLE IF EXISTS dbo. Transactions. (

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

JULY 1, 2021

There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler. USE BadIdeas ; GO. CREATE TABLE dbo. name , [ Object ] = o.

C++ 58

C++ Database Servers Performance 58

Smashing Magazine

SEPTEMBER 20, 2021

And of course, scrapers could scrape your site to look for security vulnerabilities or exposed contact or sales lead details. When your content is delivered by other means, from other servers or platforms, it can put the user experience and commercial relationship you have built up with your users at risk. Large preview ).

Website 89

Website Analytics Cache Google 89

SQL Performance

APRIL 13, 2022

It’s based on a question from a public database forum. Use the following code to create a table called T1 and populate it with a small set of sample data: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Use the following code to create the helper function GetNums: CREATE FUNCTION dbo. The challenge. CREATE TABLE dbo.

C++ 136

C++ Strategy Testing Servers 136

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 91

Open Source Database Hardware Strategy 91

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52

Tuning Benchmarking Engineering C++ 52

SQL Performance

MAY 13, 2020

I just wanted to mention some use cases here to illustrate how important table expressions are in our T-SQL code, and why it's worthwhile to invest in understanding their fundamentals well. In my examples I'll use a sample database called TSQLV5. In this month's article I focus on the logical treatment of derived tables specifically.

C++ 143

C++ Code Design Servers 143

Particular Software

JANUARY 5, 2021

When that happens, you will be much less likely to remove old code because you won’t have any idea if it’s necessary or not. Of course, we want to be Agile. Design systems to be easily maintainable: See what Udi has to say in Day 1 of his Advanced Distributed Systems Design video course.

Systems 59

Systems Availability Architecture Design 59

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. Use the following code to create the Orders table and populate it with a small set of sample data to help you verify the validity of the solutions: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo.

C++ 112

C++ Code Azure Database 112

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117