Category: Administration

Avoid using OFFSET and LIMIT in paginated queries

Gone are the days when database performance optimization was not a concern. Time does not stand still. Every new tech entrepreneur wants to create the next Facebook while striving to gather all the data they can reach. This data is essential for businesses to better train models that help generate revenue. In such conditions, developers […]

Modern Applications on OpenShift, Part 2: Chained Builds

Hello everyone! Welcome to the second post in our series where we demonstrate how to deploy modern web applications on Red Hat OpenShift. In the previous post, we briefly touched on the capabilities of the new S2I (source-to-image) builder image, designed for building and deploying modern web applications on the OpenShift platform. While we focused on the topic of rapidly deploying applications last time, today we will explore how […]

3. Check Point SandBlast Agent Management Platform. Threat Prevention Policy.

Welcome to the third article in the series about the new cloud console for personal computer protection — Check Point SandBlast Agent Management Platform. As a reminder, in the first article, we introduced the Infinity Portal and created a cloud service for managing agents called the Endpoint Management Service. In the second article, we examined the web console interface and installed the agent with the default policy […]

Best in its class: the history of the AES encryption standard

Since May 2020, official sales of WD My Book external hard drives, which support hardware encryption AES with a 256-bit key, have started in Russia. Due to legal restrictions, previously such devices could only be purchased in foreign electronics online stores or on the 'gray' market, but now anyone can obtain a secure drive with a three-year warranty from Western Digital. […]

A New Look at the Clouds. What is a Private Cloud?

The growth of computing power and the development of x86 virtualization technologies on one hand, and the spread of IT outsourcing on the other, have led to the concept of utility computing (IT as a utility service). Why not pay for IT just like we do for water or electricity – precisely as much and precisely when it's needed, and not more. At this moment […]

The first update of Windows Package Manager Preview (v0.1.41821) has been released.

We present the first update for Windows Package Manager. If you are a participant of the Windows Insider or Package Manager Insider program, you should already have the latest updates installed. If you are an insider and do not have them, launch the store and check for updates. If you would prefer to simply download the client, go to the releases page at […]

How Google BigQuery Democratized Data Analysis. Part 1

Hello, Habr! Right now, OTUS is accepting applications for a new cohort of the 'Data Engineer' course. Ahead of the course start, we have traditionally prepared a translation of interesting material for you. Every day, over one hundred million people visit Twitter to find out what is happening in the world and discuss it. Every tweet and any other user action generates an event available internally […]

PostgreSQL Antipatterns: 'There Can Be Only One!'

In SQL, you describe 'what' you want to get, not 'how' it should be executed. Thus, the problem of developing SQL queries in a 'as it sounds, so it is written' style takes its honorable place, alongside the peculiarities of condition evaluation in SQL. Today, through very simple examples, we will look at what this can lead to in the context of using GROUP/DISTINCT and LIMIT together with them. […]

PostgreSQL Antipatterns: condition evaluation in SQL

SQL is not C++ or JavaScript. Therefore, the evaluation of logical expressions occurs differently, and this is not the same: WHERE fncondX() AND fncondY() = fncondX() && fncondY(). In the process of optimizing the execution plan of the query, PostgreSQL can arbitrarily 'rearrange' equivalent conditions, not evaluate some of them for individual records, relating to […]

We enable event logging for suspicious process launches in Windows and identify threats using Quest InTrust

One of the common types of attacks is the spawning of a malicious process within a tree of otherwise legitimate processes. Suspicion may arise from the path to the executable file: malware often uses AppData or Temp folders, which is uncharacteristic of legitimate programs. Fairness dictates noting that some automatic update utilities run in AppData, so merely checking the location […]

Riak Cloud Storage. Part 1. Configuring Riak KV

Riak CS (Cloud Storage) is user-friendly software for organizing object storage, built on top of Riak KV. Riak (KV) is a distributed NoSQL key-value database. Riak CS is designed to provide simplicity, availability, and distribution of cloud storage at any scale, and can be used for building cloud architectures — both public and private — or […]

Canary Deployment in Kubernetes #3: Istio

Using Istio+Kiali for Running and Visualizing a Canary Deployment Articles in this series Canary Deployment in Kubernetes #1: Gitlab CI Canary Deployment in Kubernetes #2: Argo Rollouts (this article) Canary Deployment using Jenkins-X Istio Flagger Canary Deployment We hope you read the first part, where we briefly explained what Canary deployments are and showed how to implement it with […]

Buy reliable website hosting with DDoS protection, VPS VDS servers 🔥 Buy reliable website hosting with DDoS protection, VPS VDS servers | ProHoster