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


Using a Load Balancer is a good idea for any database technology, as you can redirect applications to the available or healthy database nodes and even distribute the traffic across multiple servers to improve performance. This is not only useful on-prem but also in a cloud environment.

  • severalnines.com
  • Sebastian Insausti

In the article, Python scripts to format data in Microsoft Excel, we used Python scripts for creating an excel and do various data formatting. Python is an interesting high-level programming language. You can go through various use cases of Python on SQLShack.

  • sqlshack.com
  • Rajendra Gupta

There is a lot of interest and discussions lately in the PostgreSQL world to make it a scale-out solution. Among other possible solutions, one of the most promising ones is to implement the sharding using FDW and table partitioning for distributing the data on multiple servers.

  • postgr.es
  • muhammad usama

Hello MongoDB Learners! I’m Mary Alati, Growth Manager for the Education team here at MongoDB. As we grapple with the enormous scale and human impact of the current global crisis, MongoDB is determined to continue to support our community during these difficult times.

  • mongodb.com

As organizations face increasing pressure to modernize their applications and infrastructure, the benefits of the cloud have become impossible to ignore. Fortunately, Azure SQL Database managed instance makes it easy to move your SQL Server workloads to the cloud.

  • cloudblogs.microsoft.com
  • SQL Server Team

People have been writing about how evil scalar functions are in SQL Server for ten years. But people still use scalar functions in their code all the time. And not dumb people, either: smart people do this, too. I bet you they’re in your codebase.

  • littlekendra.com

Let’s wrap this up. In part 1 of this blog series, I explained the different Windows build targets supported by PostgreSQL. In part 2, I showed how to test patches for Windows compatibility and how to easily spin up a Windows environment for testing and simple development.

  • 2ndquadrant.com
  • Peter Eisentraut

Greetings! This is Eldin reporting from the Solutions Engineering team at Grafana Labs. In previous posts, you might have read about Grafana’s Splunk or ServiceNow plugins. In this week’s post, I am introducing Aengus, who will be covering our Oracle Enterprise data source. – Eldin

  • grafana.com
  • Aengus Rooney

24th Mar 2020

Or database developer, report writer, whatever. SQL Server, SQL Server Management Studio, and all the tools provide a bunch of ways to get things done. However, some ways are more efficient than others.

  • scarydba.com
  • Grant Fritchey

In the mid 1990s, long, long before I went into IT as a career, I was working at a photo studio in Muskegon, Michigan. They specialized in high school class photos, and they did a LOT of ’em.

  • brentozar.com
  • Brent Ozar

Harbinder Kang Harbinder Kang is Global Head of Developer Operations at Finastra, one of the world’s largest providers of financial technology.

  • thenewstack.io
  • Harbinder Kang

We’ve got a session coming up in the free Redgate Streamed virtual conference on, “How database DevOps levels up remote work.” When thinking about that session I began thinking about other ways to improve remote work.

  • littlekendra.com

We all love MySQL and want to make sure that our apps work seamlessly. However, there are hopes and there is reality 🙂 So in this article, we have decided to list the top 5 MySQL monitoring tools.

  • eversql.com

In this article, look at seven metrics to compare SQL and NoSQL. Organizations who want to take advantage of the many benefits of NoSQL databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model.

  • dzone.com
  • Binh Le

There are many users of MySQL in Cloud environment regions. It’s ideal that those MySQL instances are implemented with only private-ips in the respective Subnet. No public-ips. For that matter, all cloud infrastructure resources are ideally placed behind networks that provision only private-ips.

  • thesubtlepath.com
  • Andrew Grimo

You must have learned capitalization rules in your grammar school, but the real-world search is not so sensitive to capitalization.

  • blog.couchbase.com
  • Keshav Murthy

Modern IT needs to have a non-relational, dynamic schema (meaning no requirements for Joins Statements Queries) to provide support for Big Data/real-time applications.

  • severalnines.com
  • Gayathri Mageswaran

In our previous posts in this series, we discussed the case for connection pooling and introduced PgBouncer. In this post, we will discuss its most popular alternative – Pgpool-II. Pgpool-II is the swiss army knife of PostgreSQL middleware.

  • scalegrid.io

Monitoring has been around since the dawn of computing. Recently, however, there’s been a revolution in this field. Cloud native monitoring has introduced new challenges to an old task, rendering former solutions unsuitable for the job.

  • logz.io
  • Mike Elsmore

A group of technology leaders from organizations such as Facebook and Kleiner Perkins has launched a volunteer initiative to find IT professionals to set up and run the tech to help the U.S. federal, state and local governments respond to the COVID-19 pandemic. The effort, called the U.S.

  • thenewstack.io
  • Joab Jackson

Percona Monitoring and Management 2.4.0 (PMM), released several days ago, added support for custom extensions of the Prometheus configuration file. Before explaining what that is and how to use it, let me tell you a bit of history. PMM 1.4.0, released 2.

  • percona.com
  • Alexey Palazhchenko

The March release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.

  • cloudblogs.microsoft.com
  • Alan Yu

23rd Mar 2020

If you use Automatic Plan Correction, and thus also Query Store, you may wonder how was a plan forced: manually or automatically with APC?  The type of forced plan is tracked in sys.query_store_plan, and you can use this simple query to determine how a plan was forced: SELECT p.is_forced_plan, p.

  • sqlskills.com
  • Erin Stellato

Interested in learning more about how Apache CouchDB is adopting FoundationDB as a new engine for future releases? Look no further! Adam Kocoloski, recently went on the Data Engineering Podcast to talk about the overall effort and the anticipated benefits forthcoming for CouchDB users.

  • blog.couchdb.org
  • joshuamintz

Recently, a client using Aurora was reaching the max connection limit of 16,000 (that is Aurora’s hard limit for all instance classes). In this case, Percona recommended implementing ProxySQL to manage connections (now their max connections only peak to 6000!).

  • percona.com
  • Jake Davis

Of all the things that Extended Events does, I’ve found the ability to quickly and easily gather a little bit of data and then use the Data Explorer window Live Data grouping to aggregate it to be one of the greatest.

  • scarydba.com
  • Grant Fritchey

Temporary tables, also known as temp tables, are widely used by the database administrators and developers. However, it may be necessary to drop the temp table before creating it. It is a common practice to check whether the temporary table exists or not exists.

  • sqlshack.com
  • Esat Erkec

Our commitment to protecting the global IT community is stronger than ever, even amidst concerns that cybercriminals are searching out ways to exploit the disruptions

  • cisecurity.org

The world is moving to the cloud and distributed services, and these modern applications need a relational database built for Kubernetes that delivers a SQL interface.

  • cockroachlabs.com

Combining overlapping intervals in order to compute the missing intervals could be a complex task for advanced programmers. This article presents a new solution based on usage of geometry data type and on a unknown function (if not, maybe less used function) specific designed for geometry objects.

  • sqlservercentral.com
  • Contributors