Data Tips and Solutions
How to insert into a table using Select in Sql Server While getting ready for Sql Server test 70-761 I was wondering why do I need to insert values from one table in another. That question got answer over the last 3 years while working on different SQL data analysis … “How to Insert into table using Select”
Read More
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 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. … “Sql Server – Split column with delimited string into multiple columns”
Read More
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 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 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
How to restore WideWorldImporters database in Sql Server AdventureWorks was an old demo database that was used since Sql Server 2008 until Microsoft team decided to create a new one, this database is available since Sql Server 2016. WideworldImporters is a database made for showing … “Sql Server restore WideWorldImporters Database”
Read More
Enabling Dark theme in SSMS Dark theme is not enable by default in Sql Server Management Studio (SSMS) as it is not completely functional in SSMS. For checking it go to Tools > Options > Environment > General. As you can see there is no … “How to Enable Dark Theme Sql Server Management Studio – SSMS Dark Theme”
Read More
How to Install and download Sql Server Management Studio Sql Server database divides in two parts. A physical part composed of database and log files A logical part divided in Database Structures, tables, etc. The physical database files is located into a directory in the … “Sql Server Management Studio download and Install”
Read More
Sql Server is a great tool for data analysis, especially when talking about large amounts of data. There are multiple versions of Sql Server, I suggest you to download the newer stable edition, In this case we are talking about Sql Server 2017. There are … “Sql Server 2017 Editions Overview”
Read More