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


When forced to choose, quality wins out over speed seven out of 10 times according to a survey of over 600 IT professionals conducted by OverOps, a vendor that helps identify and remediate software issues. In the real world, the choice is not stark.

  • thenewstack.io
  • Lawrence E Hecht

Security, when done right, not only protects your data but improves performance, system stability, and enhances the development life-cycle. Because PostgreSQL security can easily become an all-encompassing activity, we’ll deal with the most common mechanisms.

  • percona.com
  • Robert Bernier

A hapless IT bod found the Have I Been Pwned service (HIBP) answering its own question in a way he really didn’t want – after a breach report including a SQL string KO’d his company’s helpdesk ticket system.

  • theregister.com
  • Gareth Corfield

We are happy to announce that the YugabyteDB Operator is now certified and available as a Beta release on Red Hat OpenShift, a leading enterprise Kubernetes platform for deploying and managing cloud native applications.

  • blog.yugabyte.com
  • Nikhil Chandrappa

Data ingestion and data analysis are the yin and yang of a time series platform. There are many resources to help you ingest data. Typical ingestions are agent-based, imports via CSVs, using client libraries, or via third-party technologies.

  • influxdata.com
  • Nate Isley

First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide during the webinar.

  • percona.com
  • Sveta Smirnova

There is no SQL Server Agent for AzureSQL, how can I create scheduled jobs to run on my AzureSQL database? Azure has a service named Logic App that let you to create and schedule tasks to perform actions on other Azure resources, including AzureSQL databases.

  • mssqltips.com
  • Vitor Montalvao

Quite recently, I reached a milestone of 10k post views in Dev. Which might seem less to you but a lot to me. You know, it feels good to see people reading your posts(and giving some unicorns 🦄). And I thought it would be a good idea to have a better visualization of the data that dev.

  • dev.to

A while ago, I wrote about B-tree improvements in v12. PostgreSQL v13, which will come out later this year, will feature index entry deduplication as an even more impressive improvement. So I thought it was time for a follow-up.

  • cybertec-postgresql.com
  • Laurenz Albe

We’re excited to bring to you three new training courses we just published on our GraphAcademy site: Introduction to Neo4j 4.0, Graph Data Modeling for Neo4j and Basic Neo4j 4.0 Administration. This course is an update to the course Introduction to Neo4j 3.

  • neo4j.com
  • Elaine Rosenberg

Welcome back to the Maven series. Now that we have covered the basics we're ready to continue the journey. As it happens dependency resolution is one of Apace Maven's greatest assets but also a source of frustration when things do not go as expected.

  • blogs.oracle.com
  • Andres Almiray

Wordfence announced that between May 29 and May 31 over 130 million attacks against 1.3 million sites attempting to download database credentials were blocked.

  • exchange.xforce.ibmcloud.com

Liquibase has offered for a very long time, the ability to define changeSets using SQL. In fact, according to their survey, it’s the MOST popular way of developing your schema deployment scripts. And it’s no surprise as to to why.

  • thatjeffsmith.com
  • thatjeffsmith

We’re honored to be named the Most Loved Database for the fourth consecutive year in Stack Overflow’s 2020 Developer Survey.

  • redislabs.com
  • Kyle Davis

When developing iOS applications, it is often necessary to store, search and filter data, and the best way to do that is to use a database.

  • dev.to

Hello all! With some extra time on my hands, I'm given the perfect opportunity to perfect the art of technical interviewing before recruitment season. One way I'm bettering my interviewing skills is nailing the fundamentals.

  • dev.to

In systems nowadays, improving security is a must! One of the weakest links in the security system is the user password from where an attacker can enter.

  • percona.com
  • Carlos Tutte

Antonios Chalkiopoulos Antonios Chalkiopoulos is the CEO and co-founder of Lenses.io.

  • thenewstack.io
  • Antonios Chalkiopoulos

Time to Live (TTL) is a Scylla (and Apache Cassandra) feature that is often used but not always fully understood. Scylla provides the functionality to automatically delete expired data according to TTL. We recently updated our documentation and added a new lesson on this topic to Scylla University.

  • scylladb.com
  • Guy Shtub

If constraints in general have caught your interest, our interactive learning portal has a whole section on the use of non-spatial constraints, even a video walkthrough! In our last installment, we covered the use of CHECK constraints to enforce data quality at an object level.

  • info.crunchydata.com
  • Paul Ramsey

With high availability being paramount in today’s business reality, one of the most common scenarios for users to deal with is how to ensure that the database will always be available for the application.

  • severalnines.com
  • Krzysztof Ksiazek

In this article, we’ll look at using the built-in PWDCOMPARE function in SQL Server for security testing passwords.

  • sqlshack.com
  • Timothy Smith

3rd Jun 2020

With shifting priorities and dynamic technology environments, IT security teams are looking for ways to cover the most ground while draining as few resources as possible. Privileged access... As a security professional, you’re busier than ever, juggling work, life and everything in between.

  • cyberark.com

In the previous post, we went through some built-in tools and methods for identifying key metrics and values on your systems.

  • elastic.co
  • Jamie Smith

These are my SQL Server Diagnostic Information Queries for June 2020, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a short amount of time.

  • glennsqlperformance.com
  • Glenn Berry

The leaked data was obtained after the hacker breached DH earlier this year, on March 10, 2020. At the time, DH owner Daniel Winzen told ZDNet the hacker breached his portal, stole its database, and then wiped all servers.

  • zdnet.com
  • Catalin Cimpanu

SQL Azure Database by default offers a 99.99% availability SLA across all its service tiers. This means that for any database, the downtime should not exceed 52 minutes per year. Using Zone redundancy increases availability to 99.995% which is about 26 minutes per year.

  • blog.dbi-services.com
  • Steven Naudet

How might we model graphs beyond the most common use cases, and take a more creative approach to graph modeling? This post introduces the Graph Commons platform and walks through novel graph examples from the community.

  • neo4j.com
  • Burak Arikan

You need to bring an offline SQL Server user database back online. To see how to take a SQL Server database offline read this tip - How to Take SQL Server Database Offline.

  • mssqltips.com
  • Joe Gavin

Bill Kennedy is no stranger to databases - in fact, he has helped several businesses build applications on databases for years. He began working with SQL before moving on to NoSQL. In 2020, however, Bill started using Dgraph because it provided what he needed but in a new and modern package.

  • dgraph.io
  • Zhenni Wu