Day 3/100

Deltalake - [ Intro and Quick Start ]
key features -

ACID transactions
schema enforcement on writes
Unification of batch and streaming - A table in Delta Lake is a batch table as well as a streaming source and sink.
Time travel
Supports merge, upd...

Read: https://rawdatareaders.hashnode.dev/day-3100

Warehousing with Google’s Big Query

Data, in the modern world, is decentralized and is being generated and collected at a record pace. To ensure that this data is collected and processed in a manner that enables businesses and organizations to achieve their business goals, specialized ...

Read: https://anujsyal.com/warehousing-with-googles-big-query

Миграция из Office 365: задачи, способы и сроки

После мартовского заявления Microsoft о приостановке новых продаж в России клиенты задумались о рисках использования облачных продуктов корпорации. Пока функциональность закупленных лицензий сохраняется. Но российские компании опасаются, что санкции могут усилиться.

В статье разберем, какими способами мы предлагаем нашим клиентам минимизировать риски использования Office 365. Сейчас этот офисный пакет входит в состав подписки Microsoft 365 и включает Word, Excel, PowerPoint, Outlook/Exchange, OneDrive, Teams и еще несколько приложений.


Читать: https://habr.com/ru/post/657203/

Resources to Learn SQL from Scratch

SELECT howdy_greeting
FROM introductions;
1 row selected
Howdy! I've taken a tiny hiatus blogging due to my classes this semester - but, I have returned! 🤩
And I have returned with...
drumroll
... a golden list of resources to use if you're learnin...

Read: https://laylacodes.hashnode.dev/resources-to-learn-sql-from-scratch

MySQL waits and CPU

Read: http://datavirtualizer.com/?p=6395

Dashboard Embedding Comes to Charts

Read: https://www.mongodb.com/blog/post/dashboard-embedding-comes-charts

Using TMDB - The Movie Database

It's my Learning Time. I Learned about creating movie websites like Netflix and others. (PS. I Don't Provide Movie Files - I am Against Piracy 😁).
On that Website Developing time, I need movie details. not One, not Two, not something like 100, but I...

Read: https://sahal.hashnode.dev/using-tmdb-the-movie-database

MySQL -> what to do with NESTING_EVENT_ID

Read: http://datavirtualizer.com/?p=6425

Debugging SQL in Python

Read: https://blog.koehntopp.info/2022/03/24/debugging-sql-in-python.html

Truncated incorrect DOUBLE value

Read: https://blog.koehntopp.info/2022/03/24/truncated-incorrect-double-value.html

Behind the scenes: How we built Rewind

Read: https://planetscale.com/blog/behind-the-scenes-how-we-built-rewind

It’s fine, Rewind: Revert a migration without losing data

Read: https://planetscale.com/blog/its-fine-rewind-revert-a-migration-without-losing-data

Oracle delivers multicloud success and offers an on-demand webcast series

Oracle delivers multicloud success

Read: https://blogs.oracle.com/database/post/oracle-delivers-multicloud-success-and-offers-an-on-demand-webcast-series-to-learn-more-v2

Introducing MySQL Shell for VS Code

Read: https://blogs.oracle.com/mysql/post/introducing-mysql-shell-for-vs-code

Installing Docker And SQL Server 2017 On LinuxVM In Azure

In today’s article, I will talk about Installing Docker And SQL Server 2017 On LinuxVM In Azure. After the announcement that SQL Server 2017 is running on Docker, I was working on docker and today I will tell you “Installing Docker and SQL Server 2017 on LinuxVM in Azure”. I have a LinuxVM on Microsoft …

Read: Installing Docker And SQL Server 2017 On LinuxVM In Azure.

PostgreSQL CRUD operations with C# and Dapper

In a previous article, we've seen how to perform simple CRUD operations on a Postgres database by using Npgsql, a library that allows you to write and perform queries to be executed specifically on a PostgreSQL database.
In this article, we will take...

Read: https://code4it.hashnode.dev/postgresql-crud-operations-with-c-and-dapper

Okta – Percona’s statement

Read: https://www.percona.com/blog/?p=80442

Day 5/100

Delta Lake [Part 3] -
Delta table Streaming
Delta Lake is deeply integrated with Spark Structured Streaming through readStream and writeStream along with following features,

Coalesce small files
Maintains Exactly-once processing
Discovering new file...

Read: https://rawdatareaders.hashnode.dev/day-5100

MariaDB Java Connector 3.0.4 now available

Read: https://mariadb.com/?p=30703

How to Apply patch on DBCS with Data guard

patching

Read: https://blogs.oracle.com/database/post/how-to-apply-patch-on-dbcs-with-data-guard

Материализованные представления и ReplacingMergeTree в ClickHouse

В этой статье будут описаны подводные камни, на которые я натыкался при использовании одновременно материализованных представлений и движка ReplacingMergeTreeв ClickHouse (далее CH). Для опытных пользователей CH эта информация возможно будет уже не новой, но надеюсь, что смогу сэкономить много времени тем, кто недавно начал свое знакомство или только готовится начать.

Это первая часть, в которой опишу основные термины: что такое материализованные представления и ReplacingMergeTree, как работают и какие есть особенности.


Читать: https://habr.com/ru/post/657579/