26th Nov 2020 Understanding the Concept of Branches in Git Using branches in your day-to-day work might very well prove to make you a better programmer or designer. Be that as it may, it's definitely one of the main reasons why Git is so highly respected. dev.to
26th Nov 2020 Setting up PostgreSQL for Debezium Debezium is a popular Open Source change data capture (CDC) solution. It’s based on a set of well-established components (Kafka, Kafka Connect, ZooKeeper) and used successfully in production by companies like Dehlivery or BlaBlaCar. elephanttamer.net
26th Nov 2020 Troubleshooting using Wait Stats in SQL Server Troubleshooting using Wait Stats in SQL Server is an important perspective when it comes to managing databases. As a database professional, you might have come across situations, where your end-users are not happy with reports being slower. sqlshack.com
26th Nov 2020 DB2 v11.5.4 REST API – Bonus Blog Enabling clients to interact via HTTP GET/POST requests the REST API functionality provides clients a lightweight, modern interface to data stored in DB2 databases. triton.co.uk
26th Nov 2020 How a Top Game Company Uses Chaos Engineering to Improve Testing NetEase Fuxi AI Lab is China's first professional game AI research institution. pingcap.com
26th Nov 2020 DBATOOLS: introducción e instalación En esta entrada solo hemos querido cubrir la presentación del módulo y su instalación. Prometemos en futuras artículos realizar varias tareas y operaciones con DBATools. sicuel.es
26th Nov 2020 Build it and they will come: JetBrains gets grip on MongoDB with v2020.3 of database IDE While an IDE for database or SQL programmers might sound weird at first, it actually can be pretty useful. JetBrains’ DataGrip is such a tool and is now available in version 2020.3. devclass.com
26th Nov 2020 Monitoring Percona Server for MongoDB - Key Metrics When running critical database services in production, we need to know and monitor the database. You need to understand the key metrics in the database that you are using. severalnines.com
26th Nov 2020 PostgreSQL High Availability: Setup and Uptime Considerations My previous blog on “PostgreSQL High Availability: Considerations and Candidates” mostly talked about defining an HA considerations for PostgreSQL, RPO and RTO and briefly touched on some of the open source solutions available. highgo.ca
25th Nov 2020 Tutorial: Register and Configure Kubernetes Clusters with Azure Arc This article is the third part of the Azure Arc series, where we explore Arc enabled Kubernetes clusters. We will also configure GitOps to consistently deploy workloads across all the registered clusters. thenewstack.io
25th Nov 2020 DynamoDB PartiQL – part II: SELECT . In the previous post I insertd a few rows in a Demo table using the SQL-like new API on DynamoDB. I checked my items with a SELECT but was limited in the ORDER BY clause. Here is the most important to understand: there are no additional data processing engine here. blog.dbi-services.com
26th Nov 2020 Why Data Engineering Needs Automated Testing This is the start of a series of articles about building test harnesses for big data workflows in the cloud. In this first part I’m going to explain why automated testing is one of the most useful tools for building maintainable data workflows. medium.com
26th Nov 2020 Two Approaches to AWS Solution Design After several years working with AWS services in multiple projects with different roles from developer, operator to architect. When I design or evaluate a solution, I am using two approaches: DevOps model and Well-Architected Framework. vinh-le.medium.com
26th Nov 2020 Impacts of many tables in a Cassandra data model As Apache Cassandra consultants, we get to review a lot of data models. Best practices claim that the number of tables in a cluster should not exceed one hundred. But we rarely see proper benchmarks evidencing the impact of excessive tables on performance. thelastpickle.com
25th Nov 2020 How to Create an AWS Continuous Deployment Pipeline Creating a continuous deployment pipeline will bring us a step closer to an automated build, test, deploy strategy. In order to create such a pipeline, we need to have access to several tools. Instead of installing these on on-premise servers, we can make use of the AWS cloud offer. mydeveloperplanet.com
25th Nov 2020 Go inside the new Azure Defender for IoT including CyberX In 2020, the move toward digital transformation and Industry 4.0 took on new urgency with manufacturing and other critical infrastructure sectors under pressure to increase operational efficiency and reduce costs. microsoft.com
25th Nov 2020 How we eliminated service outages from ‘certificate expired’ by setting up alerts with Grafana and Prometheus Here at Grafana Labs we are lucky to work with many partners around the globe. From these partnerships, we get great inspiration into some clever use cases on how Grafana and Prometheus can be used to great effect for service monitoring and availability. grafana.com
25th Nov 2020 Using Postgres for Statistics: Centering and Standardizing Data In the last two blog posts on data science in Postgres, we got our data ready for regression analysis and had predictive variables that are on wildly different scales. Another example of data on different scales would be annual income versus age. info.crunchydata.com
25th Nov 2020 Is 2FA by SMS a bad idea? Two-factor authentication is ubiquitous and it’s a really valuable tool to protect systems and data assets. But with increasing reliance on home working and remote access in the current pandemic, what mechanism should we choose? itsecurityguru.org
25th Nov 2020 Serving Content Using a Fully Managed Reverse Proxy Architecture in AWS With the trends to autonomous teams and microservice style architectures, web frontend tiers are challenged to become more flexible and integrate different components with independent architectures and technology stacks. Two scenarios are prominent: aws.amazon.com
25th Nov 2020 MongoDB at AWS re:Invent 2020 While 2020 has been a challenging year, it has also given rise to new levels of innovative collaboration and agile thinking. mongodb.com
25th Nov 2020 Simplifying Query & Index with Collections Couchbase Collections available with the upcoming version 7 brings Couchbase JSON database closer to that of other RDBMS. Collections will make it easier for customers who are looking to migrate their current RDBMS data model to Couchbase document model. blog.couchbase.com
25th Nov 2020 Be Careful Where You Use AT TIME ZONE Databases really do make you pay dearly for mistakes, and new linguistic functionality is not implemented with performance in mind. And it turns out that this lesson is brutally true if you need to pass time zones around, too. erikdarlingdata.com
25th Nov 2020 8 Easy Steps to prepare for Microsoft Azure Data Fundamentals DP-900 Certification Exam Hello Readers! Welcome back. If you are planning to prepare for the Microsoft Azure Data Fundamentals DP-900 exam, then you have arrived at the right place. With the advent of role-based certifications, Microsoft has come up with specific data service certifications, code named as the DP series i.e. blog.cloudthat.com
25th Nov 2020 MariaDB Server MiniFest Wed 9 Dec 2020 New MariaDB releases come with regular intervals. Releasing a new version is a balance between new functionality and bugfixes on one side, and stability on the other. mariadb.org
25th Nov 2020 Collecting, storing, and analyzing your DevOps workloads with open-source Telegraf, Amazon Timestream, and Grafana Telegraf is an open-source, plugin-driven server agent for collecting and reporting metrics. Telegraf offers over 230 plugins to process a variety of metrics from datastores to message queues, including InfluxDB, Graphite, OpenTSDB, Datadog, and others. aws.amazon.com
25th Nov 2020 Top n Window Function queries in MySQL Top n Window Function queries over a specific subset of data are common in analysis and reporting requirements. Luckily, in MySQL, there are Window functions we can use for this type of query. To be quite honest, you don’t necessarily need Window Functions. joshuaotwell.com
25th Nov 2020 Ansible Custom Interactive Dynamic Inventory When working with an Ansible dynamic inventory, you may want to update it from your playbook on the fly. For instance, you may want to create a server and then install an application on it without calling a second playbook or developing specific code to create a runtime group (e.g. blog.dbi-services.com