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

During my parameter sniffing classes, people get a little exasperated with the complexity of the problem. Parameter sniffing is totally hard. I get it. At some level, it’d be great to just hit a magic button and make the whole thing go away.

  • brentozar.com
  • Brent Ozar

30th Jun 2020

Last month IBM announced that Db2 v11.5.4 is planned to be generally available on June 30, 2020. As in prior releases, each of the Db2 v11.5.4 editions have the same capabilities including BLU Columnar tables, Adaptive Compression, Encryption, and many more. Db2 v11.5.

  • medium.com
  • Kay Groski

After a fresh introduction of community bonding, On June 1st, coding of GSoC had started officially with phase 1. At this point, every GSoC student should be expected to have a rigid plan with their entire project.

  • jenkins.io
  • Loghi Perinpanayagam

Whoo! It’s been six months since my last post. There are reasons for this, none of which are probably valid, but it’s the way it is. I’ve been a full-time DBA for just over a year now, and Kevin thought it would be a good time to review how far I’ve come thus far.

  • sqlservercentral.com
  • Contributors

In this article, I am going to explain how we can install and configure the iSCSI Target Server Role on Windows Server 2016.

  • sqlshack.com
  • Nisarg Upadhyay

While there is no magic bullet for MySQL tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation.

  • percona.com
  • Brian Sumpter

A typical database-oriented application setup only must work with single operation SQL or RESTful execution. Your customers might only be sending the INSERT or UPDATE queries one at a time.

  • 2ndquadrant.com
  • Muhammad Haroon

A DBA Overview of Zowe CLI and the IBM Db2 Database Plugin for Zowe CLI{Ecosystem} In 2018, when The Linux Foundation’s Open Mainframe Project (OMP) introduced Zowe to the Mainframe world, the contributors not only introduced Open Source and the power of the open source community to mainframers

  • medium.com
  • Rose Sakach

In this article, we will discuss and understand a method to migrate an on-premises SQL Server database to the Azure SQL database.

  • sqlshack.com
  • Prashanth Jayaram

IBM’s World Community Grid is working with scientists at Scripps Research on computational experiments to help find potential COVID-19 treatments. Anyone with a Raspberry Pi and an internet connection can help.

  • raspberrypi.org
  • Alex Bate

In the late 70s and early 80s, a team was assembled at IBM’s lab in San Jose to create Db2, the world’s first enterprise-level relational database, based upon Edgar Codd’s seminal paper and subsequent IBM research.

  • ibm.com

So you running MySQL with the validate_password plugin. What about existing users and their passwords? How do you check that those passwords are ok and aren’t bad like ‘123456’ or easily guessable like ‘Tuesday2020!’? and how do you fix them.

  • dbadojo.com
  • paulmoen

Version of the Oracle JDBC drivers and related binaries have been recently posted to Maven Central.

  • blogs.oracle.com
  • Andres Almiray

In a factory environment, collecting data to gain useful insights from various sources is challenging because it requires connecting to many different types of automation systems, plcs and devices that often speak different languages.

  • influxdata.com
  • Chris Churilo

This is tutorial to setup 2 innodb clusters and create Replication using REPLICATION FILTER to define replication channel across 2 InnoDB Cluster. Background InnoDB Cluster setup is commonly found within a Data Center (DC1) where the network is good and reliable.

  • mysqlhk.blogspot.com
  • Ivan Ma

In a previous tip on Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1, I have seen how to install a SQL Server 2016 on a Windows Server 2016 failover cluster (WSFC). We are deploying SQL Server 2017 failover clusters running on Windows Server 2016.

  • mssqltips.com
  • Edwin Sarmiento

MariaDB Server 10.5 is a fresh, new, and stable version from MariaDB that was released on June, 24th 2020. Let’s take a look at the features that it will bring us. With MariaDB 10.5 some changes regarding the privileges are coming.

  • severalnines.com
  • Krzysztof Ksiazek

Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option.

  • percona.com
  • Przemysław Malkowski

Multiple buffer overflow vulnerabilities exist in IBM® Db2® leading to privilege escalation from an authenticated local user to root.

  • ibm.com

Db2 is vulnerable to a denial of service. Db2 could allow an attacker to send specially crafted packets to the Db2 server to cause excessive memory usage and cause Db2 to terminate abnormally.

  • ibm.com

The global_name in an oracle database has a direct impact on the Golden Gate Extract process registration we need to do when we create an Integrated Extract.

  • blog.dbi-services.com
  • Lazhar Felahi

SQL Server Always On is a high-availability and disaster recovery solution. We can use multiple secondary replicas for configuring database backups, redirect read requests to offload primary instance load.

  • sqlshack.com
  • Rajendra Gupta

In this article, we will discuss a number of questions that you may be asked while being interviewed for a SQL Server Database Administrator (DBA) position. These questions will concentrate on the SQL Server connectivity concept, components, configurations, and troubleshooting.

  • sqlshack.com
  • Ahmad Yaseen

This article explores various ways to search for database objects in SQL database such as tables, stored procedures, functions, and views. SQL Server has many database objects such as table, view, stored procedure, function, constraints, rule, Synonym, triggers.

  • sqlshack.com
  • Rajendra Gupta

Are you aware that you may be entitled to a free SQL Server license in the cloud for disaster recovery? Recently-announced licensing benefits enable this scenario, and a third-party offering from DH2i can help you set up this configuration to ensure business continuity for your business.

  • cloudblogs.microsoft.com
  • SQL Server Team

In a recent blog post I illustrated how to use the OCI Command Line Interface (CLI) in shell scripts. While the OCI CLI is comprehensive and powerful, it may not be the best solution when you need to handle a lot of data in shell scripts.

  • blogs.oracle.com
  • Philippe Vanhaesendonck

In 2006, a small company formed in North Carolina, specializing in MySQL database consulting at a time when very few companies had fully embraced open source.

  • percona.com
  • Brian Sumpter

The world used to get by on just a smattering of databases. You know, trusty relational workhorses like Oracle, Microsoft SQL Server, Ingres, and IBM DB2. Soon enough, however, open source crashed the party with MySQL and PostgreSQL.

  • infoworld.com
  • Matt Asay

Today’s post is a guest article written by a friend of the blog, Kevin Kline, an expert on SQL and Microsoft SQL Server. SQL Server can suffer from all sorts of problems if it is not properly optimized, and thankfully with the help of performance tuning, you can overcome common complications.

  • datatechnologytoday.wordpress.com
  • Craig

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