Data Tips and Solutions
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 Split a column with delimited string into multiple columns There are many reasons why you would like to split a delimited column into multiple columns, one of them is because on certain systems you will find data storage on a coma-delimited format or other kind of … “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. Open WordPad or other text editor like notepad++ as an … “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 17.9 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
Power Bi is a powerful visualization tool, made from a conjunction of Excel Power Tools (These tools can be found as add-ons for Excel). There are different Power Bi versions with different prices and different objectives, Desktop editions go from Power Bi Desktop (Free) to … “Power BI desktop download and Install”
Read More