The 1nf0rmant

SQL Server Management Studio  shortcuts At the following video you can see some shortcuts for writing faster and more efficient SQL queries, at Synapse or SQL Database. Environment  SQL Server  2019 Developer Edition. SQL Server Management Studio v18.10 You can download the client from the following 🔗    SQL Server Management Studio   🠟 .

 Presentat ion of  Azure Analytics  Components In the following video you can see a "5-Minute" presentation about Azure platform and a few words about analytics components of Azure platfrom such as: Azure Data Factory Azure Analysis Service Azure Data Lake Analytics Power BI

  Week By Week Report Analysis If you are a Data Warehouse Analyst, it might be a request from your manager, director or CEO to do a report to see the growth of a KPI during the time. How KPI “X” evolve during Years, Months, Dates , etc. The tricky part comes when you must do a week-by-week analysis. Let’s see below the steps that must be performed by Data Warehouse Analyst. Environment  SQL Server  2019 Developer Edition. SQL Server Management Studio v18.10 Database: DWREAD Schema: FORMULA_STAG Table:  RACES The table is from Kuggle   Formula 1 World Championship (1950 - 2020)   👈 Steps We go to MS SQL Database and execute the following statement: SELECT @@DATEFIRST; This statement shows us that the first day of the week is Sunday (default).  So, we understand that the week is [Sunday, Monday, …, Saturday].  All the dates between Sunday and Saturday is grouped into one week. Our table has a date column: date If we want to identify in which ...