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


Data, AI, intelligent applications. They’re no longer separate topics, or even separate conferences. O’Reilly announced that it is merging its data and AI conferences, saying, “Data feeds AI; AI makes sense of data.” Further, both power applications.

  • neo4j.com
  • Patrick Wall

In the spirit of Grant Fritchey's recent rants, and Erin Stellato's efforts since I think before we met, I want to get on the bandwagon to trumpet and promote the idea of ditching trace in favor of Extended Events. When someone says trace, most people immediately think Profiler.

  • sqlperformance.com
  • Aaron Bertrand

Lot of people does migration from Oracle's PL/SQL to PostgreSQL's PL/pgSQL. One question is how to migrate private functions? There is not a reply. Oracle's PL/SQL is little bit modified language ADA. This language is procedural and modular.

  • postgr.es
  • Pavel Stěhule

After making its mark in the OLTP world, PostgreSQL is moving towards catering the needs of OLAP environment. Hence, the recent advancements in features like parallel query, declarative partitioning, and partition-wise joins and aggregates, etc. Since the introduction of parallel query in v 9.

  • rafiasabih.blogspot.com

Question: How to Join Two Tables Without Using Join Keywords? Answer: In my life, I have attended many interviews as an interviewer. Sometimes the interview panel is asking progressive positive questions and sometimes they ask a question which is regressive.

  • blog.sqlauthority.com
  • Consulting

When choosing a NoSQL database technology important considerations should be taken into account, such as performance, resilience, reliability, and security. These key factors should also be aligned with achieving business goals, at least as far as the database is concerned. 

  • severalnines.com
  • Onyancha Henry

Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have an EXTRA log file? The short answer is: desperate times.

  • desertdba.com
  • Jeff Iannucci

Artificial Intelligence (AI) is no longer in its infancy; it is an essential business transformation tool to deliver results with impact.

  • ibmbigdatahub.com
  • Karan Sachdeva

One of the very popular questions I receive is how to import data from Excel in SQL Server. Let us learn about that in this blog post and we will use SQL Server Management Studio for this exercise. First, create any sample data in Excel. I will be using this sample excel for our example.

  • blog.sqlauthority.com
  • Consulting

The second of three articles focused on building Fullstack React and GraphQL with Express and Couchbase Server. If unfamiliar with GraphQL, take a few minutes to get up to speed using the GraphQL documentation. The following pages should be a good start:

  • blog.couchbase.com
  • Eric Bishard

1st Mar 2020

The DB-Engines Ranking ranks database management systems according to their popularity. The ranking is updated monthly. Read more about the method of calculating the scores.

  • db-engines.com

Can you run Oracle SQL Developer Web for your on-premise Oracle Database? Can you run Oracle SQL Developer Web for 2 or more on-premise Oracle databases, pluggable or completely separate instances?

There are a lot of things I love about Prometheus; its data model is fantastic for monitoring applications and PromQL language is often more expressive than SQL for data retrieval needs you have in the observability space.

Any performance feature in PostgreSQL that mentions the “parallel” keyword excites me. So it was natural that parallel vacuum took my complete attention when it was committed in January 2020.

I will try to make it short and clear: if you are writing SQL queries with “NOT IN” like SELECT … WHERE x NOT IN (SELECT y FROM …) you have to be sure to first understand what happens when “x” or “y” are NULL: it might not be what you want! And if it is not, I will tell you here ho

I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines of “but David, I’m seeing SOS_SCHEDULER_YIELD, we must have CPU issues”.

In this article, I have explained the step by step process of migrating data from SQL Server to Azure Cosmos database. To perform database migration, we will proceed in the following manner: To understand the data migration process, I have explained it into multiple steps.

Over the past few years, MariaDB Corporation has heard from countless Oracle database users seeking to replace their database platform to achieve a lower cost and increased operational flexibility.

Replication lag issues in PostgreSQL is not a widespread issue for most setups. Although, it can occur and when it does it can impact your production setups.

PonyORM makes database interactions easy. Developers can query a SQL database in Python syntax, and allow Pony to translate Python queries into SQL and execute them in the most efficient way. But database interactions are only half the battle.

Yes, by default your InnoDB transactions don’t have the Atomicity . But, you can control the atomicity of your InnoDB transaction with the variable innodb_rollback_on_timeout. We had a weird data inconsistency issue within the transaction .

Trends in cloud data storage continue to accelerate at a rapid pace. Now more than ever, organizations must evaluate their current and future data storage needs to find solutions that align with business goals.

With the release of YugabyteDB 2.1 earlier this week, we introduced many exciting new features: performance optimizations, 2DC and read replica support, and more.

When I was first presented with the opportunity to work remotely I was ecstatic. What could be better than no commute and working from the comfort of my own home?! And while both of those things are great perks, learning to love the remote life took some time.

There really are technology stacks and business use cases that should never be moved off of big iron. Then there’s the rest of us. Chances are very high if you’re not already starting to move your data storage to the cloud, it’s being discussed right now in your business.

27th Feb 2020

Look at an intro to the MySQL database (an RDBMS) and go through its architecture and features that make it the best choice for developing web apps or websites. One of the numerous important aspects for the smooth functioning of a website or a web app is the strength of its database.

Some pros and cons of running production databases as containers include databases on demand, high disk usage, automated stateless containers, and more. Containerization has long been transforming the way we develop and deploy apps and microservices now.

As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent.

It is sometimes inevitable to run MySQL database servers on a public or exposed network. This is a common setup in a shared hosting environment, where a server is configured with multiple services and often running within the same server as the database server.