MariaDB Names Mark Our Continued Differentiation

With the release of MariaDB Community Server 10.5, we continue what we started with our first divergence from MySQL, adding important features while maintaining key points of compatibility. To reflect our differentiation from MySQL, MariaDB Community Server 10.

mariadb.com

2nd Jul 2020

POUG 2020 Workshop Day 1

I had the opportunity to participate to POUG day 1 and wanted through this blog to share some of my feedback on the interesting sessions I could follow. First of all, I would like to mention the great introduction done by the staff team and the great organization.

blog.dbi-services.com

2nd Jul 2020

Latest Builds of SQL Server 2017

SQL Server 2017 was made generally available on Windows, Linux, and Docker on . Download the free Express / Eval / Developer editions. For Windows, the latest CU is always available here. If you're running on Linux, you can navigate through the 1991-esque packages.microsoft.

sqlblog.org

2nd Jul 2020

How to Deploy a MariaDB Cluster for High Availability

Galera is based on synchronous (or ‘virtually synchronous’) replication method, which ensures the data applied to other nodes before it is committed. Having the same data on all nodes means that node failures can be easily tolerated, and no data is lost.

severalnines.com

2nd Jul 2020

A Review of Graph Databases

There are many ideas and considerations behind graph databases. This includes their use cases, advantages, and the trends behind this database model. There are many ideas and considerations behind graph databases. This includes their use cases, advantages, and the trends behind this database model.

dzone.com

2nd Jul 2020

Oracle to PostgreSQL – Binary Objects

Binary Large OBject storage (BLOB) is a topic that comes up in almost every conversation about Oracle to PostgreSQL migration. I will discuss it here with enough detail to make architectural choices coming from the Oracle perspective. Ready? Ok, let’s continue.

2ndquadrant.com

2nd Jul 2020

Getting started with the Grafana Cloud Agent, a remote_write-focused Prometheus agent

Greetings! This is Eldin reporting from the Solutions Engineering team at Grafana Labs. In previous posts, you might have read about Grafana’s New 7 release or our introduction to Loki. In this week’s post, I am introducing Éamon, who will be covering our Grafana Cloud Agent. – Eldin

grafana.com

2nd Jul 2020

Afternoon Cyber Tea: Cybersecurity & IoT: New risks and how to minimize them

Recently, Microsoft announced our acquisition of CyberX, a comprehensive network-based security platform with continuous threat monitoring and analytics.

microsoft.com

2nd Jul 2020

Refresh a SQL Database using the maintenance plan

In this article, I am going to explain how we can refresh a SQL Database using the Maintenance plan. To demonstrate the process, I have configured two virtual machines. I have installed SQL Server 2016 on both.

sqlshack.com

2nd Jul 2020

Explore SQL queries Hint OPTION (FAST N)

In this article, we will introduce SQL queries hint and will analyze the OPTION(Fast ‘N’) hint in detail. Once the user submits any query to SQL Server, it creates an optimized and cost-effective execution plan depending upon the statistics, indexes, and data distribution.

sqlshack.com

2nd Jul 2020

MongoDB ransom threats step up from blackmail to full-on wiping

Have you left a cloud database exposed online?

nakedsecurity.sophos.com

2nd Jul 2020

Disappearing Data in PostgreSQL

I recently discovered an interesting (and frustrating) issue while running PostgreSQL in Kubernetes.

datageek.blog

2nd Jul 2020

Introducing Infrastructure Monitoring

A brief overview of Logz.io Infrastructure Monitoring - a Grafana-based monitoring solution that correlates between logs and metrics for easier investigative workflows.

logz.io

2nd Jul 2020

How to Control Logging Costs with Logz.io

You don’t have to choose between cost management and full observability. With Logz.io features Log Patterns, Drop Filters, and Archive & Restore add to cost efficiency. These features are designed to easily identify and filter out that data before indexing it, and then reingest that data if necessary later.

