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 …
Author: Kenneth_pro_
Report Server URL error: Unable to validate the integrity of encrypted data
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 …
Configuration of the Report Server URL in SSRS 2019
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 …
SQL Server – Indexes
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 …
Including File Properties and Metadata in a U-SQL Script
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 …
SQL Server: STUFF() Function
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 …
Delete Duplicates From a Table in SQL Server
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 …
U-SQL Table
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 …
SSISDBBackup.bak could not be accessed
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 …