How to zip files in azure data factory

In this tutorial, I am going to zip files in azure data factory. For going through the tutorial, we are going to create some files and move them into a blob storage. For completing the task, please follow the next steps. Steps to zip files … “How to zip files in azure data factory”

Read More

How to Update top N records in Sql Server

A typical sql server update consist in updating a set of data filtered by the where clause but sometimes we only need to update the top N records without affecting the others. Dataset We are going to use ‘Sales.Customers’ table from WideWorldImporters database. Next, we … “How to Update top N records in Sql Server”

Read More

How to alter a column from null to not null in sql server

Changing a column from NULL to NOT NULL consist in making a change on the table by using ALTER TABLE syntax. There are few steps that you have to follow in order to change a column from null to not null. Check the column to … “How to alter a column from null to not null in sql server”

Read More

How to escape square brackets in a like clause in sql server

This is a common issue that you find when you try to look for brackets or other wildcard characters using LIKE sentence in Sql Server. All of these wildcards work on a different way when invoking them into a LIKE sentence, You can check them … “How to escape square brackets in a like clause in sql server”

Read More

How to Insert multiple rows in a single SQL query

The insert statement insert one or more records into a database table. There are multiple ways to insert multiple rows into Sql Server. For example, the most known way consist in inserting records consist in on the following way. We are going to create a … “How to Insert multiple rows in a single SQL query”

Read More