Skip to content
Register for a Course here: Register
Techfura

Techfura

All about Programming and Data Engineering

Month: September 2020

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

September 26, 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, SSRS

Configuration of the Report Server URL in SSRS 2019

September 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, SSRS

SQL Server – Indexes

September 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, TSQL

Including File Properties and Metadata in a U-SQL Script

September 18, 2020March 2, 2022 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, USQL

SQL Server: STUFF() Function

September 18, 2020 Kenneth_pro_

In SQL Server (Transact-SQL), the STUFF() function deletes a sequence of characters from a source string and then inserts another sequence of characters into the source string, starting at a specified position. Syntax The syntax for the STUFF function in Read More …

Built-in Functions, Programming, TSQLMSSQL, SQL SERVER, STUFF(), Stuff() Function, TSQL

Delete Duplicates From a Table in SQL Server

September 17, 2020 Kenneth_pro_

You can use the following ways to delete duplicate rows from a table in SQL Server. Let’s create a sample Employee table and insert a few records in it. CREATE TABLE Employee([ID] INT identity(1,1),[FirstName] Varchar(100),[LastName] Varchar(100),[Country] Varchar(100),)GOInsert into Employee ([FirstName],[LastName],[Country] Read More …

Mostly Asked Questions, TSQLCTE, MSSQL, SLQ Delete Duplicates, SQL, TSQL

U-SQL Table

September 16, 2020 Kenneth_pro_

Azure Data Lake Analytics (U-SQL) originates from the world of Big Data, in which data is processed in a scale-out manner by using multiple nodes. These nodes can access the data in several formats, from flat files to U-SQL tables. Read More …

ADLA, Programming, USQLADLA, Azure, Big Data, U-SQL, U-SQL Table, USQL

SSISDBBackup.bak could not be accessed

September 16, 2020 Kenneth_pro_

If you try and create an Integration Services Catalog and you receive the error SSISDBBackup.bak could not be accessed, it could be because you do not have Integration Services installed on your SQL Server instance. Below I am going to Read More …

Errors, TSQLMSSQL, SQL SERVER, SSIS, SSIS Catalog error, SSISDB, TSQL

Function to Get Full Name

September 15, 2020 Kenneth_pro_
Stored Procedure and UDF, TSQL

SQL Stored Procedure to Generate a Random Password

September 15, 2020March 1, 2022 Kenneth_pro_
Stored Procedure and UDF, TSQLFunctions, MSSQL, Procedures, SQL, Stored procedures, TSQL, UDF

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