© 2022 Hashnode
We did the initial project setup on containers in the previous "Demystifying Docker" series article. In this one, we will cover the database with persistence (examples with MS SQL Server, PostgreSQL, …
In my previous blog, I briefly introduced apache airflow and mentioned how the tool can be used to orchestrate tasks however I did not set it up locally. This was a deliberate attempt to discuss the t…
Write a SQL query to concatenate multiple rows into a single string? USE TestDB; GO DROP TABLE IF EXISTS dbo.product_category; GO CREATE TABLE dbo.product_category ( product_category_id INT NOT…
Apache airflow is a tool that is used to schedule and monitor workflows. It's one of the several tools I planned to learn on my journey to becoming a full data professional. The first resource I stumb…
To find out the list of replicated transaction, query the MSrepl_transactions table in distribution database. Copy the sequence number of the transaction (i.e., xact_seqno ) which entered the distribution database last. SELECT top 1 entry…
PIVOT and UNPIVOT are relational operators for converting table expression into another. If we want to turn the unique row values of a column into multiple columns we use the PIVOT operator. And when we want to converge multiple columns to …
Preamble Recently, I had to assist with the import of a Microsoft SQL (MSSQL) database to a new Virtual Machine (VM). The database backup was stored locally on the source VM and then copied to a netwo…
Replication Replication Monitor SELECT publisher, publisher_db, publication_id, CASE publication_type WHEN 0 then '0 - Transactional publication' WHEN 1 then '1 - Snapshot publication' WHEN 2 then '2 - Merge publication' END AS …
Sets Continued In Part One we talk about concept of sets, operations on sets, started with the first one which is intersection. Now in This part we'll complete our journey in sets by talking about …
How to generate a random string of 10 character? There are many ways to generate a random string. This one is a simple way to do it. SELECT RIGHT(CAST(NEWID() AS VARCHAR(255)),10) How to generate a random number? Generate a random number fr…