AzureLearningOfGuru

  Permalink Udemy course link   Objective - to create azure sql db in my personal (gurao@hotmail.com) Azure account and then access it for flowwright forms.   <AZURE SQL DB - START>    azure resource group: rg-kf-AzureSQLDB    database name: db-azsql-kf-flowwright-trial    Server name: svr-azsql-kf-flowwright-trial    Server name with fqdn :     admin : azsqlserveradmin    (V**!k**!**3  This  MS tutorial link  helped in creating DB in Azure.   Also, Azure Studio had to be used. SSMS could help. Could not create Schema in Azure, some issues..   <AZURE SQL DB - END>    

Permalink Last updated on -  Enrolled on 1st july Course link   git link ECDC Website for Covid-19 Data -  https://www.ecdc.europa.eu/en/covid-19/data Euro Stat Website for Population Data -  https://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?file=data/tps00010.tsv.gz

Updated on -> 1st July 9 PM. The following was tried out on 20th June and then till 25th/26th  june.  Then documentation below was updated on 26th/27th june. Since, then most time away for health. Today, 1st July, was all about trying to get blog post Updated time to show .. no luch, so to be done manually only  Permalink 1. Good ADF starter and free  -    - Good quick starter. Moving json from blob storage to data lake storage with ADF (20th June)   1. Create ResourceGroup (naming conventions explained)        1. Create a dashboard with appropriate naming convention and pin the resource group above to the dashboard   2. Create storage account , for source data - this is done in a new resource group in the udemy class.        1. in this account, create a container instance      2. Upload json file (sales.json provided by tutor) in this container   3. Create another storage account to hos...

  Permalink   Enrolled in the course with the same name as the title of this blog post in udemy, primarily to learn creating, managing sql server vms in Azure.

  Permalink

  Permalink 1. Azure Portal - tips to use it for free chapter in the course 2. An example of free Azure resource availability even after free azure portal run out of free budget  3. Resources available via Visual Studio based subscription  (gurao@hotmail.com) 4.  IaaS and PaaS table in this context  5. Same link as above -> NoSQL Offerings of MS Azure     a. Az storage, Data Lake, cosmos DB..     b. standard storage vs premium storage    c. Programmatic access to az storage - rest api, sdks, powershell, az cli, az storage explorer, az copy     d. az storage v2 vs az storage v1 vs blob storage  6. Many of these course content options not available in az data storage now..  7. Storage account networking    private network access, select  public network access, open to all public.