How to create an Azure SQL Database
Вставка
- Опубліковано 4 жов 2024
- Another video brought to you by BeardedDev, bringing you tutorials on Data Engineering, Business Intelligence, T-SQL Programming and Data Analysis.
If you like the videos you can support me on Patreon, / beardeddev
In this video I walk you through step by step how to create an Azure SQL Database, there are many options when creating an Azure SQL Database and whilst I don't go into extensive detail as they would take a very long time I briefly touch on the different configurations options and what they mean.
I want you to get started quickly and be able to query your database straight away, I also show how the AdventureWorksLT database can be added and how you can use Query Editor to start querying.
Be sure to stay tuned for more videos and tutorials.
DEV Come back we need more SQL videos!!
Hi Brian, don't worry I will be back very soon
@@BeardedDevData awesome nice one!
BeardedDev, could you make some Azure Synapse tutorials ? What is the difference between synapse and ADF? Thank you. 🙂
Hi, I'm just taking a short break but will be back early next year, the plan will be to do a lot more on Data Engineering in Azure and help people get into the Data Engineering field, in terms of ADF and Synapse Pipelines, they are pretty much equivalent. Microsoft have just decided to move it under the umbrella of Synapse Analytics, in addition Synapse Analytics also includes Serverless SQL Pools, Dedicated SQL Pools and Serverless Spark Pools.
You are being way too quiet. Any plans for new videos?
Apologies, a project I'm working on is taking much longer than expected, I will anticipate having some new content uploaded in April.
Hi, thank you for the video. I have got to know abut this Azure SQL function DATE_BUCKET to aggregate the datetime columns. But it is applicable only for Azure. Could you please help me to replicate it in regular SQL Server Function?
That’s available for Azure SQL Edge, it serves as storage for streaming data. You would have to create your own solution in SQL Server and it would depend on what you want to achieve, how much data you have and what the date range is as to how to approach. In a data warehouse scenario, we create separate date and time tables to store various different buckets which is an option in OLTP databases too or you could use date functions.
@@BeardedDevData currently I am using the combination DATEDIFF() and DATEADD() functions to achieve this result. But DATE_BUCKET is looking neat & I wouldn't have to worry about the conversions & date types... My requirement is just to store some stock prices after downsizing to a custom time period. And the data will not exceed 3 months. I thought of requesting you to make a video in stock price aggregation from granular price data & continuous aggregation of that on constant intervals. If you think this is a good example & help your viewers, please make a video.
It would be a good function to have, they see it more for constantly arriving data but perhaps it will be rolled out in the future. Definitely a good idea for a video though.