Skip to content
Register for a course

Techfura

All about Programming and Data Engineering

  • Blog
  • Register

Part 3 – Encrypting an existing database with TDE

April 7, 2021 Kennedy

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 Kennedy

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 Kennedy

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, 2021May 27, 2024 Kennedy

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

Performance Optimization Techniques on Azure Data Lake

March 5, 2021 Kennedy

The following article depicts performance optimization on Azure Data Lake.It is Assumed that people reading this have a general idea on ADL, U-SQL and general querying.Before we move on let’s understand key terms in determining a query performance: Analytic UnitStages in a jobJob Read More …

ADLA, USQL

Dynamic Search Conditions in T‑SQL

March 3, 2021 Kennedy

Introduction It is very common in information systems to have functions where the users are able to search the data by selecting freely among many possible search fields. When you implement such a function with SQL Server there are two Read More …

Mostly Asked Questions, TSQL

Using Azure Data Lake to copy data from CSV file to a SQL database

January 29, 2021 Kennedy

Great, but what is Azure Data Lake? Azure Data Lake includes all the capabilities required to make it easy for developers, data scientists, and analysts to store data of any size, shape, and speed, and do all types of processing and analytics Read More …

ADF, Azure

SQL MERGE statement

January 28, 2021March 2, 2022 Kennedy

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

Split huge CSV files – Open in Excel

January 28, 2021 Kennedy

One of Microsoft Excel’s shortcomings is the limited size of a spreadsheet. Excel has a spreadsheet row limit of 1,048,576. If you need to open in Excel, make your Excel file smaller or split a large CSV file. To get Read More …

Excel, Split csv Files

A Stored Procedure to generate a random token

December 30, 2020 Kennedy

You may have encountered a scenario where you want to generate a random token for identity verification purposes. In this article I tried to include a stored procedure in which you can easily generate a random token to be sent Read More …

Stored Procedure and UDF, TSQL

Posts navigation

Older posts
Newer posts

Categories

  • AI/ML (1)
    • RAG (1)
  • Apache Kafka (1)
    • Apache Kafka 101 (1)
  • Azure (23)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • Data Engineering (2)
    • DE Roadmap (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Linux (2)
    • Basic Linux Commands (1)
    • Shell Script (1)
  • MSSQL (4)
    • CDC (1)
    • TDE (3)
  • Programming (42)
    • C# (5)
    • C++ (4)
    • Fundamentals (1)
    • HTML/CSS (3)
    • JavaScript (6)
    • Python (1)
    • Spark (4)
      • Intro to Apache Spark (1)
      • PySpark (1)
      • Spark DataFrame Cheat Sheet (1)
      • SparkSQL (1)
    • TSQL (16)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (4)
  • Reporting (2)
    • SSRS (2)

Archives

  • May 2025 (1)
  • February 2025 (1)
  • September 2024 (2)
  • May 2024 (7)
  • January 2024 (1)
  • 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

  • Cloud Platforms Comparison Cheat Sheet
  • SQL – CRUD and CT
  • Building a Real-Time Data Pipeline with Python, Docker, Airflow, Spark, Kafka, and Cassandra
  • Mastering Personalized Conversations with RAG
  • Top 10 Core Concepts in every Programming Languages

Tags

ADLA Azure Big Data Cheat Sheet CTE Data Data Engineering Dataframe Data Pipeline Dataset Functions Linux MSSQL Procedures PySpark Python RDD Scala SLQ Delete Duplicates Spark 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

  • AI/ML (1)
    • RAG (1)
  • Apache Kafka (1)
    • Apache Kafka 101 (1)
  • Azure (23)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • Data Engineering (2)
    • DE Roadmap (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Linux (2)
    • Basic Linux Commands (1)
    • Shell Script (1)
  • MSSQL (4)
    • CDC (1)
    • TDE (3)
  • Programming (42)
    • C# (5)
    • C++ (4)
    • Fundamentals (1)
    • HTML/CSS (3)
    • JavaScript (6)
    • Python (1)
    • Spark (4)
      • Intro to Apache Spark (1)
      • PySpark (1)
      • Spark DataFrame Cheat Sheet (1)
      • SparkSQL (1)
    • TSQL (16)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (4)
  • Reporting (2)
    • SSRS (2)
© 2024 Techfura. All Rights Reserved
Proudly powered by WordPress | Education Hub by WEN Themes