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

Sql Server restore WideWorldImporters Database

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

How to Enable Dark Theme Sql Server Management Studio – SSMS Dark Theme

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

Sql Server Management Studio download and Install

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 2017 Editions Overview

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 desktop download and Install

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