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/
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
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
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
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
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 [...]
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 [...]
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
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
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 [...]
