Collecting Metrics from Windows Kubernetes Nodes in AKS

datatechnologytoday.wordpress.com

The Never-Ending To-Do List of the DBA

If you are currently a DBA, I bet you can relate to the title of this article.

https://cloudsecurityalliance.org/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBZzRkIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c749e389a877721876f8e5ee27f13aad573e4360/Microservices-Best-Practices.jpg

cloudsecurityalliance.org

Container Security Best Practices in Microservices

The best practices in this blog assume that you have selected a microservices deployment model that leverages containers. For microservices and security to co-exist, a framework and plan for development, governance, and management of microservices must be developed.

https://dev.to/social_previews/article/956001.png

Using BoltDB as internal database 💾

If you are looking for a small database for your fun project, I have something you might like. It is small, works as a key-value store and it's pure go. Bolt is a pure Go key/value store inspired by Howard Chu's LMDB project.

dev.to

https://devinterrupted.com/wp-content/uploads/Group-1791.png

Chaos Engineering - The Practice Behind Controlling Chaos

During my career I dealt with my fair share of outages, including one that caught me mid-song during a bout of karaoke and far too many that woke me up at 02:00.

devinterrupted.com

Deep SQL Query Optimization with SQL Grease

Our applications are experiencing numerous SQL Server performance bottlenecks, but we are unable to pinpoint the issues. Our DBAs need deep insight into the application performance because we believe there are specific SQL Server queries that are causing the issues.

mssqltips.com

https://blog.dbi-services.com/wp-insides/uploads/sites/2/2022/01/db2_1.png

Setting up IBM Db2 on Linux

My last contact with IBM Db2 was more than 10 years ago, and that only on the SQL/application level. I’ve never done an installation of Db2 as most of our customers either don’t use it, or we don’t know about it, or these databases are managed by other teams than those we work with.

https://www.brentozar.com/wp-content/uploads/2022/01/error_handling_tsql.png

Error Handling Quiz Week: Where Are You Handling Errors?

This week’s series on error handling has been an eye opener for many of us. We’ve laughed. We’ve cried. We’ve screamed in horror. We’ve read the documentation. I don’t blame you.

brentozar.com

https://www.percona.com/blog/wp-content/uploads/2022/01/Percona-Make-Better-Databases.png

Help Percona Make Better Databases

Hello everyone! The new year is upon us and we are looking at planning some awesome new features, enhancements, and ideas in 2022. One of the things we could really use your help on, however, is providing us with feedback on how we are doing and what we can do to improve our database products.

percona.com

https://i0.wp.com/lefred.be/wp-content/uploads/2022/01/mysql_component7.png?fit=1024%2C572&ssl=1

Extending MySQL using the Component Infrastructure – part 7: messages to users

This post is the seventh post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: In the previous post, we coded the check for the right privilege to be able to run our function.

Automating Linux patching with Ansible – How to keep all your environments consistent ?

Your may want to patch your Linux servers on a regular basis (e.g using “yum/dnf update”). As always, it’s obviously recommended to : The problem here is that between step 1 and 4 above, a new version of the packages can be available on the public repository you use.

https://s33046.pcdn.co/wp-content/uploads/2022/01/lines-of-latitude-and-longitude-across-the-surface.png

Getting started with Spatial Data in PostgreSQL

In this article, we are going to discuss in detail what a spatial database is and the data type, POINT that is supported by PostgreSQL to perform geographic data analysis.

sqlshack.com

Installing the ODBC drivers for MongoDB

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed.

Time to check Galera Cluster security?

There are plenty of articles on the Internet that tell you to setup a Galera Cluster by disabling an OS based firewall and also disabling SELinux.

galeracluster.com

Performance Tuning Using Free Tools, Part 2 – SQLServerCentral

Does the cost of running SQL Server often surprise you? The cost may come from buying on-premises hardware or paying Azure SQL bills. You can keep the cost under control by improving the efficiency of your databases.

sqlservercentral.com

https://www.red-gate.com/wp-content/uploads/2021/12/diagram-description-automatically-generated.png

A Database DevOps Workflow Using Redgate Deploy

Tony Davis describes a typical database development cycle and deployment pipeline supported by Redgate Deploy.

red-gate.com

Network interface routing priority on a Raspberry Pi

As I start using Raspberry Pis for more and more network routing activities—especially as the Compute Module 4 routers based on Debian, OpenWRT, and VyOS have started appearing—I've been struggling with one particular problem: how can I set routing priorities for network interfaces?

jeffgeerling.com

https://dz2cdn1.dzone.com/storage/article-thumb/15541948-thumb.jpg

JDBC Tutorial Part 3: Using Database Connection Pools

