Skip to content
Register for a course

Techfura

All about Programming and Data Engineering

  • Blog
  • Register

SQL MERGE statement

January 28, 2021March 2, 2022 Kenneth_pro_

With data processing, in performing ETL workloads to a data warehouse, some of the activities in ETL can be achieved using the MERGE statement in SQL. The MERGE statement in SQL is a special type of query in SQL Server Read More …

Merge Statement, TSQL

Introduction To Apache Kafka – Part 1

June 10, 2023June 10, 2023 Kennedy Abdela

What is Apache Kafka? Kafka is a Publish-Subscribe based messaging system that is exchanging data between processes, applications, and servers. Applications may connect to this system and transfer a message onto the Topic(we will see in a moment what topic is) Read More …

Apache Kafka, Apache Kafka 101

Change Data Capture — CDC

June 10, 2023June 10, 2023 techfura

Change Data Capture (CDC) is a method of identifying and capturing changes made to a database. It captures data changes and enables businesses to keep track of all modifications made to their data, including updates, inserts, and deletes. CDC is Read More …

CDC, MSSQL

Shell Script to auto download file from sftp server

March 1, 2022March 1, 2022 techfura

This is a shell scrip to download a file from an sftp server with password. File names might be with datetime stamp like FileName_2022030125600.CSV. The script will get to the sftp site, download the files with current datetime stamp to Read More …

Linux, Shell ScriptLinux

Part 5: Switch case in C++

April 7, 2021 Kenneth_pro_

Switch case statements are a substitute for long if statements that compare a variable to several “integral” values (“integral” values are simply values that can be expressed as an integer, such as the value of a char). The basic format Read More …

Programming

Part 4: Functions in C++

April 7, 2021June 23, 2021 Kenneth_pro_

Now that you should have learned about variables, loops, and conditional statements it is time to learn about functions. You should have an idea of their uses as we have already used them and defined one in the guise of Read More …

C++, Programming

Part 3: Loops in C++

April 7, 2021 Kenneth_pro_

Loops are used to repeat a block of code. Being able to have your program repeatedly execute a block of code is one of the most basic but useful tasks in programming — many programs or websites that produce extremely Read More …

C++, Programming

Part 2: If statements in C++

April 7, 2021 Kenneth_pro_

The ability to control the flow of your program, letting it make decisions on what code to execute, is valuable to the programmer. The if statement allows you to control if a program enters a section of code or not Read More …

C++, Programming

Part 1: Introduction to the C++ Language

April 7, 2021 Kenneth_pro_

A C++ program is a collection of commands, which tell the computer to do “something”. This collection of commands is usually called C++ source code, source code or just code. Commands are either “functions” or “keywords”. Keywords are a basic building block of the Read More …

C++, Programming

Part 3 – Encrypting an existing database with TDE

April 7, 2021 Kenneth_pro_

The process of setting up TDE is the same whether you’ve just set up a new database, or whether you’re working with a live database. Once you turn encryption on SQL Server will begin the process of encrypting any data Read More …

MSSQL, TDE

Part 2 – Setting up Transparent Data Encryption (TDE)

April 7, 2021 Kenneth_pro_

You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to an existing database. In the latter case, once TDE has been enabled it will set to work encrypting your existing Read More …

MSSQL, TDE

Posts navigation

Older posts

Categories

  • Apache Kafka (1)
    • Apache Kafka 101 (1)
  • Azure (22)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Linux (1)
    • Shell Script (1)
  • MSSQL (4)
    • CDC (1)
    • TDE (3)
  • Programming (35)
    • C# (5)
    • C++ (4)
    • HTML/CSS (3)
    • JavaScript (6)
    • TSQL (15)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (3)
  • Reporting (2)
    • SSRS (2)

Archives

  • June 2023 (2)
  • March 2022 (1)
  • April 2021 (8)
  • March 2021 (3)
  • January 2021 (3)
  • December 2020 (2)
  • October 2020 (1)
  • September 2020 (10)
  • July 2020 (1)
  • June 2020 (6)
  • May 2020 (30)
  • April 2020 (1)
  • April 2019 (1)

Recent Posts

  • Introduction To Apache Kafka – Part 1
  • Change Data Capture — CDC
  • Shell Script to auto download file from sftp server
  • Part 5: Switch case in C++
  • Part 4: Functions in C++

Tags

ADLA Azure Big Data CTE Functions Linux MSSQL Procedures SLQ Delete Duplicates SQL SQL SERVER SSIS SSIS Catalog error SSISDB Stored procedures STUFF() Stuff() Function TSQL U-SQL U-SQL Table UDF USQL U_SQL File Metadata

Traffic Count

traffic counter

Categories

  • Apache Kafka (1)
    • Apache Kafka 101 (1)
  • Azure (22)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Linux (1)
    • Shell Script (1)
  • MSSQL (4)
    • CDC (1)
    • TDE (3)
  • Programming (35)
    • C# (5)
    • C++ (4)
    • HTML/CSS (3)
    • JavaScript (6)
    • TSQL (15)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (3)
  • Reporting (2)
    • SSRS (2)
© 2023 Techfura. All Rights Reserved