fbpx

What are the main tools for Azure Synapse and SQL???

Getting started with Azure Synapse Analytics or Azure SQL Database? Or even Microsoft SQL Server in general? Patrick shows you how to use some of the common tools and be able to connect to your instance! Download SQL Server Management Studio https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms Download and install Azure Data Studio https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio

What are the main tools for Azure Synapse and SQL???2022-06-14T07:19:11-05:00

Writing your first SQL Statement!

New to writing T-SQL? Patrick walks you through your first SQL statement. Great foundation to have when working with SQL Server or Azure Synapse Analytics! Download SQL Server Management Studio https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms Download and install Azure Data Studio https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio Transact-SQL Reference (Database Engine) https://docs.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16

Writing your first SQL Statement!2022-05-31T08:36:02-05:00

Getting started with Azure Synapse Analytics

Not sure where to begin with Azure Synapse Analytics? Patrick gets you started and teaches you the clicks to get up and running quickly! Get Started with Azure Synapse Analytics https://docs.microsoft.com/azure/synapse-analytics/get-started

Getting started with Azure Synapse Analytics2022-05-24T06:44:12-05:00

Are you following best practices with Azure Synapse Analytics?

How do you know if you are following best practices for Azure Synapse Analytics? One way is to check out this report that Patrick walks through. It's a great way to get an understanding where your database is at! Azure Synapse Analyzer Report to monitor and improve Azure Synapse SQL Dedicated Pool performance https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/azure-synapse-analyzer-report-to-monitor-and-improve-azure/ba-p/3276960 Download [...]

Are you following best practices with Azure Synapse Analytics?2022-05-14T15:14:25-05:00

How to make SQL Pools even faster in Azure Synapse Analytics

There are different ways you can get your SQL Pools to run faster in Azure Synapse Analytics. Patrick looks at a feature that can really take it to the next level! You seriously need to watch this if you are using Synapse dedicated SQL Pools. Performance tuning with materialized views using dedicated SQL pool in [...]

How to make SQL Pools even faster in Azure Synapse Analytics2022-05-10T06:23:35-05:00

Why you should look at Azure Synapse Analytics!

Have you heard about Azure Synapse Analytics! Is your data in Synapse? It's so much more than SQL Server! Adam and Patrick look at why you should care about it! What is Azure Synapse Analytics? https://docs.microsoft.com/azure/synapse-analytics/overview-what-is

Why you should look at Azure Synapse Analytics!2022-05-03T05:43:46-05:00
Go to Top