4th Jan 2021 The Coming Era of Data as Code (This month, The New Stack examines the management of data in cloud native systems, with a series of news posts, contributed essays and podcasts. Check back often on the site for new content). thenewstack.io
4th Jan 2021 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
4th Jan 2021 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
4th Jan 2021 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
4th Jan 2021 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
4th Jan 2021 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
4th Jan 2021 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
4th Jan 2021 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
4th Jan 2021 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
4th Jan 2021 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). dev.to
4th Jan 2021 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. dev.to
4th Jan 2021 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). dev.to
4th Jan 2021 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. dev.to
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
30th Dec 2020 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
30th Dec 2020 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
30th Dec 2020 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
30th Dec 2020 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
30th Dec 2020 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
30th Dec 2020 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
30th Dec 2020 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
30th Dec 2020 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
30th Dec 2020 A brief guide to testing in DevOps What is testing in DevOps? DevOps – as the term notes, is the practice that encourages partnership between development and IT operation teams to suit the aspirations of continuous integration and continuous deployment (CI/CD) and modern software delivery. zucisystems.com