DBplatz
23rd Jan 2021

Transaction Considerations for MongoDB in Production

A MongoDB transaction is a group of throughput operations (reads and writes ) that require all these operations to succeed or fail together. For instance consider transferring money from account A to account B.

severalnines.com
23rd Jan 2021

Data Structures for NoSQL Applications in Couchbase 7.0

NoSQL database systems are great for supporting scalable applications. Depending on the application need, these systems use a variety of ways to optimize data storage. However, getting data back out effectively to client applications is even more important.

blog.couchbase.com
23rd Jan 2021

Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”

This blog post relates to where you might be doing scale operations of your app services or VMs in Azure and get the following error after doing quite a few scale up and down operations. Failed to update configuration for 'Api'.

hybriddbablog.com
23rd Jan 2021

The MySQL X DevApi: Working with NULL Values

It may sound like a trivial question, but the answer is not all that simple, so instead of just replying directly to the comment, I think it is worth covering the subject of NULL values in the X DevAPI in a separate post. In short there are two ways to work with “not a value” in the X DevAPI.

mysql.wisborg.dk
23rd Jan 2021

A low-code bitcoin ticker built with QuestDB and n8n.io

We've had many predictions of the emerging trends of 2020. Three that ended up ringing very true were the popularity of low-code platforms, the rise of time-series databases, and a digital currency boom.

questdb.io
22nd Jan 2021

Configuring an audit log to capture database activities for Amazon RDS for MySQL and Amazon Aurora with MySQL compatibility

Organizations improve security and tracing postures by going through database audits to check that they’re following and provisioning well-architected frameworks.

aws.amazon.com
22nd Jan 2021

SQL on-demand pools in Azure Synapse Analytics

This article will show how to work with SQL on-demand pools and understand the fundamentals of working with this pool in Azure Synapse Analytics.

sqlshack.com
22nd Jan 2021

Working with Database Projects

In this article, I am going to talk about developing and deploying a database project, also known as a data-tier application using Visual Studio.

sqlshack.com
22nd Jan 2021

Study Guide To Crack The Microsoft Certifictaion Exam DA-100: Analyzing Data with Microsoft Power BI

The data Analyst job is buzzing around in the IT industry and Data Science has become one of the fastest-growing areas that everyone wants to associate with.

blog.cloudthat.com
22nd Jan 2021

Automating SQL Compare Snapshots using SQL Snapper

If you have SQL Compare, then the SQL Snapper utility is very valuable 'extra' for certain team activities, because it can be freely distributed. It means that any developer can create a SQL Compare snapshot from databases that are on their local workstation and store them on the network.

red-gate.com
22nd Jan 2021

Batch Processing Massive Data Quicker With TiSpark

A senior solution architect at PingCAP explains why TiSpark (TiDB + Apache Spark) is better than traditional batch processing, the benefits of TiSpark, and how it works. TiSpark is an Apache Spark plugin that works with the TiDB platform to answer complex online analytical processing (OLAP) queries.

dzone.com
21st Jan 2021

How long does it take to redeploy an ODA X8-2M?

One of the advantage of Oracle Database Appliance is its fast deployment. Most often, the initial setup of a lite ODA (with a reimaging) only takes half a day, from unboxing until a first test database is available. Trust me, it’s hard to do better.

blog.dbi-services.com
21st Jan 2021

Now More People Can Optimize PostgreSQL Queries

I am excited to tell you about a forthcoming book, entitled “Postgres Query Optimization: The Ultimate Guide to Building Efficient Queries,” being published by Apress and will be available in the spring of 2021.

enterprisedb.com
21st Jan 2021

CockroachDB vs. Scylla Benchmark

The database space has always been a complicated field that introduced many options and tradeoffs. Two particular classes of databases, NoSQL and NewSQL, have been most recently pitted against each other in the industry. However, both terms were coined long ago.

scylladb.com
21st Jan 2021

Query Hints You Can Use to Avoid Blocking

No, not NOLOCK. You get the wrong query results, even when your query results aren’t supposed to be changing. I’m talking about when you need to do writes, but you want your query to get along with others in high concurrency environments, without creating a blocking firestorm.

brentozar.com
21st Jan 2021

Deploy Analytical Data Platform on AWS in One Day

Every business is focused on a rapid time to market and return on investment. It’s no longer enough to implement a data lake, businesses require a data platform that can provide immediately actionable insights.

blog.griddynamics.com
21st Jan 2021

Understanding DynamoDB Condition Expressions

If you’re working with DynamoDB, you’re likely to rely on Condition Expressions when manipulating items in your table. Condition Expressions can ensure you don’t overwrite existing users, allow bank account balances to drop below $0, or give Admin access to every user in your application.

alexdebrie.com
21st Jan 2021

Low Value in range_optimizer_max_mem_size Might Cause Full Table Scan

Although how range_optimizer_max_mem_size operates is explained in the official doc, it’s not a well-known variable and surely not a variable you need to modify under most circumstances. But from time to time we get some performance tickets related to this.

percona.com
21st Jan 2021

Connect to SQL Server

SQL Server has many different components that you need to connect to so you can manage different aspects of the SQL Server environment.

mssqltips.com
21st Jan 2021

Upgrading from Amazon RDS for MySQL version 5.5

Amazon RDS for MySQL 5.5 major version is reaching end of life, and it’s recommended to upgrade to newer supported major versions. Amazon Relational Database Service (Amazon RDS) provides newer versions of databases so you can keep your DB instances up to date.

aws.amazon.com
21st Jan 2021

Database Performance Archaeology

One of the worse things that can happen when upgrading to a newer database version is discovering that the performance is not as good as before.

tiagomlalves.medium.com
21st Jan 2021

"How To" with Dave Page Episode 3: Install and Run pgAdmin Using the Python Package

Dave Page is Vice President and Chief Architect, Database Infrastructure, currently working in the CTO team on research and development, best practices with Postgres, and providing high-level guidance and support for key customers.

enterprisedb.com
21st Jan 2021

MySQL Invisible Column: part II

This article is the second part of the series related to MySQL Invisible Column started here. This post covers why Invisible Column is important for InnoDB Storage Engine.

lefred.be
21st Jan 2021

Meet Raspberry Silicon: Raspberry Pi Pico now on sale at $4

Today, we’re launching our first microcontroller-class product: Raspberry Pi Pico. Priced at just $4, it is built on RP2040, a brand-new chip developed right here at Raspberry Pi.

raspberrypi.org
21st Jan 2021

New Year Goodies -- Oracle JDBC 21.1.0.0 on Maven Central

In my previous post, I referred to exciting new features in the upcoming DB21c JDBC drivers and the availability of the bits by early January. Here we are, past mid-January, so what are those so-called exciting things?

blogs.oracle.com
21st Jan 2021

Manipulating Geo Coordinate Data Using DAO Design Pattern in Jedis

Learn how to manipulate geo coordinate data using the DAO pattern without knowing the low-level API through the Jedis Java client application. In this article, we are going to learn how to add geocoordinate data and retrieve it using the DAO design pattern.

dzone.com
21st Jan 2021

What is N in nvarchar? – Interview Question of the Week #301

Question: What is N in nvarchar? Answer: n in nvarchar or nchar stands for world national.

blog.sqlauthority.com
21st Jan 2021

Incident Management in 2021: from Basics to Best Practices

Covering the basics What is incident management? Incident management is the process used by developer and IT operations teams to respond to system failures (incidents) and restore normal service operation as quickly as possible.

dev.to
First 1 2 3 Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2020 © DBplatz