Webinar: Highway to Zero Downtime PostgreSQL Upgrades [Follow Up]

In the past, major upgrades of terabyte size PostgreSQL databases required extended downtime or great amounts of work. With logical decoding, a whole new world of opportunities appeared for upgrades that require a very small amount of downtime.

Video : Multitenant : Disk I/O (IOPS, MBPS) Resource Management for Pluggable Databases (PDBs)

In today’s video we’ll discuss how Resource Manager allows us to manage the disk I/O (IOPS, MBPS) usage in PDBs. This can be useful to stop a small number of PDBs using all disk IOPS and/or bandwidth on the server. The video is based on the following article.

How to get the most out of a virtual conference like ElasticON Global

ElasticON Global, our biggest user conference ever, is coming soon on October 13-15. For the first time ever, this three-day user conference is completely free — and completely virtual.

Application down after SQL Service logon account change – SQLServerCentral

I was working on one of my clients server recently. This was during a normal maintenance monthly activity to reboot the database server every first weekend. I rebooted the machine, and as per the defined steps, I checked the SQL services after the reboot to ensure they were up.

How to participate in the Hacktoberfest as a Code Newbie 💻

This is my first Hacktoberfest event to participate in as a code newbie. To be honest at first, when I had the about the event, I thought it was a month where hackers come together and hack their way into any server. In the end, those that hack into the most 'secure' servers win.

What exactly does Indexing in a Database do?

Hey there! While working with the database, I came to know how important it is to use index on a table which holds a large number of records. In this article, I will be explaining what difference does it make to add an index to a table.

Is there a pattern to our problems? One site reliability engineer compiled a list of “What Breaks Our Systems: A Taxonomy of Black Swans.”

Scalefield - Rethinking PostgreSQL-as-a-service

CYBERTEC is proud to announce the availability of Scalefield, a modern solution offering PostgreSQL-as-a-service for on-premise deployments and inhouse clouds. Scalefield is the ideal on premise solution for high availability PostgreSQL setups.

Combating SQL Injection

Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common? They are all recent victims of cyber-attacks – several of these are confirmed to involve SQL Injection.

Can Distributed Tracing Replace Logging?

Logging has been around since programming began. We use logs to debug issues and understand how software works at the code level. After logging and debuggers, profilers are a dev’s best friend when writing code and may run in production with limits to reduce overhead.

Learn MongoDB: Getting Started

Currently, I am starting my journey to expand my knowledge in MongoDB, and I have decided to create this series here and share all the knowledge that I get, with the community. Let's Begin...

Open source is changing the world - one pull request at a time.

Hacktoberfest encourages participation in the open source community, which grows bigger every year. Complete the 2020 challenge and earn a limited edition T-shirt. Be the first to know when Hacktoberfest 2020 launches. Hacktoberfest is open to everyone in our global community.

Pluralsight – Storing and Managing Data with Postgres on Heroku

Lots of people liked my earlier blog post Heroku – How to Deploy Postgres Add-Ons? I got quite a few emails and requests where the user wanted to learn Heroku Postgres.

A Development & Operations Checklist for MongoDB

MongoDB operation and development checklists are meant to help database administrators avoid encountering issues in the MongoDB production environment. A Development Checklist should address issues such as... An Operation Checklist, on the other hand, addresses...

Adventures in SQL Server 2019: Microsoft updates the update that broke the update

There was good news for administrators of Microsoft's SQL Server 2019 last night as Cumulative Update 8 emerged, fixing the borkage of its predecessor.

Tutorial: How to Simulate a Multi-Region CockroachDB Cluster on localhost with Docker

Here are the instructions to simulate the deployment of a 9 nodes CockroachDB cluster across 3 regions on localhost using Docker. The instructions assume you are running Linux or macOS, although it should work on Windows using Cygwin, and have Docker installed.

How to Use CHECK Constraint in MySQL 8

Hello everyone, in this little post we will review a new feature in MySQL 8. This is a new feature to specify a condition to check the value before INSERT or UPDATE into a row.

Improving the performance of the Prometheus JMX Exporter

At Yelp, usage of Prometheus, the open-source monitoring system and time series database, is blossoming. Yelp is initially focusing on onboarding infrastructure services to be monitored via Prometheus, one such service being Apache Kafka.

Overview of Azure Data Factory User Interface

In the previous post, we started by creating an Azure Data Factory, then we navigated to it. In this post, we will navigate inside the Azure Data Factory. Let’s look at the Azure Data Factory user interface and the four Azure Data Factory pages.

Implementing FIFO message ordering with Amazon MQ for Apache ActiveMQ

This post is contributed by Ravi Itha, Sr. Big Data Consultant Messaging plays an important role in building distributed enterprise applications. Amazon MQ is a key offering within the AWS messaging services solution stack focused on enabling messaging services for modern application architectures.

PostgresDAC 3.9 meets PostgreSQL 13

New milestone PostgresDAC release is out! Now with PostgreSQL 13 and RAD Studio 10.4.1 support PostgresDAC is a direct access component suite for RAD Studio (Delphi and C++Builder)/FreePascal/Lazarus and PostgreSQL, EnterpriseDB, Amazon RDS, PostgresPro, and Heroku Postgres.

Full-Text Search – 5 Tips To Improve Your Query Performance

Tuning the search query performance is a very important aspect of Full-Text Search as it helps business-critical applications in meeting the SLA requirements of latency and throughput. Without much preamble, let me share a few useful recommendations for troubleshooting your search performance.

Missing SQL Bits

This week is SQL Bits week, which is taking place virtually over in the UK. Things are planned for UK time, and speakers are accommodating them. I had a webinar earlier in the with Grant at 930am my time, 1130 his.  This was after he’d completed a 7.5 hour precon for Bits.

Exciting and New Features in MariaDB 10.5

MariaDB 10.5 was released in June 2020 and it will be supported until June 2025. This is the current stable version and comes with more exciting new features. In this blog, I am going to explain the new and exciting features involved in MariaDB 10.5.  S3 engine is a nice feature in MariaDB 10.5.

Rate Limit (Throttle) for MySQL with ProxySQL

Maybe one of the more “obscure” operations when dealing with replica lag, or, in general, when one needs to control writes to the database, is the Rate limit. It’s also lately one of the most popular conversations around the community.

Run #Python directly in the database

With Python integrated to the database, you can utilize the power of SQL together with one of the most popular programming languages. And you run the program where the data is: Inside the database. Instead of having to bring the data to the program.

Starting SQL: Wrapping It All Up

I started writing this series as a beginner’s guide to some of the oddities in SQL Server, and to address some of the incorrectness in the world when it comes to database practitioner-ing. It was enjoyable to write, but I think two months is probably enough.

Storing, Processing and Visualizing Data with the ogamma Visual Logger for OPC and InfluxDB

This post was written by Ravil Nugmanov, Software Architect at One-Way Automation, a startup located in Edmonton, Canada.