DBplatz

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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
12th Apr 2021

MySQL NDB Cluster at a Glance

62 total views, 62 views today...

mysqlhighavailability.com
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
image
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
    • First
    • 1
    • 2
    • 3
    • 4
    • Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2021 © DBplatz