Data Tuesday Videos2022-08-21T15:04:51-05:00

Tuesday – Data Tuesday

Every Tuesday we have videos related today. These will focus on Azure Synapse Analytics and related technologies such as Azure Data Explorer (Kusto) and more…

Continuing the T-SQL journey with OVER and RANK

Continuing our T-SQL journey, Patrick explores the use of the OVER and RANK functions in combination with common table expressions (CTE) in Azure SQL Database and Azure Synapse Analytics. RANK (Transact-SQL) https://learn.microsoft.com/sql/t-sql/functions/rank-transact-sql?view=sql-server-ver16 SELECT - OVER [...]

What the French Toast is a Slowly Changing Dimension???

Want to know more about a slowly changing dimension? What about the different types? Patrick goes through examples and ties in the surrogate key! Sample: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230124%20-%20SCD%20Demo.sql Handling Type II Dimension with the MERGE Statement https://sqldownsouth.blogspot.com/2010/11/handling-type-ii-dimension-with-merge.html [...]

What is a Common Table Expression (CTE) and how do you use them?

We've had some questions about what a Common Table Expression (CTE) is. Patrick describes what they are and how you can use them in SQL Server or Azure Synapse Analytics. WITH common_table_expression (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16 Sample [...]

To Surrogate Key or Not…

We've talked about using a surrogate key in your data warehouse whether that's Azure Synapse Analytics or something else. Patrick looks at why you should consider this even if you aren't using a slowly changing [...]

Go to Top