fbpx

Talking DATA end to end with Buck Woody

Where does your data come from? What do you need to consider with your data? Buck Woody explored the world of data and how services like Azure Synapse Analytics and Power BI can help you in your journey! Connect with Buck: https://twitter.com/BuckWoodyMSFT https://www.linkedin.com/in/buckwoody/

Talking DATA end to end with Buck Woody2022-09-20T08:12:02-05:00

Merging your data in a modern lakehouse data warehouse

Learn how you can move your data through different tiers using MERGE either with pySpark or SQL in Azure Synapse Analytics. Stijn Wynants walks you through the different steps. Stijn Wynants https://twitter.com/SQLStijn pyspark.sql.SparkSession.createDataFrame https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.SparkSession.createDataFrame.html Table deletes, updates, and merges https://docs.delta.io/latest/delta-update.html#language-python Delta Lake Documentation https://docs.delta.io/latest/delta-intro.html

Merging your data in a modern lakehouse data warehouse2022-08-30T06:48:44-05:00

What is this delta lake thing?

You may be using a lake for your data and it may just be regular parquet files. In this video, Stijn joins us to explain why you should be using a delta lake instead and how this works in Azure Synapse Analytics. Connect with Stijn https://twitter.com/SQLStijn What is Delta Lake https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-what-is-delta-lake Delta Lake Documentation https://docs.delta.io/latest/delta-intro.html

What is this delta lake thing?2022-08-24T07:46:41-05:00

Get started with SPARK in Azure Synapse Analytics

Using Spark in Azure Synapse Analytics opens up a lot of possibilities to work with your data. Venk joins us to get you started with setting it up and quickly using data. Connect with Venk: https://www.linkedin.com/in/venkatesh-titte-4907467/ Apache Spark in Azure Synapse Analytics https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-overview Azure Open Datasets https://docs.microsoft.com/azure/open-datasets/dataset-catalog

Get started with SPARK in Azure Synapse Analytics2022-08-16T06:31:48-05:00

Top 5 things to get started with Azure Synapse Analytics

Getting started with Azure Synapse Analytics? Here are 5 things you should know as you begin your journey! Already been using Synapse SQL dedicated pools? Are you aware of these items? Connect with Shane: https://www.linkedin.com/in/shanerisk/ Best Practices: https://docs.microsoft.com/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool What is dedicated: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is Table Distribution: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute Indexes: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index Statistics: https://docs.microsoft.com/azure/synapse-analytics/sql/develop-tables-statistics Data Loading: https://docs.microsoft.com/azure/synapse-analytics/sql/data-loading-best-practices

Top 5 things to get started with Azure Synapse Analytics2022-08-09T07:55:42-05:00

Can you be a Data Scientist without actually being a Data Scientist???

Forecasting data and other items are usually stuff that data scientists use to tell the future. What if you could do the same thing - EASILY! Tzvia is back to show you how Azure Data Explorer can help! Connect with Tzvia: https://www.linkedin.com/in/tzvia/ https://twitter.com/tzvia Time series analysis in Azure Data Explorer https://docs.microsoft.com/azure/data-explorer/time-series-analysis Anomaly detection and forecasting [...]

Can you be a Data Scientist without actually being a Data Scientist???2022-08-02T06:19:47-05:00

FAST – Billions of rows with Azure Data Explorer (ADX)

Have you tried Azure Data Explorer? We look at how ADX can support large amounts of data and query at blazing fast speeds. it truly is BANANAS! And you can try it for FREE! Connect with Tzvia: https://www.linkedin.com/in/tzvia/ https://twitter.com/tzvia What is Azure Data Explorer? https://docs.microsoft.com/azure/data-explorer/data-explorer-overview Create a free Azure Data Explorer cluster https://docs.microsoft.com/azure/data-explorer/start-for-free-web-ui Azure Data [...]

FAST – Billions of rows with Azure Data Explorer (ADX)2022-07-26T07:36:42-05:00

Intro to aggregates in T-SQL

Getting started with T-SQL? Patrick looks at using aggregate functions within your statements to help get the right results. If you are just starting with T-SQL in either Azure SQL Database or Azure Synapse Analytics, this is for you! Transact-SQL Reference (Database Engine) https://docs.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16 Aggregate Functions (Transact-SQL) https://docs.microsoft.com/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver16

Intro to aggregates in T-SQL2022-07-19T06:36:19-05:00

What’s up with the different JOINS in Azure SQL and Azure Synapse?

Not sure what the different JOINs mean in Azure Synapse Analytics and Azure SQL Database? Patrick walks you through the different types to get you on the right path! Joins (SQL Server) https://docs.microsoft.com/sql/relational-databases/performance/joins?view=sql-server-ver16

What’s up with the different JOINS in Azure SQL and Azure Synapse?2022-06-28T08:00:30-05:00

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!

Trying to get started with a Modern Data Lakehouse? There are so many options today. Where do you even begin? Patrick and Stijn help you get a handle on it with Azure Synapse Analytics! Stijn Wynants https://twitter.com/SQLStijn Building a Modern Lakehouse Data Warehouse with Azure Synapse Analytics: Moving your Database to the lake https://sql-stijn.com/2022/06/14/building-a-modern-lakehouse-data-warehouse-with-azure-synapse-analytics-moving-your-database-to-the-lake/ Pipelines [...]

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!2022-06-21T08:40:18-05:00
Go to Top