13th Apr 2021 Regression Analysis in PostgreSQL with Tensorflow: Part 2 - Data Pre-processing In part 1 of this blog mini-series on machine learning, we looked at how to setup PostgreSQL so that we can perform regr... enterprisedb.com ⏰ 10 mins
13th Apr 2021 HeatWave – A MySQL cloud feature to speed up your queries If you have (too) long running select queries it is probably because of lack of relevant indexes, problematic schema tha... dasini.net ⏰ 5 mins
13th Apr 2021 List SQL Server Login and User Permissions with fn_my_permissions As a SQL Server DBA, we often get requests to check permissions on databases or database objects. Sometimes we need to c... mssqltips.com ⏰ 10 mins
13th Apr 2021 Designing Recommender Systems in Azure Machine Learning In this article, we will be discussing how to design a Recommender System in Azure Machine learning which is the next ar... sqlshack.com ⏰ 6 mins
13th Apr 2021 Detecting the "Next" SolarWinds-Style Cyber Attack The SolarWinds attack, which succeeded by utilizing the sunburst malware, shocked the cyber-security industry. This atta... thehackernews.com ⏰ 10 mins
13th Apr 2021 10 Best Free Productivity Tools Front-end Developers need in 2021 It's a new year and that means a new set of tools to boost the developer's productivity. And those which don't cost a pe... dev.to ⏰ 5 mins
13th Apr 2021 Cleaning up a large number of BLOBs in PostgreSQL PostgreSQL allows end users to store BLOBs (binary large objects) in the database. Many people use these functions to ha... cybertec-postgresql.com ⏰ 5 mins
13th Apr 2021 Setup DR for your MySQL InnoDB Cluster MySQL InnoDB Cluster is the High Availability solution for MySQL. It delivers automatic fail-over in case of issue and g... lefred.be ⏰ 4 mins
13th Apr 2021 Amazon Aurora PostgreSQL parameters, Part 4: ANSI compatibility options Organizations today have a strategy to migrate from traditional databases and as they plan their migration, they don’t w... aws.amazon.com ⏰ 18 mins
12th Apr 2021 SQL Daily Monitoring – SQL Server Versions Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor.... stevestedman.com
12th Apr 2021 Quick Scan Report – Logs Flooded with Backup Messages As a DBA you regularly schedule backups you might have regular full backups, incremental backups and hopefully regular b... stevestedman.com ⏰ 4 mins
12th Apr 2021 ORA-04031: Unable to Allocate nn Bytes of Shared Memory The Oracle error ORA-04031: unable to allocate nn bytes of shared memory is telling us that Oracle tried to allocate a s... virtual-dba.com
12th Apr 2021 Replay the Execution of MySQL With RR (Record and Replay) Chasing bugs can be a tedious task, and multi-threaded software doesn’t make it any easier.... percona.com ⏰ 5 mins
12th Apr 2021 Automating a RHEL 8 Installation Using the VMware REST Ansible Collection Managing virtual machines in an IT infrastructure is often a common task, specifically VMware virtualization technology ... ansible.com ⏰ 4 mins
12th Apr 2021 How to troubleshoot remote write issues in Prometheus Note: All links in this document point to code from Prometheus v2.26.0. The exact location or names of things may have c... grafana.com ⏰ 7 mins
12th Apr 2021 Monitoring vs. Observability A discussion modern monitoring and observability practices and how they help development teams better understand the bug... dzone.com ⏰ 5 mins
12th Apr 2021 How I migrated my development environment to a Raspberry Pi In my spare time I develop an open source strategy game called Solaris, check it out.... dev.to ⏰ 3 mins
12th Apr 2021 Export compressed data from Azure SQL Database This article will walk you through the way to export data out of Azure SQL Databases in a compressed format using Azure ... sqlshack.com ⏰ 5 mins
12th Apr 2021 “Kyndryl” is the Name of New Managed Infrastructure Services Business Spun Off from IBM Kyndryl will be the name of the new, independent company that will be created following the separation of IBM’s Managed ... dbta.com
12th Apr 2021 K8s on Windows/VirtualBox . This is a little demo, easy to copy-paste, if you want to play with Kubernetes on your laptop. And, not a simple “Hell... blog.dbi-services.com ⏰ 9 mins
12th Apr 2021 HAProxy Basic Login Authentication Generate haproxy encrypted password printf "thepassword" | mkpasswd --stdin --method=sha-256 Modify haproxy.cfg which al... dev.to
12th Apr 2021 Getting started with serverless for developers: Part 1 Developers around the world are already running serverless applications in production without worrying about servers. Th... aws.amazon.com ⏰ 7 mins
12th Apr 2021 Operating Lambda: Isolating and resolving issues In the Operating Lambda series, I cover important topics for developers, architects, and systems administrators who are ... aws.amazon.com ⏰ 9 mins
12th Apr 2021 Azure SQL digital event: Innovate today with Azure SQL In today’s data-driven world, companies are increasingly looking to the cloud to reduce their infrastructure and adminis... cloudblogs.microsoft.com
12th Apr 2021 Database (Schema) migration to Kubernetes - initContainers vs k8s jobs - We in trackxy were migrating from microservices managed each by its own team to our Kubernetes cluster, where we have ou... dev.to ⏰ 3 mins
12th Apr 2021 Latest Version of pg_stat_monitor in Percona Distribution for PostgreSQL, Bug Fix in Percona Server for MongoDB: Release Roundup April 12, 2021 It’s release roundup time again here at Percona! Our Release Roundups highlights and critical information, as well as li... percona.com
12th Apr 2021 Introduction to Apache Spark In this article, I am going to discuss Apache Spark and how to create robust ETL pipelines for transforming big data. I ... sqlshack.com ⏰ 6 mins
12th Apr 2021 Announcing ClusterControl 1.8.2: Enhanced Security, Resource Utilization and Administration ClusterControl version 1.8.2 features new user and LDAP management capabilities for greater security, a new patch manage... severalnines.com
12th Apr 2021 SQL Server: Audit changes on Instance Configuration, Linked Servers and Agent Jobs Very often with our customers, there is only one person with the DBA role. The configuration of the instances is then un... blog.dbi-services.com ⏰ 6 mins
12th Apr 2021 Managing Transaction ID Exhaustion (Wraparound) in PostgreSQL at Keith's Ramblings… One of the most critical topics to understand when administering a PostgresSQL database is the concept of transaction ID... keithf4.com ⏰ 9 mins
12th Apr 2021 Video : DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP in Oracle Database 18c In today’s video we discuss a simple, but significant change introduced in Oracle database 18c. The video is based on th... oracle-base.com
12th Apr 2021 Setting up Transparent Data Encryption (TDE) Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In my prevous post we look... matthewmcgiffen.com ⏰ 7 mins
12th Apr 2021 MySQL NDB Cluster at a Glance 62 total views, 62 views today... mysqlhighavailability.com
11th Apr 2021 Port Forwarding Using SSH Config File From a secured server, I am able to connect to 2 different environments which seems counter intuitive but I digress. Sin... mdinh.wordpress.com
11th Apr 2021 MySQL Script Test There are many ways to test and edit files. A lot of developers only use their favorite Integrated Developer Environment... blog.mclaughlinsoftware.com
11th Apr 2021 Introduction to SQL Injection SQL injection is often referenced as the most common type of attack on websites. It is being used extensively by hackers... patchthenet.com ⏰ 5 mins
10th Apr 2021 Update blog to ghost version 4 running in Kubernetes My personal blog site is running on the ghost blogging platform at the time of this writing. Its current running version... dev.to
10th Apr 2021 Triggering Jenkins Build Remotely Using API Any Jenkins Job can be triggered remotely through an API call. This article outlines how to do exactly that in just four... dzone.com
10th Apr 2021 Citus Talk at CMU: Distributed PostgreSQL as an Extension Last month we released Citus 10 and we’ve received an overwhelming amount of positive feedback on the new columnar compr... citusdata.com ⏰ 3 mins
10th Apr 2021 The DB2Night Show #234: Db2 Query Optimization 101 100% of our studio audience learned something!John presented how Db2 query optimization works current to the latest rele... dbisoftware.com
10th Apr 2021 GCP Cost Management Best Practices Because Google makes enough money already. One of the advantages of building your infrastructure through cloud providers... dzone.com ⏰ 6 mins
10th Apr 2021 How to Get Started With Azure Devops | beginner's guide A typical software development team is comprising of software developers, testers, DevOps engineers, architects, and pro... dev.to ⏰ 5 mins
10th Apr 2021 Introduction to Database Transaction Database transaction is a collection of multiple database operations (ex: SELECT, UPDATE, DELETE, or INSERT) as a single... dev.to
10th Apr 2021 Deploy and Manage PostgreSQL on Kubernetes PostgreSQL database is an enterprise-grade, open-source object-relational database system focused on providing a highly ... arctype.com ⏰ 6 mins
10th Apr 2021 pgBackRest – The Best Postgres Backup Tool with a very active community A reliable backup tool with an ability to perform a point in time recovery (PITR) is a usual enterprise need. Postgres i... migops.com ⏰ 11 mins
10th Apr 2021 Understanding AWS Costs In this article, I'll provide a comprehensive guide on how to understand your AWS costs and needs. A successful approach... dzone.com ⏰ 6 mins
9th Apr 2021 Empowering the Next Generation of DBAs with Modern Backup and Recovery In an era of rapid digital transformation, companies that fail to effectively manage and leverage their data assets will... dbta.com
9th Apr 2021 Introducing pgBackRest Multiple Repository Support The pgBackRest team is pleased to announce the introduction of multiple repository support in v2.33. Backups already pro... blog.crunchydata.com ⏰ 4 mins