In Part 3 of this tutorial series covering the basics of JDBC, learn what a database connection pool is and how to use it. In part 3 of this tutorial series, you’ll learn what a database connection pool is and how to use it.

dzone.com

https://www.percona.com/blog/wp-content/uploads/2022/01/PostgreSQL-Patroni-Logical-Replication-Slot-Failover.png

How Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster

Failover of the logical replication slot has always been the pain point while using the logical replication in PostgreSQL. This lack of feature undermined the use of logical replication and acted as one of the biggest deterrents.

percona.com

https://sqlplayer.net/wp-content/uploads/2022/01/Essential_SSDT_EN-blue.png

Database projects with SQL Server Data Tools (SSDT)

Last Year (2021) I released a full and comprehensive course about SSDT: developing and maintenance SQL Server database within SQL Server Data Tools in Visual Studio. Thank you to all those who decided to buy the course and congratulations to those who completed it.

sqlplayer.net

https://i0.wp.com/lefred.be/wp-content/uploads/2022/01/mysql_component6.png?fit=1024%2C572&ssl=1

Extending MySQL using the Component Infrastructure – part 6: functions

This post is the sixth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: Our component is nicely evolving. In this article we will start the creation of our first function.

Oracle 21C Security : diagnostics_control and enable diagnostics

Some debug-events and debug-actions are not safe and should be exposed to users with caution. In previous releases, privilege control for the usage of these diagnostics was not sufficient.

Best Practices for MongoDB Security

When it comes to managing database systems, one crucial aspect is database security. The failure to lay a good foundation for security for any database system may result in a data breach whereby a third-party intruder will have unauthorized access to it.

severalnines.com

All you want to know on SAP HANA Cloud

The purpose of this blog is a one stop shop list to all the important information resources of SAP HANA Cloud. It is to help the development and data management practitioners to quickly get up to speed on what it is, what’s the latest, and share best practices from other practitioners.

blogs.sap.com

The Curious Case of… tracking page compression success rates

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more Explore Crazy, crazy end-of-year sale! Update: We extended the sale through Christmas Day at midnight UTC! Our end-of-year sale is here and the

sqlskills.com

https://s33046.pcdn.co/wp-content/uploads/2022/01/working-with-jit-compiler.png

Getting started with SQL Server CLR functions

This article will explain how to create a SQL Server CLR function stored in a C# class library without creating a SQL Server database project. We will first briefly explain the concept of .NET common language runtime (CLR) and then build a C# class library using the .NET framework.

sqlshack.com

https://i0.wp.com/joeydantoni.com/wp-content/uploads/2022/01/pexels-photo-5909801.jpeg?fit=960%2C1200&ssl=1

Fixing SQL Server Database Corruption (when you get lucky)

First things first–if you are reading this, and not regularly running consistency checks on your SQL Server databases, you should drop everything you are doing and go do that.

joeydantoni.com

How to Use SingleStore as a Key-Value Store

Key-value stores are perhaps one of the most popular databases on the market today — and with good reason! They are fast, scalable and super easy to use.

singlestore.com

https://s33046.pcdn.co/wp-content/uploads/2022/01/azure-sql-database-created.png

Azure SQL – a FAQ article

In this article, we will talk about Azure SQL. The article will compile the FAQ about this topic. The article will cover FAQ related to concepts for newbies, prices, some common features, migration and several links for references to get higher details on specific topics.

sqlshack.com

https://www.brentozar.com/wp-content/uploads/2021/12/uncommitted_transaction.png

Error Handling Quiz Week: Combining Transactions And TRY/CATCH

In yesterday’s epic cliffhanger, you might have been shocked to discover that a plain ol’ transaction does not solve our problem – and in fact, it makes things worse.

brentozar.com

https://i0.wp.com/lefred.be/wp-content/uploads/2022/01/mysql_component5-1.png?fit=1024%2C572&ssl=1

Extending MySQL using the Component Infrastructure – part 5: privileges

This post is the fifth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: We are back to our component and we will see how we can use the dynamic privilege component service to add a new privilege when we i

https://blog.griddynamics.com/content/images/2022/01/Frame-7.png

How to build visual traffic analytics with open source: car tracking and license plates recognition

In today’s data-driven digital economy, businesses collect an abundance of data to inform and optimize their processes and strategies.

blog.griddynamics.com

HOW TO LOAD BALANCE RMAN RAC DATABASE BACKUP

First, I will share the incorrect method since it is hard coded. The goal is to configure RMAN backup with parallel 4 and load balance.

mdinh.wordpress.com

https://i1.wp.com/lefred.be/wp-content/uploads/2022/01/mysql_component4.png?fit=1024%2C572&ssl=1

Extending MySQL using the Component Infrastructure – part 4: error logging

