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

A common issue that many companies often face, including DEV, is how much data access to give their engineers. Allowing engineers access to production data has many benefits.

  • dev.to
  • Molly Struve (she/her)

While you practice physical distancing (words I never thought I’d daisy-chain together), I’m giving away free SQL Server training. So far, we’ve covered building a query plan and how to find the right queries to tune.

  • brentozar.com
  • Brent Ozar

Welcome back to this series of blog posts where we look at the mighty RDBMS and learn how to take advantage of some of the powerful capabilities available to us to make better microservices and service driven applications.

  • blogs.oracle.com

A colleague was recently trying to deploy a change to a SQL Server user defined function, where she had removed one of the input parameters.

  • mssqltips.com
  • Aaron Bertrand

Sometimes I see weird issues with SQL Servers, and it helps me in understanding how the software works. In this blog, I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?

  • blog.sqlauthority.com

Today we announce the availability of Oracle Database 18c XE for Linux under the Oracle Free Use Terms and Conditions license. This new license is part of the XE RPM installer file and will be installed alongside Oracle Database 18c XE.

  • blogs.oracle.com
  • Gerald Venzl

We’re starting to see some influencers and larger organizations scale back from an “all in” and “by the book” stance on microservices and advocate for a more sensible and logical approach in 2020. There’s nothing wrong with the microservice pattern when used appropriately.

  • blogs.oracle.com

Legacy platforms often cannot meet real-time demands needed for innovation: slower response times cost the business and its customers which leads to bad user experiences.

  • db-engines.com
  • Srini Srinivasan

For many people, index tuning means occasionally adding an index when there’s a report about a slow query. Those indexes might come from a query plan, or from the missing index DMVs, where SQL Server stores every complaint the optimizer files when it thinks an index might make a query better.

  • erikdarlingdata.com
  • Erik Darling

We are excited to announce that YugabyteDB 2.1.2 is GA! You can read the official release notes here. This release shipped with over 30 new enhancements and fixes.

  • blog.yugabyte.com
  • Jimmy Guerrero

In this article, see a practical guide to data obfuscation, data governance for the cloud, the cost of flexibility, and more.

  • dzone.com
  • Lars George

In my last post, I talked about some of the reasons why it makes sense to take advantage of the power of our RDBMS to handle our data instead of manually implementing solutions in our application code.

  • blogs.oracle.com

When it comes to migrating applications to Azure, there are a number of paths available. But if you’re migrating on-premises apps or running applications that require OS-level access, depending on the choices you make, you may be looking at a major rewrite.

  • sqlservercentral.com
  • Contributors

We’re happy to announce the beta availability of our new government region, AWS GovCloud (US East), for the Elasticsearch Service on Elastic Cloud.

  • elastic.co
  • Anurag Gupta

Well, it turns out that toilet paper doesn’t cure the coronavirus, so during the quarantines, I’m giving away free training. Yesterday, I kicked off the Fundamentals of Query Tuning class with the first module, building a query plan.

  • brentozar.com
  • Brent Ozar

A task that I've done many times in my career in databases is to load data into a database as a first step in some benchmark. To do it efficiently you want to use multiple threads.

  • openlife.cc
  • hingo

There are different reasons for adding a load balancer between your application and your database.

  • severalnines.com
  • Sebastian Insausti

Most software architects and developers know that they need to monitor their systems. What often prevents them from implementing an effective monitoring solution is the plethora of choices they face.

  • logz.io
  • Gedalyah Reback

.NET is great and provides a ton of tools for working with databases and data sources. There are times though that a data source may not be inherently supported. In a case such as MySQL you may not see the MySQL connection options when creating binding sources or data sources for your project.

  • databasejournal.com
  • Hannes Du Preez

Subsequent accesses to the same virtual page may or may not require operating system involvement, depending on the following: If the physical page containing the file data is still in the buffer cache and the page table entry is in the TLB, operating system involvement is NOT necessary, and the data

  • engineering.mongodb.com
  • Builders

This is the third article in a series of learning the CREATE VIEW SQL statement. So far, I’d say that we’re comfortable and familiar with the syntax, and we’ve learned how to create and modify views.

  • sqlshack.com
  • Bojan Petrovic

In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.

  • sqlshack.com
  • Hadi Fadlallah

You will be hearing a lot from me and others about the product end of life (EOL) of MySQL version 5.6 which will be February 2021. While MySQL 8.0 is a vast leap forward over previous versions and MySQL 5.7 is fantastic, there are a lot of software still running and still dependent on MySQL 5.6.

  • elephantdolphin.blogspot.com
  • Dave Stokes

In this article, we perform a couple of experiments on different instances in the cloud to show how to properly set up up multiple "Analytics Disk Paths." Typical ad-hoc analytical queries have to process much more data than can fit in memory. Consequently, those queries tend to be I/O bound.

  • dzone.com
  • Murtadha Al Hubail

In this article, explore the MariaDB Server query cache. The MariaDB Server Query Cache The Server Query Cache (QC) is a well-known feature of MariaDB Server-it caches SQL statements and the corresponding result sets.

  • dzone.com
  • Anders Karlsson

How to Audit only DML Actions ? Step by step to Enable Fine Grained MySQL Auditing for Insert/Update/Delete Queries for all Users. B...

  • chandanmysqltricks.blogspot.com

Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals, our conference plans, maybe even how we wanted to do our first user group presentations or SQL Saturday presentations.

  • brentozar.com
  • Brent Ozar

MySQL & Dockers... are not new concepts, people have been moving to Dockers for some time now. For someone who is just moving to this for development, it can have a few hurdles.

  • anothermysqldba.blogspot.com
  • Keith Larson

I'll get this out of the way first: I'm a Mac guy. If you're not using a Mac, probably the end of this post is the only thing of interest.

  • sqlblog.org

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