Study Guides for DP-300 Administrating Relational Databases on Microsoft Azure

For all Microsoft SQL server admin and developer friends ๐Ÿ‘๐Ÿ‘Œ

DP-300 examย is out there, and I am trilled to pieces having it next week:

Caveat is, there is no officially published study guide yet (while it is Beta). I have compiled following resources from community members and in ne place for you.

We have following study guides to get help from:

1. Check Gregor Suttie’s guide ๐Ÿ‘‰ https://lnkd.in/e-H-hNG

2. Check Ravikiran Srinivasulu’s guide ๐Ÿ‘‰ Study Guide for DP-300

3. Check Gonzalo Juan Jose Bissio guide ๐Ÿ‘‰ DP 300 My experience ๐Ÿ™‚

4. Free e-book from Microsoft onย Professional Azure SQL Database Administration

Please, let us know if you have other good sources for exam preparation. Feel free to share it with community by providing valuable feedback in the comments section.

Updated: I would also recommend to read this post: “Level up with Microsoft Certified: Azure Database Administrator Associate” from Microsoft Tech Community” https://lnkd.in/eXSHbMt #SharingIsCaringโค๏ธ

Good Luck on your upcoming exam!
Keep my posted on your success & journey progress!

#azure #sqldatabase #sqldeveloper #sqlserver #certification #betaexam

#MSBuild 2020 Cloud Skills Learning Challenge and Azure exam voucher

Hello friends,

In this post, I am excited to share about – how you could use your Microsoft Build 2020 registration/account to sign-up for Cloud Skills Learning Challenge and complete at least one challenge to earn a complementary Azure exam voucher, by June 2, 2020.

Thank you @Microsoft for this generous offer. Really appreciated!

So buckle-up friends, and Let’s START!

First thing first, you would need to have following 3 things:

Once signed-in into Microsoft Build 2020 registration account, you would need to follow pdf instructions from Microsoft.

Upon successful registration with Microsoft Build Cloud Skills Challenge you would see something similar to the following screen-shot:

Clicking on first item from Challenge Collection will show-up similar to the following screen-shot:

Note: it will show 0% completed initially, however as you move forward with training items it will go up. Upon completion of at least one challenge from Collection by June 2

Official rules of the Microsoft Build Cloud Skills Challenge could be found here.

That’s it friends, buckle up to complete your challenge before June 2, 2020 to receive a complementary Azure exam voucher and maybe some other prizes from sweepstake.

Good Luck!

KEY 30+ free training materials for everyone

Hello my friends!

I have been asked about free, online training resources. I have compiled, to my best knowledge, all recent training resources in this post. However, please feel free to add your comments (aka, 2 cents ๐Ÿ’ฐ) and extend this list together ๐Ÿ™‚

All the training resources could be used by anyone around the glob 24/7. Note that few training resources are geared toward certain US state learning programs.

I truly hope, you could share these resources with your friends, who might be looking for affordable training, and prepare themselves for a better future.

  1. Microsoft Learn: https://docs.microsoft.com/en-us/learn/
  2. Google Cloud Training: https://cloud.google.com/training
  3. Oracle OCI training with free exam till May 15, from Raghu Viswanathan: https://www.oracle.com/corporate/blog/free-certifications-oracle-oci-autonomous-033020.html
  4. IBM AI training: https://cognitiveclass.ai/
  5. Pluralsight – free April month: https://www.pluralsight.com/
  6. Harvard University. Pay for official certificate only: https://harvardx.link/sz4ck
  7. Tableau (90 days with code 2020elearning): https://www.tableau.com/learn/training/elearning
  8. Qlik (online training): https://www.qlik.com/us/announcements/covid-19-response
  9. Databricks: https://www.databricks.training/learn-from-home/index.html
  10. Looker: https://training.looker.com/
  11. Coursera: https://blog.coursera.org/coursera-together-free-online-learning-during-covid-19
  12. Atlassian: https://www.atlassian.com/software/free
  13. MicroStrategy (45 days till May 15th 2020): https://www.microstrategy.com/us/free-education
  14. Free Training from BMCC/ NY-Cisco, A+, EMT, Medical Assistant, etc. https://www.bmcc.cuny.edu/ce/
  15. New York Mechanic’s Apprenticeship Program: https://www.nyatlas.org
  16. Web Development training at LaGuardia Community College: https://www.laguardia.edu/Open-Code-Information/
  17. OSHA Training, and several other Free Training – New York: http://www.cb14brooklyn.com
  18. SUNY Bronx- Free Training- GED, Master Barber, Medical Assistant, EMT, etc. http://www.bronxeoc.org/index.html
  19. Learn to code: https://www.freecodecamp.org/
  20. Training in programming and IT : https://www.npower.org/
  21. Training in Cyber Security, Net +, A+, System Admin, etc: https://perscholas.org/
  22. Year Up for 18-24 years old offered in several states in the US. 12 months program with internship: https://www.yearup.org/
  23. Training in IT, Construction, Medical Admin Assistant: usa.generation.org/regeneration
  24. Free IT Training with Certificate: https://thegymnasium.com
  25. Training in several states and online for CompTIA A+ : https://www.creatingitfutures.org
  26. Salesforce training : https://trailhead.salesforce.com/
  27. Sign up for Free trial to take cert exams like: A+, Net, CySa+, Cisco, PMP : https://www.ucertify.com/
  28. Python training from Google: https://www.udacity.com/course/programming-for-data-science-nanodegree–nd104
  29. University of the People- Free degree program in Computer Science, Business Administration, Health Services: https://www.uopeople.edu
  30. Much more online training from @Rajanand’s post: https://www.linkedin.com/pulse/free-learning-resources-rajanand-ilangovan/
  31. Atlassian free product training catalog: https://training.atlassian.com/free-training-catalog

