fbpx

Get the most as a Data Scientist with Microsoft Fabric (Public Preview)

Going down the DATA SCIENCE path can be hard when trying to get all the right data. Microsoft Fabric breaks down barriers and allows for easy reuse of data with OneLake. Nellie joins to talk about how data scientists can take advantage! What is Data Science in Microsoft Fabric? https://learn.microsoft.com/fabric/data-science/data-science-overview Develop, execute, and manage Microsoft [...]

Get the most as a Data Scientist with Microsoft Fabric (Public Preview)2023-06-21T07:49:39-05:00

🔴 Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)

Join us live as we answer your questions about Microsoft Fabric including Power BI with out guest Amir Netz who is a Microsoft Technical Fellow and CTO/Visionary of Microsoft Fabric. You don't want to miss this one! Connect with Amir: LinkedIn: https://www.linkedin.com/in/amirnetz/ Twitter: https://twitter.com/amirnetz 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front [...]

🔴 Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)2023-06-21T08:32:34-05:00

How to SCHEDULE your notebooks to run with Azure Synapse

Taking advantage of Notebooks in Azure Synapse Analytics? How do you automate that great work you did? Patrick shows you some options to schedule the run of your notebooks.

How to SCHEDULE your notebooks to run with Azure Synapse2023-05-02T07:21:10-05:00

Use Azure SQL Managed Instance Link to have a Read Replica in the cloud!

Want to leverage the power of the cloud with your on-prem SQL Server? Azure SQL Managed Instance may be the answer for you! Dani joins us to talk about why MI Link can help bridge the two. Azure SQL Managed Instance https://learn.microsoft.com/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql Azure SQL Managed Instance Link Overview https://aka.ms/mi-link Managed Instance (MI) Feedback to Product [...]

Use Azure SQL Managed Instance Link to have a Read Replica in the cloud!2023-04-11T08:04:26-05:00

What’s a JUNK DIMENSION and when should you use it?

Maybe you've heard of the concept of a junk dimension but what exactly is it and when should you use it? Patrick breaks down this dimensional modeling concept. Junk Dimensions https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/junk-dimension/ Design Tip #113 Creating, Using, and Maintaining Junk Dimensions https://www.kimballgroup.com/2009/06/design-tip-113-creating-using-and-maintaining-junk-dimensions/ Sample Script: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230321%20-%20Junk%20Dimension.sql

What’s a JUNK DIMENSION and when should you use it?2023-03-22T08:25:13-05:00

Checking out the Window Clause in Azure SQL and SQL Server 2022

Partitioning is nice in SQL, but how about using the WINDOW clause to make it more efficient? Patrick looks at how to use this function with Azure SQL and SQL Server 2022! SELECT - WINDOW - (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16

Checking out the Window Clause in Azure SQL and SQL Server 20222023-02-21T08:52:21-05:00

Provide data lake access with Azure Synapse Analytics

Using a lake database with Azure Synapse Analytics and struggling to figure out permissions needed for your data readers? Patrick and Adam show you what's missing! Azure Synapse Access Control https://learn.microsoft.com/azure/synapse-analytics/security/synapse-workspace-access-control-overview How to set up access control for your Azure Synapse workspace https://learn.microsoft.com/azure/synapse-analytics/security/how-to-set-up-access-control Control storage account access for serverless SQL pool in Azure Synapse Analytics [...]

Provide data lake access with Azure Synapse Analytics2023-02-14T08:02:43-05:00

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
Go to Top