logz.io

2nd Jul 2020

Getting Started with Neo4j Fabric

Fabric is a new feature introduced in Neo4j 4.0 and is a way to store and retrieve data in multiple databases. This feature makes it easy to query the data in the same DBMS or multiple DBMS using a single Cypher query. If you haven’t already, please download Neo4j Desktop.

neo4j.com

2nd Jul 2020

Running MySQL on selected NUMA Node(s)

“Running MySQL on selected NUMA node(s)” looks pretty straightforward but unfortunately it isn’t. Recently, I was faced with a situation that demanded running MySQL on 2 (out of 4) NUMA nodes.

mysqlonarm.github.io

2nd Jul 2020

How to Add SQL Server Integration Services Projects to Azure Devops for Version Control

We are working on an Integration Services project with multiple developers. Some team members work remotely, so it's not always easy to see which package someone is working on. We'd like to use a git repository as a source control repository. This way we can also manage the code using branches.

mssqltips.com

2nd Jul 2020

MySQL Terminology Updates

It’s been 20 years since MySQL Replication was introduced in MySQL 3.23.15 (Released in May 2000). Since then, virtually every MySQL Database deployment in production has been using Replication in order to achieve high availability, disaster recovery, read scale out and various other purposes.

mysqlhighavailability.com

1st Jul 2020

An Overview of the New DBaaS from MariaDB - SkySQL

MariaDB has recently launched its new DBaaS offering, SkySQL.

severalnines.com

1st Jul 2020

Why Performance Matters in Time-Series Data

Nicolas Hourcard Nicolas is a lifelong technology enthusiast and co-founder of QuestDB. He previously leveraged time-series data for companies like Rothschild and Nasdaq. He splits his time between London and San Francisco and enjoys tennis, skiing and climbing new mountain peaks each year.

thenewstack.io

1st Jul 2020

Preventing MySQL Error 1040: Too Many Connections

What this means in practical terms is that a MySQL instance has reached its maximum allowable limit for client connections. Until connections are closed, no new connection will be accepted by the server.

percona.com

1st Jul 2020

We Put a SQL Database on the Internet

What happens when you put a SQL database on the internet? It's probably not what you'd expect. And then we posted it to Hacker News.

dzone.com

1st Jul 2020

GraphQL: Using Postman with Examples

Postman is one of the most popular REST API clients. Since v7.2, it also supports GraphQL APIs. In this blog post, we will look at how you can use Postman to make GraphQL requests. We will also look at some of the advantages of doing so.

dgraph.io

1st Jul 2020

Database Architectures & Use Cases - Explained

With over 300 databases on the market, how do you determine which is right for your specific use case or skill set? We continue to see the common debate of SQL vs. NoSQL and other database comparisons all over social media and platforms like dev.to.

dev.to

1st Jul 2020

Release Announcement: Telegraf 1.14.5

Skip to content Release Announcement: Telegraf 1.14.5 By / June 30, 2020 June 30, 2020 / Release Notes, Telegraf / 1 minute A new maintenance release for Telegraf is available now. Telegraf 1.14.

influxdata.com

1st Jul 2020

How to Ace an Azure Data Engineer Interview

Navigating the turbulent waters of the Azure Data Lake and many of the other offerings within the Azure Data ecosystem can be a challenge for aspiring Azure Data Engineers.

mssqltips.com

1st Jul 2020

Analyzing Your Code Dependencies for Vulnerabilities with Visual Builder Studio

Most of the projects developed today rely on open source libraries - it is likely that your project does too. While using these libraries accelerates development by relying on proven solution for common needs, it also introduces a potential risk factor.

blogs.oracle.com

1st Jul 2020

MySQL Performance : TPCC "Mystery" [SOLVED]

The TPCC workload "mystery" exposed in the following post was already clarified the last year, and I've presented explanations about the observed problem during PerconaLIVE-2019.

dimitrik.free.fr