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


A 3 node Oracle extended RAC has been successfully upgrade from 11.2.0.1 to 12.1.0.2 just last week. As part of the upgrade planning, we started off with GRID home upgrade process from 11.2.0.4 to 12.1.0.2, followed by DB upgrade from 11.2.0.1 to 11.2.0.4 and finally DB upgrade to 12.1.0.2.

  • jaffardba.blogspot.com
  • The Human Fly

In celebration of Pi Day, I asked MemSQL’s Engineering team to come up with clever ways to compute pi in SQL.

  • memsql.com

One of my clients contacted me and asked me the reason for this message? And my first reaction was, did you keep the database in very cold weather? It might be freezing over there and that’s why SQL is saying:   “I/O is frozen on database” and “I/O was resumed on database”? Did you check

  • blog.sqlauthority.com

Multiple vulnerabilities have been discovered in Microsoft products, the most severe of which could allow for remote code execution. Successful exploitation of the most severe of these vulnerabilities could result in an attacker gaining the same privileges as the logged on user.

  • cisecurity.org

Have you ever run into an error like this? Cannot resolve the collation conflict between “pick a collation” and “pick another collation” in the equal to operation.

  • sqlservercentral.com
  • Jason Brimhall

Data often requires high end security on nearly every level of the data transaction so as to meet security policies, compliance, and government regulations. Organization reputation may be wrecked if there is unauthorized access to sensitive data, hence failure to comply with the outlined mandate.

  • severalnines.com
  • Onyancha Brian Henry

We supported more than a hundred developers who worked in an agile fashion. When I first joined the DBA team, we had a shared on-call rotation, but each DBA specialized in a certain area of the environment and regularly met with the development teams working on that area.

  • littlekendra.com

This article talks about Python scripts for creating pivot tables in multiple ways. You might use PIVOT tables in Microsoft Excel for data analytics, preparing reports. It helps us to extract meaningful information from a large data set.

  • sqlshack.com
  • Rajendra Gupta

I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class.

  • sqlservercentral.com
  • Brent Ozar

Hi, my name is Priyanshu Khandelwal. I was amongst the 40 students selected from all over the world to work at CERN as an Openlab Summer Student 2019. I worked in the IT-DB-DAR section under the supervision of Mr Antonio Nappi.

  • db-blog.web.cern.ch
  • Antonio Nappi

12th Mar 2020

You’re probably aware of the “identity” construct that appeared in 12.1 and uses Oracle’s sequence mechanism to model the Autonumber or Identity columns that other databases have.

  • jonathanlewis.wordpress.com

Short post today, and short video – but the content could save you HOURS of coding and working with your Oracle Database! This is very quick walk through of your favorite keyboard shortcuts in Oracle SQL Developer.

  • thatjeffsmith.com
  • thatjeffsmith

Quest's Foglight for Databases allows you to quickly and proactively monitor your entire database environment.

  • mssqltips.com
  • Greg Robidoux

You want a column data store? How about hstore? You don’t want to retrain your staff? Plug in the language of your choice and keep trucking. You want partial replication? Streaming Logical replication is for you.

  • 2ndquadrant.com
  • Kirk Roybal

The COVID-19 pandemic has forced many companies to encourage employees to work from home. It’s a new normal for many, but at Grafana Labs our team has always recruited and operated with a remote-first culture around the world.

  • grafana.com
  • Michelle Tan

Rearchitecting applications to run in the cloud can be a significant undertaking requiring time, money, and the appropriate skills.

  • cloudblogs.microsoft.com
  • SQL Server Team

In my organization we make extensive use of SQL Server Agent Jobs to schedule and execute our processing. Our SQL Agent job steps typically execute SSIS packages.

  • mssqltips.com
  • Ray Barley

In the business world, useful information about a population usually is gathered by studying a selected portion of the population. The portion is called a sample, and the process of selecting the sample is called sampling.

  • mssqltips.com
  • Nai Biao Zhou

(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.

  • sqlskills.com
  • Paul Randal

The above simply means the transaction has reached the innodb_lock_wait_timeout while waiting to obtain an exclusive lock which defaults to 50 seconds. The common causes are: Let's play around with a simple example to better understand the effect.

  • severalnines.com
  • Ashraf Sharif

12th Mar 2020

If you’re starting to work from home or just got a remote position, you’re probably looking forward to not spending time on a frustrating commute and staying in your pajamas until noon.

  • theverge.com
  • Kim Lyons

In today’s world, organizations increasingly face an unprecedented level of threat of cyberattacks against their information assets. Cyberattacks can come in many forms. One such attack is called SQL injection. With SQL injection, rogue players target the backend database of any system.

  • 2ndquadrant.com
  • Sadequl Hussain

In the article, Introduction to Firebase, an overview of Firebase was provided.

  • databasejournal.com
  • Bradley L. Jones

Prometheus has matured into a robust time-series metrics monitoring solution since it was first open-sourced in 2012. CNCF incubated it as its second project after Kubernetes in 2016 followed by graduation in 2018.

  • blog.yugabyte.com
  • Andrew Nelson

Abstract: Storage engine algorithmic gains have mostly settled and Moore’s law for CPU speed is bottoming out, but database performance still stands to increase ~10x thanks to continuing NAND Flash improvement, Optane, Flash-idiomatic SSD drives (e.g.

  • percona.com
  • Akira Kurogane

Database design and Logical Asseveration play a vital role in database performance and SQL Query optimization. Both have different parameters to make your database and the query accurate. Database design plays an essential role in the database performance side.

  • sqlshack.com
  • Jignesh Raiyani

Shopee is the leading e-commerce platform in Southeast Asia and Taiwan. It is a platform tailored for the region, providing customers with an easy, secure, and fast online shopping experience through strong payment and logistical support.

  • pingcap.com

Today, most organization are using solid-state drives for everything from laptops to enterprise database storage and virtual machines. In this article, Robert Sheldon explains how NAND flash solid-state drives work.

  • red-gate.com

I’ve been working remotely for just over 2 years now and my current position is my first remote post. Before joining my current company I (and them) had concerns about me working from home. Would I like it? Would I find it isolating? Would I go completely mad?

  • dbafromthecold.com
  • dbafromthecold

In today’s world, organizations increasingly face an unprecedented level of threat of cyberattacks against their information assets. Cyberattacks can come in many forms. One such attack is called SQL injection. With SQL injection, rogue players target the backend database of any system.

  • 2ndquadrant.com
  • Sadequl Hussain