Skip to content
Register for a Course here: Register
Techfura

Techfura

All about Programming and Data Engineering

Category: TSQL

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

SQL MERGE statement

January 28, 2021March 2, 2022 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, TSQL

A Stored Procedure to generate a random token

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

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

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

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

Part 2: How to quickly search for SQL database data and objects in SSMS

May 26, 2020 Kenneth_pro_

Frequently, developers and DBAs need to search databases for objects or data. If a database function that contains a specific table column or a variable name, or for a table that contains specific data is searched, the simple solution for Read More …

Mostly Asked Questions, Programming, TSQL

Posts navigation

Older posts

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