Dynamic data masking on MSSQL

How to dynamic data masking on Sql Server While working on an external database I noticed something interesting, I was looking date in a transaction table, all of its values where ‘1900-01-01’. I start wondering what was happening there, until I realized that I didn’t … “Dynamic data masking on MSSQL”

Read More

How to split a column with delimited string into multiple columns in Sql Server

Long time ago I found that data might come in many different formats, mostly related with the data source, Cellphone Numbers, User Names, addresses are some examples of data that commonly comes in delimited format. You may want to split this delimited string columns and divide … “How to split a column with delimited string into multiple columns in Sql Server”

Read More

How to round in Sql Server

How to round a number in Sql Server If you want to start learning how Sql server works, Rounding numbers in Sql is a good startpoint. 1. Rounding in Math Rounding in Sql is mainly based on rounding math concept. This consist in going to … “How to round in Sql Server”

Read More

Sql Server Union and Union all

Sql Server Union and Union all Union is a very useful Sql command that enables you to combine the values of two or more tables. One prerequisite for using union is that those tables must contain the same amount of columns and data types must … “Sql Server Union and Union all”

Read More

How to delete duplicate rows in Sql Server

How to delete duplicate rows in Sql Server As database administrator, analyst or data engineer is typical to find duplicate rows in our datasets. This can happen for multiple reasons, sometimes is because someone apply wrongly a join or even because software connected to database … “How to delete duplicate rows in Sql Server”

Read More