This post is the fourth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: In this article we will add to our component the capability to add messages in error log (and performance_schema.

https://d2908q01vomqb2.cloudfront.net/887309d048beef83ad3eabf2a79a64a389ab1c9f/2021/12/20/DBBLOG-1915-image001.jpg

Get started with Babelfish for Aurora PostgreSQL

Enterprises that want to migrate from a SQL Server database engine to Amazon Aurora PostgreSQL-Compatible Edition typically convert the database schema from one database to another, then take data from the first database and load it into the target database.

aws.amazon.com

https://imgix.datadoghq.com/img/blog/key-metrics-for-monitoring-azure-sql-database/azure-sql-database-hero-p1.png?fit=crop&w=1200&h=630

Key metrics for monitoring Azure SQL databases

Microsoft Azure SQL Database is a platform-as-a-service (PaaS) database offering for modern cloud applications.

datadoghq.com

Understanding VMWare Components

Recently I was looking to install VMWare components in my local network of things so that I could gain additional knowledge of how VMWare works. I have a local Synology DS920+ which can run virtual machines and I have about 18TB of space to play with so I thought this would be a good experiment.

sqlrus.com

https://www.red-gate.com/simple-talk/wp-content/uploads/2022/01/graphical-user-interface-text-application-chat.png

Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant

The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows how to create databases and tables. You have an instance of PostgreSQL running locally (or you’re connected to the cloud).

red-gate.com

https://stevestedman.com/wp-content/uploads/2022/01/backupretentionpart1.png

Backup Retention – Part 1 of 3

I’m often asked about backup retention times, and there is always a balance between keeping enough backups and purging those backups quickly to free up space. Some clients I have worked with only keep 2 to 3 days of backups, and others keep multiple years of backups.

stevestedman.com

https://mydbops.files.wordpress.com/2021/12/tokudb.jpg?w=1200

MySQL “No space left on device from storage engine”

We have planned for archiving the data to improve the DB performance and to reclaim the space. We were evaluating Compression in InnoDB and TokuDB. To find out the best compression method. We started benchmarking the compression ratio between InnoDB and TokuDB.

mydbops.wordpress.com

https://i0.wp.com/lefred.be/wp-content/uploads/2022/01/mysql_component3.png?fit=1024%2C572&ssl=1

Extending MySQL using the Component Infrastructure – part 3: component services

This post is the second post of a series of articles on extending MySQL with the Component Infrastructure: It’s time to start coding our new component \o/ In the MySQL Server’s source directory (see part 2), we will create a new directory for our component: [[email protected] ~workspace/mysql-server/BIN

https://garrybargsley.com/wp-content/uploads/2022/01/SSMS_Connect.png

9th Jan 2022

Connecting to an Azure SQL Database4 min read

Are you starting to experiment with Azure SQL Databases? Is your company interested in moving to the Cloud and asking you to investigate different options? This blog will show you three options to connect to an Azure SQL Database using the same tooling you would use for on-premises SQL Databases.

garrybargsley.com

Fixing a PostgreSQL cluster that has no superuser

Normally in a newly-created PostgreSQL database cluster there is a single all-powerful administrative role (user) with “superuser” privileges, conventionally named postgres, though it can have any name. After the initial cluster setup you can create other roles as needed.

endpointdev.com

https://blog.yugabyte.com/wp-content/uploads/2022/01/0106-YBDocker-Social.png

Tutorial: Getting Started with YugabyteDB and Docker

When developing modern applications, it is important to maintain dev/prod parity (that is, keep development, staging, and production as similar as possible). This should also extend to the local development environment.

blog.yugabyte.com

Encrypted Replication for MySQL

Encrypted connections for MySQL replication are the default as of 8.0. The following simple example shows a basic setup for encrypted replication using Ubuntu 20.04 and MySQL Community 8.0.27. The steps may be similar for other Linux distributions.

virtual-dba.com

CIS Benchmarks January 2022 Update

The following CIS Benchmarks have been updated or released. We've highlighted the major updates below. Each Benchmark includes a full changelog that can be referenced to see all changes made. Thanks to the entire CIS macOS Benchmark Community for their support on this effort.

cisecurity.org

https://www.enterprisedb.com/sites/default/files/edb-og-default-image.jpg

PG Phriday: Defining High Availability in a Postgres World

What does High Availability actually mean when we’re discussing Postgres clusters? Sure, we can set an RPO, RTO, SLA, and other 3-letter acronyms regarding expectations and deliverables, but what are we trying to achieve? Fast failover? No lost transactions? Both? What about time necessary to rebu

enterprisedb.com

https://dbafromthecold.files.wordpress.com/2022/01/runpowershellinvim_2.gif