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


If you missed out on my online class, I’m offering two more dates for it in July. You can catch all the goodness of Premium Performance Tuning on July 10th and 24th.

  • erikdarlingdata.com
  • Erik Darling

Your success is important to us! Investing in MongoDB training pays off, whether you’re an individual building your own skills or a manager providing learning resources for your team. Instructor-led training is the fastest way to improve your team's skills.

  • mongodb.com

In this article, I am going to explain how we can easily debug Python scripts using the Visual Studio (VS) Code. In my previous article on this topic, I have explained how to set up a development environment to start coding in Python.

  • sqlshack.com
  • Aveek Das

24/7 Production Support Developer Support Remote DBA for PostgreSQL PostgreSQL Database Monitoring PostgreSQL Health Check PostgreSQL Performance Tuning Database Security Audit Upgrade PostgreSQL PostgreSQL Migration Assessment Migrate from Oracle to PostgreSQL

  • 2ndquadrant.com
  • Liaqat Andrabi

SQL Change Automation makes automation simple enough that it can adapt to suit many different approaches to SQL Server database development.

  • red-gate.com
  • ANTS Performance Profiler

This article is the fourth part in a series on table expressions. In Part 1 and Part 2 I covered the conceptual treatment of derived tables. In Part 3 I started covering optimization considerations of derived tables.

  • sqlperformance.com
  • Itzik Ben-Gan

Yesterday, one of the developers was having a problem and emailed to ask what was going on. They sent me a section of code from an old trigger that included some date handling that looked “interesting”.

  • oracle-base.com
  • Tim...

Keeping up with the educational requirements of supporting multi-platform database environments can be challenging to say the least. One way to help address this issue is to use a standardized support tool such as DBArtisan that lets you manage and administer multiple database platforms from a unified interface.

  • community.idera.com

Scylla is a highly performant, scalable, distributable and reliable database. Yet even the most reliable of databases can suffer from catastrophic unplanned outages (such as in the underlying infrastructure). That’s why it is vital to keep backups.

  • scylladb.com
  • Aleksandar Jankovic

Every startup has a choice: Begin building with something familiar (Postgres, MySQL…) or begin building with something new (CockroachDB). Using a familiar database means that engineers can hit the ground running and begin building on a trustworthy platform.

  • cockroachlabs.com
  • Dan Kelly

7th Jul 2020

At the moment, we hear a lot about how businesses need to become data-driven to remain competitive, how business need to understand their customer’s needs and quickly deliver value to those customers. But how do you do that?

  • sqlmaria.com
  • Maria Colgan

The first step of working with any software is getting it installed. Based on your environment, this could be as easy as a one-click installer, or require a manual that's hundreds of pages long with thousands of config bits to tune.

  • info.crunchydata.com
  • James Chanco Jr.

Elasticsearch powers search experiences for so many tools and apps used today, from operational analytics dashboards to maps showing the closest restaurants with patios so you can get out of the house.

  • elastic.co
  • Tomas Della Vedova

If you’re a Python developer—and since you’re reading this, you probably are—you’ve almost certainly used Redis and thought it was a great cache. (That was my first impression, too.) And Redis does make a great cache.

  • redislabs.com
  • Guy Royse

WARP is based on Fastbit, which is currently version 2, and is used in production in a number of large scientific applications, such as grid computing analysis of particle accelerator data, working with genomic data, and other applications. WARP has been tested by a variety of alpha users.

  • swanhart.livejournal.com

In this article, we will demonstrate specific ways to automate table partitioning in SQL Server. This article aims to help you avoid manual table activities of partition maintenance by automating it with T-SQL scripts and SQL Server jobs.

  • sqlshack.com
  • Jignesh Raiyani

Deleting and updating data is very common, but if performed without taking care, which could lead to inconsistent data or data loss. Today, we’ll talk about SQL best practices when performing deletes and updates.

  • sqlshack.com
  • Emil Drkusic

Join Peter Zaitsev, Percona CEO, as he discusses MySQL 8 Observability. Broken MySQL means broken application, so maintaining insights in MySQL operational performance is critical.

  • percona.com
  • David Quilty

The MongoDB Database Tools are a collection of command-line utilities for working with a MongoDB deployment. These include, among other things: mongodump, mongorestore, mongoimport, and mongoexport. For a long time now, the tools have been bundled into each MongoDB Server release.

  • mongodb.com

In this article, I am going to explain how we can configure the iSCSI initiator and use it to connect to the iSCSI virtual disk on the target server. The iSCSI initiator (Internet small computer system interface) is used to connect to the iSCSI based external storage.

  • sqlshack.com
  • Nisarg Upadhyay

Db2 Offering team organized a Db2 webinar series on various topics. This series was open to all and we received overwhelming participation from you. Since we could not cover all the time-zones, we recorded the webinars to make them available to you.

  • mailchi.mp

In recent weeks I've been re-learning Go, looking for similarities with existing Java libraries. Naturally, I went on a search for storing and retrieving data from an Oracle database. There are no shortages of options in the Java space for interacting with data stored in a database.

  • blogs.oracle.com
  • Andres Almiray

MySQL has multiple mutex implementations viz. wrapper over pthread, futex based, Spin-Lock based (EventMutex). All of them have their own pros and cons but since long MySQL defaulted to EventMutex as it has been found to be optimal for MySQL use-cases.

  • mysqlonarm.github.io
  • Freepik

The fleet management industry has been quick to embrace technology. They want to understand the current state of vehicles and drivers to improve operations and safety. Data privacy laws are especially important as fleet managers expand their reach into new territories.

  • influxdata.com
  • Caitlin Croft

Every great data-driven product starts with a series of questions. What problem are we trying to solve? Who is our target user? How are we going to measure success? Building a great search experience is no different.

  • elastic.co
  • Josh Devins

Index builds on MongoDB production clusters need to be handled with the utmost care. We have documented the issues in detail in one of  our previous blog posts – The Perils of Building Indexes on MongoDB.

  • dzone.com

PostgreSQL has become the preferred open-source relational database for many enterprise developers and startups, and powers leading business and mobile applications.

  • aws.amazon.com

Late last year I told you about AWS Outposts and invited you to Order Yours Today.

  • aws.amazon.com
  • Jeff Barr

Overview of N1QL (SQL for JSON) support for full text search in Couchbase. (With SQL) Your app is sitting on a Ferrari-style compute engine. — Lukas Eder Over time, the database industry has realized text search and SQL are two sides of the same coin.

  • dzone.com
  • Keshav Murthy

When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL.  Below are some of the most important of these settings to help you get started. The first thing to look at is what swappiness is set to.

  • percona.com
  • Michael Patrick