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 Clause (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16 WITH common_table_expression (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16

Continuing the T-SQL journey with OVER and RANK2023-02-07T09:18:34-05:00

Ready to be a Kusto Detective with Azure Data Explorer?

Your detective journey starts with the Kusto Detective Agency for Azure Data Explorer. This is a really fun way to learn the Kusto Query Languate (KQL)! Patrick gets you started! And, it's FREE! Kusto Detective Agency: https://detective.kusto.io/

Ready to be a Kusto Detective with Azure Data Explorer?2023-01-31T09:24:45-05:00

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 Slowly Changing Dimension https://en.wikipedia.org/wiki/Slowly_changing_dimension Star Schema The Complete Reference https://amzn.to/3QJjw2E

What the French Toast is a Slowly Changing Dimension???2023-01-24T07:13:27-05:00

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 Scripts - https://github.com/guyinacube/demo-files/tree/master/video%20demos/Synapse

What is a Common Table Expression (CTE) and how do you use them?2023-01-17T08:06:43-05:00

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 dimension.

To Surrogate Key or Not…2023-01-03T07:53:08-05:00

Get your SQL Queries using Profiler in Azure Data Studio

Still using the older SQL Profiler? Patrick looks at how you can use the Profiler within Azure Data Studio to capture SQL queries from SQL Server or Azure SQL Database with just a few clicks.

Get your SQL Queries using Profiler in Azure Data Studio2022-12-13T06:57:28-05:00

Can you use SQL Auth with Azure Synapse Serverless?

When using Azure Synapse Analytics Serverless Pools, using Azure AD auth is pretty simple. But, what about SQL Auth? How do you get hat working? Patrick shows you how! Control storage account access for serverless SQL pool in Azure Synapse Analytics https://learn.microsoft.com/azure/synapse-analytics/sql/develop-storage-files-storage-access-control?tabs=managed-identity Sample Script: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20221206%20-%20Connect%20to%20Serverless%20-%20Security%20Script.sql

Can you use SQL Auth with Azure Synapse Serverless?2022-12-06T09:19:03-05:00

Exploring Microsoft Purview for data governance

You've probably heard of Microsoft Purview somewhere. Buck Woody joins Patrick to highlight how Microsoft Purview can help you with data governance. From cataloging to lineage, Purview is a key component for your data strategy! Connect with Buck: https://twitter.com/BuckWoodyMSFT https://www.linkedin.com/in/buckwoody/ Microsoft Purview: https://learn.microsoft.com/en-us/purview/purview https://learn.microsoft.com/en-us/microsoft-365/compliance/?view=o365-worldwide https://learn.microsoft.com/en-us/azure/purview/

Exploring Microsoft Purview for data governance2022-11-22T08:58:40-05:00

Explaining what a Lakehouse is!

You've probably heard the term lakehouse with various services like Azure Synapse Analytics. But what actually is a lakehouse? And why is it different from a data warehouse?

Explaining what a Lakehouse is!2022-11-01T07:15:10-05:00

Parameterize your Notebooks in Azure Synapse

Using notebooks in Azure Synapse Analytics? Do you find yourself wanting to have a dynamic value for use with your pipelines? Patrick shows you how you can accomplish this!

Parameterize your Notebooks in Azure Synapse2022-10-18T08:47:25-05:00
Go to Top