Skip to content
Register for a Course here: Register
Techfura

Techfura

All about Programming and Data Engineering

Month: March 2021

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

Performance Optimization Techniques on Azure Data Lake

March 5, 2021 Kenneth_pro_

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 Kenneth_pro_

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

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
© 2022 Techfura. All Rights Reserved