These list is not complete and I look forward for your contributionsย #linkedinfamily ย to keep this post updated #SharingIsCaringโค๏ธ

Setting up Microsoft FHIR Server on your laptop & FHIR-ing up…

Hello my FHIR-ly friends, and welcome to my first post on Microsoft FHIR server!

Over the last few months, i worked with Microsoft Open Source FHIR Server (OSS) and wanted to share my experience on setting it up and running locally. Yes, you may run it locally without internet ๐Ÿ™‚

This might be helpful, if you just starting to learn HL7 FHIR (https://www.hl7.org/fhir/) and don’t / can’t spin one on your cloud environment of choice. You might also use any publicly available FHIR endpoints, discover-able from the link above.

Following steps will assist you in spinning it with a Cosmos DB (emulator flavor) or a more traditional SQL Server instance. Well, let’s start right away!

  • In VS openย Microsoft.Health.Fhir.slnย & restore the packages
  • Run the build process & setย Microsoft.Health.Fhir.Stu3.Webย ย as a start-up project
  • Note: You could also useย Microsoft.Health.Fhir.R4.Webย ย – based on fhir resource versions that you are planning to load.
  • Made following changes inย appsettings.json
"Security": {
      "Enabled": true,
      "EnableAadSmartOnFhirProxy": false,
        "Authentication": {
            "Audience": "fhir-api",
            "Authority": "https://localhost:44348"
        },
      "PrincipalClaims": [
        "iss",
        "oid"
      ],
      "Authorization": {
        "Enabled": true
      }
    },

Option 1: Selectingย Cosmos DBย data layer

Option 2: Select SQL data layer & start project (aka Press F5)

Lunch the FHIR server locally by pressing F5 – should look like following screen:

  • Run postman Query for Server CapabilityStatement: https://localhost:44348/metadata?_format=json 
  • Check the Postman SSL certification verification is off, or accept the dotnet development certificate.
  • Retrieve token to access the FHIR Server resources:
POST https://localhost:44348/connect/token
BODY: client_id=serviceclient&client_secret=serviceclient&grant_type=client_credentials&scope=fhir-api

Hope you got so far & starting your celebration… Yes, my friend, you did it! Congratulations!!!

You are ready to play with FHIR ๐Ÿ”ฅ … Just remember, to follow the FHIR safety rules that we will cover on next post ๐Ÿ™‚ Stay tuned and let me know what are you thoughts in the comments. Thanks!

How to start Cloud Journey in your organization?

Hi Cloud Marathoners!

It is usually hard to start a new initiative within a company due to a myriad of reasons. ๐Ÿค”
Thus, this post will focus on how to follow some descriptive steps in starting a new Cloud Journey whereever you are in your life ๐Ÿ™‚

Let’s check a simple approach ๐Ÿ’ก below that could guide us on cloud โ˜๏ธ (AWS, Azure, GCP, Oracle Cloud) adoption journey ๐Ÿ—บ

Choosing the right cloud solution provider for your customers?

1๏ธโƒฃ Step: Check on Team Alignment with cloud fundamentals
โœ”๏ธ Every team member should have a basic understand of how specific cloud works
โœ”๏ธ Portfolio of candidate workloads should be available to all team members to be used during strategic, release planning and completion of technical tasks 
โœ”๏ธ The technical strategy should include clarity on which levels of the hosting hierarchy will be used and what those terms mean in our business
โœ”๏ธ A naming and tagging standard should be established, maintained, and enforced to guide implementation and resource organization
โœ”๏ธ The hosting hierarchy should be reflected in a resource organization design (account or subscription design)
โœ”๏ธ Align cloud capabilities, teams, and RACI structure to the fundamental concepts above

As an addition, what would you add into first checklist ? ๐Ÿค”

Please, share your thoughts in comments section ๐Ÿ‘ย #SharingIsCaringโค๏ธ๏ธ

Looking ๐Ÿ‘€ for more?
Follow the #cloudmarathoner tag on LinkedIn and via blog postsย ๐Ÿ’ก

FแดสŸสŸแดแดก แดแด‡ ๐ŸŽฏ แด€ษดแด… become แด€ #cloudmarathoner โ›…๐Ÿƒโ€โ™‚๏ธ๐Ÿƒโ€โ™€๏ธ – ๐‹๐„๐“’๐’ ๐‚๐Ž๐๐๐„๐‚๐“ ๐Ÿ‘

#cloudjourney
#cloudskills
#firststeps
#cloudadoption
#continuouslearning