Category: Azure

Are you using your licenses correctly? See where Azure Hybrid Benefits can help!

Posted on by Annie D

If you are moving your on-premises SQL Servers to the cloud, and/or if you have a mix of Azure SQL, Managed Instance and on-prem, make sure you are licensing correctly with Azure Hybrid Benefits. Shashank shows us how!

Azure Hybrid Benefit
https://azure.microsoft.com/pricing/hybrid-benefit/

Azure Hybrid Benefit – Azure SQL Database & SQL Managed Instance
https://learn.microsoft.com/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal

Azure Hybrid Benefit for Windows Server
https://learn.microsoft.com/windows-server/get-started/azure-hybrid-benefit

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: <a href=”https://guyinacu.be/courses” Continue reading “Are you using your licenses correctly? See where Azure Hybrid Benefits can help!” →

Convert CSV to Parquet using pySpark in Azure Synapse Analytics

Posted on by Annie D

You’ve got a bunch of CSV files and you’ve heard of Parquet. How do you convert them for Azure Synapse Analytics? Patrick shows you how using pySpark.

pyspark DataFrame
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/dataframe.html

pyspark.sql.DataFrameReader.load
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrameReader.load.html

pyspark.sql.DataFrameWriter
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrameWriter.html

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Continue reading “Convert CSV to Parquet using pySpark in Azure Synapse Analytics” →

Art of the Possible with Power Platform and Azure Synapse

Posted on by Annie D

What happens when you combine Power BI, Power Apps and Azure Synapse Analytics? MAGIC! Join Gaston Cruz as he shows a way to bring the Power Platform together with Azure Synapse!

Gaston Cruz
https://twitter.com/GastonFCruz
https://www.linkedin.com/in/gastoncruz/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— rel=”nofollow”>https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #GuyInACube

Start Learning T-SQL for Azure Database and Azure Synapse

Posted on by Annie D

Starting your journey to learn SQL? Adam gives you some resources to quickly ramp up with T-SQL for Azure SQL Database and Azure Synapse Analytics!

SQL Standard
https://en.wikipedia.org/wiki/SQL#Standardization_history/

Procedure Extensions – Different SQL bases out there
https://en.wikipedia.org/wiki/SQL#Procedural_extensions

Get Started Querying with Transact-SQL – Learning Path
https://learn.microsoft.com/training/paths/get-started-querying-with-transact-sql/

Transact-SQL reference (Database Engine)
https://learn.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16

T-SQL Fundamentals (Developer Reference) – Itzik Ben-Gan
https://amzn.to/3Jd2yHQ

Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code
Pedro Lopes / Pam Lahoud
https://amzn.to/3mriUUm

Brent Ozar Unlimited
https://www.brentozar.com/

StackExchange – Questions
https://stackexchange.com

📢 Become a member: https://guyinacu.be/membership

*******************

Want Continue reading “Start Learning T-SQL for Azure Database and Azure Synapse” →

Parameterize your Notebooks in Azure Synapse

Posted on by Annie D

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!

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – <a href=”https://guyinacube.com/tools/” Continue reading “Parameterize your Notebooks in Azure Synapse” →