Data Tips and Solutions
Common table expressions (CTEs) are similar to subqueries; they are defined as objects that are visible only to the statement that defines them. CTE involved two parts The inner query The outher query CTEs have the following structure. You can nest CTEs if you want … “Common Table Expressions (CTE) In Sql Server”
Read More
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 projects. This is a common situations that a data analyst or … “How to Insert into table using Select”
Read More Dynamic data masking 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 have UNMASK database permission. I … “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 If you want to start learning how Sql server works, Rounding numbers in Sql is a good startpoint. Rounding in Math Rounding in Sql is mainly based on rounding math concept. This consist in going to a near value making the rounded value easier but … “How to round in Sql Server”
Read More 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 be consistent. For this example, we … “Sql Server Union and Union all”
Read More As database administrators, analyst or data engineers is typical to find duplicate data in our datasets. This can happen for multiple reasons, sometimes is because someone apply wrongly a join or even because software connected to database send two or more times same content to … “How to delete duplicate rows in Sql Server”
Read More 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 some SQL Server 2016 characteristics applied to a … “Sql Server 2017 restore WideWorldImporters Database”
Read More For implementing Dark theme in your SSMS just follow this change guide and you will have it ready to work in a few minutes. After downloading and installing Sql Server Management Studio follow this steps. Ways to Enabling dark mode in SSMS Method 1. Using text … “How to Enable Dark Theme Sql Server Management Studio – SSMS Dark Theme”
Read More Sql Server database is divided in two, one physical part composed of database and log files and a logical part divided in Database Structures, tables, etc. Typically the physical database files can be found on a directory into the computer where Sql Server was installed. … “Sql Server Management Studio download and Install”
Read More