The Coming Era of Data as Code

PostgreSQL is the DBMS of the Year 2020

For determining the DBMS of the year, we subtracted the popularity scores of January 2020 from the latest scores of January 2021. We use the difference of these numbers, rather than a percentage, because that would favor systems with a tiny popularity at the beginning of the year.

db-engines.com

Identify the (Top 20) most expensive queries across your SQL Server using Query Store

I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to identify the most resource hungry queries across a SQL instance. There are lots of versions of this sort of query around the place if you google for “Top 20 queries”.

matthewmcgiffen.com

Implement an Amazon Aurora Serverless cluster

In this 4th article for the Amazon Aurora series, we will discuss and implement an Amazon Aurora Serverless cluster. Amazon Aurora offers a managed relational database environment compatible with MySQL and PostgreSQL databases.

sqlshack.com

Plansplaining, part 15. Foreign keys, part 4

Welcome to part fifteen of the plansplaining series. In the three previous parts I looked at the operators and properties in an execution plan that check a modification doesn’t violate foreign key constraints. That part is done. But I’m not done with foreign keys yet.

sqlserverfast.com

Working With Queries Using Entity Framework Core and Entity Developer

A developer and DZone Core member gives a tutorial on how to create database queries using Entity Framework Core and Entity Developer. Introduction Entity Developer is a popular ORM tool from Devart with many interesting features.

dzone.com

ICYMI: Serverless Q4 2020

Welcome to the 12th edition of the AWS Serverless ICYMI (in case you missed it) quarterly recap. Every quarter, we share all of the most recent product launches, feature enhancements, blog posts, webinars, Twitch live streams, and other interesting things that you might have missed!

aws.amazon.com

Tech Previews in Percona Monitoring and Management, Percona Distribution for MySQL 8.0.21: Release Roundup January 4, 2021

It’s release roundup time here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

percona.com

Performance impact of idle PostgreSQL connections

The first post of this series, Resources consumed by idle PostgreSQL connections, talked about how PostgreSQL manages connections and how even idle connections consume memory and CPU. In this post, I discuss how idle connections impact PostgreSQL performance.

aws.amazon.com

Understanding Docker: part 25 – Dockerfile: CMD & ENTRYPOINT instructions

Understanding Docker can be difficult or time-consuming. In order to spread knowledge about Cloud technologies I started to create sketchnotes about Docker. I think it could be a good way, more visual, to explain Docker (and other technologies like Kubernetes and Istio).

Finding Winning Stocks with Web Scrapers, and Serverless (AWS Lambda and DynamoDB)

A few friends and I chat about stocks, share ideas, and encourage each other. A few months ago, I realized we needed some automation to help us find winners. I chose to use a serverless solution to build this system. There are many good stocks and finding them takes time.

Production-ready Python

Below are 5 steps to take to build production-ready python applications. The development environment in most cases is different from the production environment. For instance, the development environment for a program will be the programmer's machine (laptop, desktop or tablet).

Migrating to Ubuntu LTS: six facts for CentOS users

Considering migrating to Ubuntu from other Linux platforms, such as CentOS? Think Ubuntu- the most popular Linux distribution on public clouds, data centre and the edge. Since its inception, Ubuntu consistently gains market share, as of today reaching almost 50%.

ubuntu.com

2nd Jan 2021

Database Lab Engine 2.1.0 released

Database Lab Engine is an open-source tool for building powerful development and testing environments based on thin cloning of PostgreSQL databases.

postgresql.org

1st Jan 2021

SQL Server Diagnostic Information Queries for January 2021

These are my SQL Server Diagnostic Information Queries for January 2021, 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

1st Jan 2021

TSQL Query to find the user the SQL services run as

Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick query, or wade through the dialog boxes for the SQL Server services top see what user they are running as.

stevestedman.com

1st Jan 2021

How to monitor CPU utilization in Linux

Monitoring CPU utilization is one of the very important tasks of a back-end system engineer. CPU utilization is nothing but the total works or tasks being processed by your central processing unit or CPU.

31st Dec 2020

Improving MySQL Performance with Advanced InnoDB Settings

We have discussed how to configure InnoDB for high performance a while ago, however, we have not yet discussed how we can improve MySQL performance while making use of advanced InnoDB settings. This blog post should provide a little more insight into this topic.

severalnines.com

31st Dec 2020

SQL Server Copy Table Options

There are times when it is necessary to copy table data using SQL Server native tooling. Does SQL Server have the capability to do so natively? Teams might request that a specific table be copied from a Production environment to another environment.

mssqltips.com

PostgreSQL 13 Benchmark: Memory Speed vs. TPS

Some guys are obsessed with sports or cars. I follow computer hardware. The PC industry has overclocking instead of nitrous, plexi cases instead of chrome, and RGB lighting as its spinning wheels. The core challenge I enjoy is cascading small improvements to see if I can move a bottleneck.

info.crunchydata.com

Database Load Balancing and the Delusion of 3-Tiered Architecture

Rahul Subramaniam Rahul Subramaniam is CEO of EngineYard, DevFactory, and FogBugz. He is also Head of Innovation at ESW Capital. He has a long history working in the computer software industry, with a background in algorithms, python, agile software development, and software project management.

thenewstack.io

MySQL User With wildcard and localhost Hosts

There’s often confusion over why MySQL users are created with a host of localhost in addition to a user created with wildcard, %, for their host.

virtual-dba.com

Monitoring MySQL Performance with ClusterControl

Monitoring the performance of MySQL databases is a daily task of almost every MySQL DBA. In this blog post we will try to demonstrate how to monitor the performance of your MySQL databases - with ClusterControl.

severalnines.com

Migrate Oracle Database 9.2.0.6 to Oracle 19c using GoldenGate

When a customer wanted to take the challenge to migrate an oracle database 9.2.0.6 (the prehistory in the Oracle world) to Oracle 19c using Oracle GodenGate, I saw more problems than add value for different reasons: Oracle 9.2.0.6 database is out of support (final 9.2 patch was Oracle 9.2.0.8).

blog.dbi-services.com

Implementing version control using Amazon DynamoDB

Some applications require you to record changes to data over time, and you can identify these changes by a timestamp or number so it’s possible to retrieve specific versions later.

aws.amazon.com

The shibboleth of PostgreSQL

After all the technical articles I have written, I thought it would be nice to write about PostgreSQL sociology for a change. A community like PostgreSQL has no clearly defined borders. There is no membership certificate; you belong to it if you feel that you belong.

cybertec-postgresql.com

Creating database objects in Azure Data Lake Analytics using U-SQL

This article will help you create database objects in Azure Data Lake Analytics using U-SQL. In the fourth part of this article series, Deploying U-SQL jobs to the Azure Data Analytics account, we learned how to deploy U-SQL jobs on Data Lake Analytics.

sqlshack.com