Options For Fixing Parallel Deadlocks

Architecting for Reliable Scalability

Cloud solutions architects should ideally “build today with tomorrow in mind,” meaning their solutions need to cater to current scale requirements as well as the anticipated growth of the solution.

Running Hyperledger Explorer on Amazon Managed Blockchain

In the first post of this series, you learned how to build a Hyperledger Fabric network using Amazon Managed Blockchain. In this post, you deploy and run Hyperledger Explorer to visualize the Fabric network that you created.

Building Serverless Land: Part 1 – Automating content aggregation

In this two part blog series, I show how serverlessland.com is built. This is a static website that brings together all the latest blogs, videos, and training for AWS Serverless. It automatically aggregates content from a number of sources.

jonathanlewis.wordpress.com

FBI or Virtual

This note has has been sitting with the other 800 drafts since some time in May 2019, and started with a comment about following on from “a recent talk on how to engineer indexes properly”. Unfortunately I don’t remember when I wrote it, or why it came about.

An Overview of User-defined SQL Server Types

In this article, we will explore User-defined SQL Server Types and their usage. SQL Server supports various data types for storing different kinds of data. These data types store characters, numeric, decimal, string, binary, CLR and Spatial data types.

sqlshack.com

The Tao of Db2!

A couple of years ago now, I published a series of blog posts here on the Db2 Portal blog under the title: The Tao of Db2. The general idea of the series was to offer some high-level, in-the-trenches guidance for Db2 database administrators.

db2portal.blogspot.com

Zero Downtime MySQL

You’re invited to join this webinar with Continuent CEO Eero Teerikorpi to find out how Kentucky Lottery achieved continuous MySQL operations with high availability, data protection, and disaster recovery using a Composite Active/Passive Tungsten Clustering Topology.

continuent.com

Azure Cosmos DB goes serverless

Azure’s Cosmos DB is one of the platform’s foundations, powering many of its key services. Designed from the ground up as a distributed database, it implements a set of different consistency models allowing you to trade off between performance and latency for your applications.

infoworld.com

mahmoudhatem.wordpress.com

Oracle DbNest and Network isolation/Namespace

In my previous articles we have seen how oracle DbNest is taking advantage of the underling Linux namespaces features for enhancing the database security. We have taken a closer look at the user,mount and pid namespaces as they are the one used by default when enabling DbNest.

Having a 2nd look at Postgres v13 improvements

Version 13 has been out there for over a month by now and the most important stuff has already been well digested… but luckily (or not) there’s so much non-major stuff in every release! This becomes quite evident when looking at the release notes with its 150 items of change or peeking at the gr

cybertec-postgresql.com

Database Fundamentals #29: Create Foreign Keys With Table Designer

The purpose of a foreign key is to ensure data integrity by making sure that data added to a child table actually exists in the parent table and preventing data from being removed in the parent table if it’s in the child table.

sqlservercentral.com

Protect your SQL Server from Ransomware: Backup Your Service Master Key and More

Not many disaster recovery or SQL migration/upgrade scenarios require the SQL Server instance service master key to be restored. Some do.

sqlservercentral.com

Server side rollback at statement level for PostgreSQL

The initial release v1.0 of pg_statement_rollback was released today. If at any time during execution a SQL statement causes an error, all effects of the statement are rolled back. The effect of the rollback is as if that statement had never been run.

postgresql.org

Handling the Duplication of Records – SQLServerCentral

While working with one of my Risk Advisory clients, I came upon an issue of duplicate records reported from an application user. This user noticed the problem on one of the critical reports that is sent out to the higher management group on weekly basis.

sqlservercentral.com

Why run MySQL on ARM - Part 2

In the previous blog, we saw that users don’t lose anything by moving to MySQL on ARM. Infact, users are set to gain performance and save cost. In this blog post we will see performance numbers and analyze them to understand points where ARM scores. Benchmarking is done using sysbench.

mysqlonarm.github.io

Working with {JSON} in SQL Developer Web

Brand new for SQL Developer Web version 20.3 – a complete interface for working with your JSON Collections in the Oracle Database!

thatjeffsmith.com

Amazon EC2 P4d instances deep dive

AWS is excited to announce that the new Amazon EC2 P4d instances are now generally available. This instance type brings additional benefits with 2.

An Overview of Real Time Data Warehousing on Cloudera

Users today are asking ever more from their data warehouse. This is resulting in advancements of what is provided by the technology, and a resulting shift in the art of the possible.

blog.cloudera.com

Introducing the MongoDB Enterprise plugin for Grafana

MongoDB is one of the most popular NoSQL databases in the world, used by millions of developers to store application metrics from e-commerce transactions to hospital equipment inventory, from user logins to First World War diaries.

grafana.com

An Overview of the Percona XtraDB Cluster Kubernetes Operator

If you have been around in the container world, you would know that it is pretty challenging to adopt a full Kubernetes automation for a clustered database system, which commonly adds a level of complexity to the container-based architecture for these stateful applications.

severalnines.com

Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up]

Postgres is a great database engine but what are the best ways to load data into it? This webinar was hosted by Shaun Thomas, who currently works as a principal consultant at 2ndQuadrant and maintains his PG Phriday blog through the 2ndQuadrant blog site.

2ndquadrant.com

PostgreSQL Security Features to AAA Framework

Marc Linster, Ph.D., is EDB’s Senior Vice President of Product Development and leads EDB’s engineering divisions and product development groups.

enterprisedb.com

Understanding MySQL Memory Usage with Performance Schema

Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected memory usage, i.e. when you have MySQL Server using a lot more than you would expect based on your configuration settings.

percona.com

Redis TLS Can Significantly Reduce Performance — A Look at How KeyDB Addressed This

We saw ~ 36-61% performance decline with Redis 6 TLS enabled. KeyDB addressed this using a multithreaded architecture to avoid the performance decline. We were extremely excited about TLS (Transport Layer Security) support which arrived in the '6.0' versions of Redis and KeyDB.

dzone.com

Python snakes within hissing distance of Java in battle of the langs

The TIOBE industry survey of the top 100 programming languages by popularity for October 2020 shows two main trends – Java’s accelerating decline and Python’s growing popularity. Java has lost the top spot to venerable systems language C, which takes the catbird seat with a 0.

devclass.com

SQL Server Diagnostic Information Queries for November 2020

These are my SQL Server Diagnostic Information Queries for November 2020, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a short amount of time.

glennsqlperformance.com