Skip to content
techfura

All about Tech and Data Engineering

  • Home
  • About Us
  • Courses
  • Blog
  • Contact
  • Services

Author: Kenneth_pro_

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

January 29, 2021January 29, 2021 Kenneth_pro_

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, AzureLeave a comment

SQL MERGE statement

January 28, 2021January 29, 2021 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, TSQLLeave a comment

Split huge CSV files – Open in Excel

January 28, 2021January 28, 2021 Kenneth_pro_

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 FilesLeave a comment

A Stored Procedure to generate a random token

December 30, 2020December 30, 2020 Kenneth_pro_

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, TSQLLeave a comment

U-SQL (Intro)

December 15, 2020December 15, 2020 Kenneth_pro_

U-SQL is a language that unifies the benefits of SQL with the expressive power of your own code to process all data at any scale. U-SQL’s scalable distributed query capability enables you to efficiently analyze data in the store and Read More …

ADLA, Azure, USQLLeave a comment

How to Coalesce Excel Data

October 26, 2020October 26, 2020 Kenneth_pro_

The Coalesce function evaluates its arguments in order and returns the first value that isn’t blank or an empty string. Use this function to replace a blank value or empty string with a different value but leave non-blank and non-empty string values unchanged. If all of the Read More …

Excel, Functions1 Comment

Report Server URL error: Unable to validate the integrity of encrypted data

September 26, 2020September 28, 2020 Kenneth_pro_

I came across to this error when I tried to launch the report server url, “The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData)” . I also got the following error when tranna Read More …

Reporting, SSRSLeave a comment

Configuration of the Report Server URL in SSRS 2019

September 26, 2020September 26, 2020 Kenneth_pro_

SSRS offers the possibility to access the Report Server through the URL. This is a very practical functionality for the users. It allows us to access the report server in a user-friendly way. This article will elaborate on how to Read More …

Reporting, SSRSLeave a comment

SQL Server – Indexes

September 18, 2020September 18, 2020 Kenneth_pro_

Why do we need indexing a table? Because without an index the SQL server has to scan the entire table to return the requested data. It is like the index page in a book. You check within the index for the Read More …

Indexes, TSQLLeave a comment

Including File Properties and Metadata in a U-SQL Script

September 18, 2020September 18, 2020 Kenneth_pro_

U-SQL adds support for computed file property columns on EXTRACT statement. Sometimes customers would like to get information about the files that they process, such as the full URI path or information about size, creation or modification dates. Likewise customers would Read More …

ADLA, USQLADLA, U_SQL File Metadata, U-SQL, USQLLeave a comment

Posts navigation

Older posts

Categories

  • Azure (21)
    • ADF (4)
    • ADLA (13)
      • USQL (13)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Programming (29)
    • C# (5)
    • HTML/CSS (3)
    • JavaScript (6)
    • TSQL (14)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (3)
      • Stored Procedure and UDF (3)
  • Reporting (2)
    • SSRS (2)
February 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
« Jan    

Recent Posts

  • Using Azure Data Lake to copy data from CSV file to a SQL database
  • SQL MERGE statement
  • Split huge CSV files – Open in Excel
  • A Stored Procedure to generate a random token
  • U-SQL (Intro)

Traffic Counts

PHP Hits Count
© 2021 Techfura All rights reserved.