Sample Questions for Microsoft Azure Fundamentals AZ-900 Certification Exam- Part 2

Let’s get visual: GitLab 13.8 introduces pipeline editor, simplifies rebasing and issue interaction

GitLab 13.8 is now available and treats users to a pipeline editor, additional validation helpers, and the capability to comment on issues via email, reducing the need to switch context.

devclass.com

A preliminary exploration of dynamic hashing in PostgreSQL

In computing, a hash table (hash map) is a data structure that implements an associative array abstract data type, a structure that can map keys to values.

highgo.ca

Video : Long Identifiers in Oracle Database 12.2 Onward

In today’s video we’ll quickly demonstrate long identifiers, introduced in Oracle database 12.2. The video is based on this article.

oracle-base.com

OpenStack on ARM64 – Kolla container images

This is the beginning of a short series detailing how to deploy OpenStack on ARM64, using Docker containers with Kolla and Kolla-ansible.

cloudbase.it

Migrating your on-premises SQL databases to AWS RDS SQL Server using AWS DMS

There are multiple ways to deploy the databases in the AWS RDS SQL Server. Suppose you want to migrate your on-premises SQL Server database to AWS managed relational database service and you have a critical application and require minimal (almost zero) downtime.

sqlshack.com

How to Use Redis in Infrastructure Microservices

Back in 2019, I wrote about how to create an event store in Redis. I explained that Redis Streams are a good fit for an event store, because they let you store events in an immutable append-only mechanism like a transaction log.

redislabs.com

Home Lab Deployment: OpenShift/OKD 4.4.x on RHVM/Ovirt 4.3

If you’re interested in building your own home lab server, read on to learn how to get OpenShift 4.4x running on RHVM 4.3. The following developer notes outline and detail the steps necessary to get OpenShift 4.4.x (or OKD 4.4.x) running on RHVM 4.3 (or Ovirt 4.3).

dzone.com

24th Jan 2021

Reasons why SELECT * is bad for SQL performance

Here’s a list of reasons why SELECT * is bad for SQL performance, assuming that your application doesn’t actually need all the columns.

tanelpoder.com

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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