DBplatz - Database News. Read our handpicked database-related articles. Where all databases are welcome. SQL and NoSQL. Windows, Linux and MacOS. #useThemAll


Dell Technologies sponsored this podcast. In this The New Stack Makers podcast, technology thought leaders from Dell EMC and VMware discuss the dynamics of data protection and other DevOps-related themes for today’s highly complex cloud native environments.

  • thenewstack.io
  • B. Cameron Gain

At CIS, we believe in cultivating a trusted and collaborative environment for information sharing. Through our Community, we develop industry-leading tools and resources to enhance the cyber defense programs of organizations in every industry.

  • cisecurity.org

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. DigitalOcean is quickly building its reputation as the developers cloud by providing an affordable, flexible and easy to use cloud platform for developers to work with.

  • scalegrid.io

Collaboration and communication are critical to the successful implementation of service level objectives. Development and operational teams need to evaluate the impact of their work against established service reliability targets in order to improve their end user experience.

  • datadoghq.com
  • Datadog

In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including the TOP operator, compression, and partitioning.

  • red-gate.com
  • ANTS Performance Profiler

Knowledge graphs are an essential information resource for machine learning in search and inferencing. Learn how to load and process ontologies in RedisGraph as a first step in building knowledge graphs in Redis.

  • redislabs.com
  • Alex Milowski

Throughout this series, I’ve discussed a range of storage-related topics, some of which I mentioned only briefly. One of those is cloud storage, which now plays a vital role in today’s data management strategies.

  • red-gate.com
  • ANTS Performance Profiler

Redgate published a report that many of you helped with by providing information. First, thanks! Your info really helped. Second, do you want to see it? You can. Go here and get a copy.

  • scarydba.com
  • Grant Fritchey

A large majority of computer systems have some state and are likely to depend on a storage system. My knowledge on databases accumulated over time, but along the way our design mistakes caused data loss and outages.

  • medium.com
  • Jaana Dogan

We’re happy to announce that we have open–sourced the Apache Spark Connector for SQL Server and Azure SQL on GitHub.

  • cloudblogs.microsoft.com
  • SQL Server Team

Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting or running a virtual machine. In this article of the series, Carlos Robles demonstrates how to connect to the SQL Server once it’s running.

  • red-gate.com
  • ANTS Performance Profiler

The plan is to set up a replication link from the new cluster running on MySQL 5.7 to the master running on MySQL 5.6 (outside of ClusterControl provision), which uses no GTID. MySQL does not support mixing GTID and non-GTID in one replication chain.

  • severalnines.com
  • Ashraf Sharif

Estimated plans can be a bit confounding, huh? Whether you see one by hitting CTRL+L, looking in the plan cache, or looking in Query Store, the song remains the same.

  • erikdarlingdata.com
  • Erik Darling

How annoying is it when you get a telemarketing call from a random phone number? Even if you block it, it won’t make a difference because the next one will be from a brand new number. Cyber attackers employ the same dirty tricks.

  • elastic.co
  • Camilla Montonen

22nd Jun 2020

Programming language is considered very powerful if it can solve a given set of problems succinctly and efficiently. In this article, let’s see how Python can solve a series of problems concisely using a set How to questions.

  • dev.to
  • dev

There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful information. For example, there is an ISO standard for the abbreviation of state names in the United States.

  • scarydba.com
  • Grant Fritchey

SQL Server cursors are one common topic on the Internet. You’ll find different opinions when to use them and when not to do it. Today, we’ll also talk about them and answer the question when (not) to use them.

  • sqlshack.com
  • Emil Drkusic

Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct links to the software or service itself.

  • percona.com
  • David Quilty

We’ve been receiving requests recently from MySQL users wanting to understand how InnoDB Cluster compares to Tungsten Clustering, our MySQL HA, disaster recovery, and geo-clustering solution. In response we have come up with this comparative outline, looking at some of the key features of each.

  • continuent.com

In this article, we will discuss the Dirty Read concurrency issue and also learn the details of the Read Uncommitted Isolation Level. A transaction is the smallest working unit that performs the CRUD (Create, Read, Update, and Delete) actions in the relational database systems.

  • sqlshack.com
  • Esat Erkec

Database administrators can leverage the scalability, automation, and flexibility of Kubernetes to create a highly available SQL database cluster.

  • sqlshack.com
  • Gilad Maayan

22nd Jun 2020

What happens when your clustered storage fails? A key design principle of Prometheus is reliability. Part of this is that it doesn't have any hard dependencies on clustered systems, such as on Zookeeper, Kafka, or Cassandra that may have issues if there's fun like a network partition.

  • robustperception.io
  • Brian Brazil

Like many, you might think of Redis as only a cache. That point of view is out of date. Essentially, Redis is a NoSQL in-memory data structure store that can persist on disk. It can function as a database, a cache, and a message broker.

  • infoworld.com
  • Martin Heller

Finding relevant information quickly speeds up performance.

  • highgo.ca
  • Asif Rehman

Data is both our most valuable asset and our biggest ongoing challenge. As data grows in volume, variety and complexity, across applications, clouds and siloed systems, traditional ways of working with data no longer work.

  • neo4j.com
  • Navneet Mathur

Today’s video is a quick demonstration of deploying an Oracle Application Express (APEX) application using Liquibase. The video is based on a new article of the same name, which covers the deployment of both APEX workspaces and APEX applications using Liquibase.

  • oracle-base.com
  • Tim...

The Lambda architecture is a data-processing system designed to handle massive quantities of data by taking advantage of both batch (slow) and stream-processing (fast) methods.

  • mssqltips.com
  • John Miner

22nd Jun 2020

Node.js and MySQL is one of the necessary binding needed for any web application. MySQL is one of the most popular open source database in world and efficient as well. Almost every popular programming language like Java or PHP provides driver to access and perform operations with MySQL.

  • codeforgeek.com

Installation of Kubernetes and setting up a cluster can be a challenge as there are multiple steps to stand up a full fledged cluster. The steps I go through will setup a basic cluster which will be enough for any learning and practice you want to do.

  • dev.to

Git is a distributed version-control system for tracking changes in source code during software development.It is designed for coordinating work among programmers, but it can be used to track changes in any set of files.

  • dev.to
  • Jane Tracy