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

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

Part 1 – What is Transparent Data Encryption?

April 7, 2021 Kenneth_pro_

Transparent Data Encryption (TDE) was introduced in SQL 2008 as a way of protecting “at rest” data. It continues to be available in all versions of SQL right up until the present, until recently it was only available in the Read More …

MSSQL, TDE

CI/CD with GitHub Database Projects and Azure Pipelines

March 19, 2021 Kenneth_pro_

With the high pace of development, data architects/engineers must be able to keep up with our DevOps counterparts. We also want the many benefits of CI/CD for databases such as fewer errors, stable builds, better release management, and less manual Read More …

Azure DevOps CI/CD Pipeline, DevOps

Posts navigation

Older posts

Categories

  • 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 (3)
    • 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

  • 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

  • Shell Script to auto download file from sftp server
  • Part 5: Switch case in C++
  • Part 4: Functions in C++
  • Part 3: Loops in C++
  • Part 2: If statements 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

  • 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 (3)
    • 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)
© 2022 Techfura. All Rights Reserved
Proudly powered by WordPress | Education Hub by WEN Themes
echo does not require parentheses.