Getting Started With Longhorn Distributed Block Storage and Cloud Native Distributed SQL

Delivering expert support in resolving database conversion errors

One of the major United States universities has been migrating their complex data managing system from Sybase to SQL Server. They used SQL Server Migration Assistant for Sybase to automate the migration process.

dbbest.com

Scaling Out the Moodle Database

Moodle is a very popular platform to run online courses. With the situation we see in 2020, Moodle, along with communicators like Zoom forms the backbone of the services that allow online learning and stay-at-home education.

Author on Oracle MySQL Blog

You may have noticed, I started to blog also on the official Oracle MySQL Blog. When I will do so, I will also publish my articles on lefred.be after a short delay.

lefred.be

Webinar: Nailing ELK at Scale – A Real World Success Story from Holler

Ever use stickers or GIFs to make your texts, messages, or DMs more interesting? If yes, you’ve probably used Holler - a messaging tool that makes digital conversations come to life. The engineers at Holler have the daunting task of monitoring the performance and reliability of a service used by millions of people around the globe on a daily basis.

logz.io

Video : Simple Oracle Document Access (SODA) for SQLcl

In today’s video we give a demonstration of Simple Oracle Document Access (SODA) for SQLcl. SODA is a feature of Oracle REST Data Services (ORDS), but this allows to access the document store directly from SQLcl. This video is based on the following article.

What’s new in the Citus 9.4 extension to Postgres

Our latest release to the Citus extension to Postgres is Citus 9.4. If you’re not yet familiar, Citus transforms Postgres into a distributed database, distributing your data and your SQL queries across multiple nodes. This post is basically the Citus 9.4 release notes.

citusdata.com

5th Sep 2020

What’s New in MongoDB 4.4

MongoDB 4.4 (currently in beta) is being rolled out with the main agenda of addressing developer suggestions from the MongoDB community .

mahmoudhatem.wordpress.com

5th Sep 2020

ORACLE database on AWS : Licensing and Support

Recently (Few months ago) , i started exploring the AWS cloud services and i can say that it’s pretty interesting ! During my learning journey, i discovered a lot of new and interesting things and also got few certifications 🙂 I decided to start this blog series to share things that may be usef

Searching and finding a string value in all columns in a SQL Server table

UPDATE: I was able to get multiple table included using a variable as a table alias, but its dog slow. Probably the best solution is to avoid using cursors all together. Any suggestions? PREVIOUS: Is it possible to have multiple tables included? Not all tables, just the ones I specify.

Resolving SQL0930N Memory Errors after an RHEL 7.8 Upgrade

A colleague and I were recently working on a Db2 server with a large amount of memory (512 Gb) and were supporting the system administrators in applying operating system maintenance to bring the system from RedHat Enterprise Linux (RHEL) 7.6 to RHEL 7.8.

virtual-dba.com

Database Consistency Models and Isolation Levels

The other week, we devoted an episode of The Cockroach Hour to talk about the dirty secret of isolation levels. When host Jim Walker was titling the webinar, I’m pretty sure he had one particular “secret” in mind: dirty reads.

cockroachlabs.com

Building a Highly Available Database for Moodle Using PostgreSQL

Impacted by the COVID-19 pandemic, a lot of SMBs/SMEs are transitioning to online platforms.

How to enable slow query log on Google Cloud SQL for MySQL [2020]

In this post, we will quickly demonstrate how to enable Slow Query Log on Google Cloud SQL for MySQL. The next and final step will be to install EverSQL's Chrome extension - no configuration needed.

eversql.com

PostgreSQL Backups

In a database production environment, a backup plays quite an essential role. The database server can fail for a number of reasons. It can happen because of hardware failure, software malfunction or just because of user error.

postgr.es

DB Best released a new 1.4 version of Migration Platform

DB Best introduced a new version of its Migration Platform — an all-around program that enables all types of automated database migration. In this version, we presented several improvements for the key platform modes: Development and Migration projects.

Webinar September 17: PostgreSQL High-Performance Tuning and Optimization

Please watch Percona’s Senior Software Engineer Ibrar Ahmed as he presents the “” webinar. PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it.

percona.com

Understanding Data Lineage in ETL

In this article, I am going to explain what Data Lineage in ETL is and how to implement the same. In this modern world, where companies are dealing with a humongous amount of data every day, there also lies a challenge to efficiently manage and monitor this data.

sqlshack.com

Three Ways to Overcome Cloud DevSecOps Bottlenecks

Bridgecrew sponsored this post. This post is the second of two parts on why DevSecOps can end up backfiring within cloud native organizations and what you can do about it.

thenewstack.io

How to Get the Best Out of PostgreSQL Logs

As a modern RDBMS, PostgreSQL comes with many parameters for fine-tuning. One of the areas to consider is how PostgreSQL should log its activities. Logging is often overlooked in Postgres database management, and if not ignored, usually wrongly set.

2ndquadrant.com

Implementing SQL Server Security with Stored Procedures and Views

I understand that, through the use of SQL Server ownership chaining, I can restrict access to the underlying tables with data while still allowing applications to query and modify data. How does this work? Are there any examples which I might be able to use in my own code?

(Live) Webinar – XDR and Beyond with Autonomous Breach Protection

Anyone paying attention to the cybersecurity technology market has heard the term XDR - Extended Detection and Response. XDR is a new technology approach that combines multiple protection technologies into a single platform.

Business Intelligence with Window Functions in PostgreSQL [Webinar]

Window functions in PostgreSQL are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is just not flexible enough — case in point, incremental totals and moving averages.

postgr.es

No Tresspassing: Introduction to GraphQL Authorization

Authentication and authorization are very complex topics for any public-facing application. Unless you want to make every piece of data and every possible action public (does something like this even exist?!), you're forced to implement both processes mentioned earlier into your software.

dgraph.io

Migrate from on premise MySQL to MySQL Database Service

If you are running MySQL on premise, it's maybe the right time to think about migrating your lovely MySQL database somewhere where the MySQL Team prepared a comfortable place for it to stay running and safe. This awesome place is MySQL Database Service in OCI.

blogs.oracle.com

2nd Sep 2020

Building a Highly Available Database for Moodle Using MySQL Replication

Moodle is an open source learning management system, widely used by schools and universities around the world. The project started in 2002 by Martin Dougiamas, with the aim to provide learners, teachers, educators a secure, robust, open and free platform for learning environments.