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

If you are following this blog post, you must be familiar that I have been authoring videos for the Pluralsight and many of my training videos are on Pluralsight.

  • blog.sqlauthority.com

Nominations for the seventh annual MongoDB Innovation Awards are now open until April 29th! The Innovation Awards are presented annually to honor groundbreaking use of data and the creativity of professionals expanding the limits of technology with MongoDB.

  • mongodb.com

Amazon DynamoDB provides our customers a fully-managed key-value database service that can easily scale from a few requests per month to millions of requests per second.

  • aws.amazon.com
  • Harunobu Kameda

The Ingress API in Kubernetes has enabled a large number of controllers to provide simple and powerful ways to manage inbound network traffic to Kubernetes workloads. In Kubernetes 1.18, we’ve made 3 significant additions to this API:

  • kubernetes.io

As discussed in part one, this series is meant to go over some of the biggest differences you will likely encounter when moving from on-premise to the cloud.  In this portion, I’ll look at the architectural and operational differences that are commonly seen.

  • percona.com
  • Mike Benshoof

Microservices and containers have taken the tech industry by storm. Kubernetes is one of the tools that has evolved to manage these new aspects of software development. It is an open-source system for automating deployment, scaling, and management of containerized applications.

  • logz.io
  • Gedalyah Reback

In this article, I’m going to explain the Dynamic Data Masking feature in SQL Server. As it goes by the name, Dynamic Data Masking is one of the security features that was introduced in SQL Server 2016.

  • sqlshack.com
  • Aveek Das

Consider for a moment which fundamental pieces of technology enable the modern web. Odds are, you’re thinking about things like Javascript and HTTP—and yes, they are fundamental parts of the modern web.

  • logz.io
  • Gedalyah Reback

ProxySQL has gained a lot of interest right now in the MySQL and MariaDB database world, not to mention ClickHouse which helps make the case for ProxySQL.

  • severalnines.com
  • Paul Namuag

Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented procedures for automating tasks, and that PowerShell may have what you need instead.

  • red-gate.com

Today, March 31, 2020, is World Backup Day. So I thought I’d take the time to blog a bit on the importance of preparing and testing your database backup and recovery plans. The recoverability of your organization’s data is perhaps the most important thing that a DBA must do.

  • datatechnologytoday.wordpress.com
  • Craig

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) Today I’m quite happy to announce my upcoming SQLpassion Online Training for April.

  • sqlservercentral.com
  • Contributors

1st Apr 2020

On StackExchange for Database Administrators I recently have seen a question which attracted my interest. The question puzzled me a bit because the answer seems too easy. Further the question was not so clear. An all theses factors smell dangerous...

  • fromdual.com

Having a multi-datacenter setup is a common topology for a Disaster Recovery Plan(DRP), but there are some limitations around implementing this kind of environment.  You should first solve the communication between the data centers by using SSH access or configuring a VPN.

  • severalnines.com
  • Sebastian Insausti

Wouldn’t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence.

  • cloudblogs.microsoft.com
  • SQL Server Team

Working on a weekend project,  I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14,  so I wanted to share how it can be used. The keyword “LATERAL” comes into play when you work with derived tables.

  • percona.com
  • Vadim Tkachenko

NetApp sponsored this post. The rules around IT service delivery are changing. This is because we’re in a world where IT stability is a set expectation rather than an ask.

  • thenewstack.io
  • Joseph Christianson

PostgreSQL has a rich set of indexing functionality, and there are many articles explaining the syntax, usage, and value of the index. In this article, I will write basic and useful queries to see the state of database indexes.

  • percona.com
  • Ibrar Ahmed

1st Apr 2020

ksqlDB is an event streaming database. What exactly does that mean? An event streaming database is a particular kind of database that helps you build stream processing apps. It consolidates the many components found in virtually every event streaming architecture.

  • ksqldb.io

1st Apr 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

One of the features I was asked to implement for WorkloadTools is the ability to replay commands to a database name different from the one recorded in the source workload. This is something that I had been planning to implement for a while and it totally makes sense.

  • sqlservercentral.com

As we continue to face increasing concerns about COVID-19, many organizations and HR professionals are facing new and unprecedented challenges. In an effort to help, we are providing free access to our Workforce Health and Safety solution to current Oracle Human Capital Management Cloud customers.

  • oracle.com
  • Gretchen Alarcon

One of the most common questions I get as a Technical Account Manager (TAM) from clients considering a migration from their current on-premise data center to AWS is “what are the biggest differences I will need to address?”  In an earlier post MySQL to the Cloud! Thoughts on Migrating Away from

  • percona.com
  • Mike Benshoof

You need a database. Maybe you need more than one. Fifteen years ago you’d choose MySQL if you were from the open source camp, SQL Server if you were on the Microsoft stack, and Oracle if you were operating in a large enterprise.

  • dev.to
  • Matthew Revell

In the previous article we’ve practiced SQL, and today, we’ll continue with a few more SQL examples. The goal of this article is to start with a fairly simple query and move towards more complex queries.

  • sqlshack.com
  • Emil Drkusic

Hello All, Oracle announced a limited period free access to Oracle Learning and Certifications on OCI and Autonomous Database technologies. Its absolutely free of cost for everyone. Indeed it is a very good chance everyone to learn something new to update Oracle knowledge and get certified.

  • jaffardba.blogspot.com
  • The Human Fly

Job alert We've received a couple of solid responses to our offer last week, in which we invited organizations seeking tech staff to tackle the coronovirus pandemic to send in their recruitment ads and we would run them for free online. No catch, snark, nor strings attached.

  • theregister.co.uk
  • David Gordon

In past tips, Using SFTP with SQL Server Integration Services and SFTP in SQL Server Integration Services SSIS Package with Bitvise, we looked at how to use SFTP to transfer files via SQL Server Integrations Services (SSIS).

  • mssqltips.com
  • Joe Gavin

Mysqldump is the most popular logical backup tool for MySQL. It is included in the MySQL distribution, so it’s ready for use on all of the MySQL instances.  Physical backups are usually all or nothing type of backups.

  • severalnines.com
  • Krzysztof Ksiazek

Replication has been a crucial part of Database Systems for decades for providing availability and disaster recovery.

  • blog.couchbase.com
  • Chaitra Ramarao