Skip to main content

Azure: Databases (SQL,Cosmos, Warehouses, Data Lake)

Cosmos DB
  •  Can be used with Serverless Computing
  • Globally Distributed
  • Elastic
  • Various regions
  • Can also scale storage
  • Can use SQL API
  • Enterprise ready
 The High availability helps web, gaming, IoT, and mobile 

Data Lake

  •  Enterprise
  • Big Data
  • Storing all Sorts of Data
  • Integrates with data warehouses
  • Processing
  • Analytics
  • Pay per job
  • Instant Scale
  • Used for things like
    • Xbox Live
    • Office 365
    • Skype
    • Big

SQL Database

  •  Can import data from there to Classic Machine Studio
  • Current Operational
  • Normalized Relational
  • Max Capacity is 4 TB
  • Always on by design
    • Create
    • Retrive
    • Update
    • Delete
  • Query Limit - 6400
  • Machine Learning built in (See: Azure Machine Learning Service, and Azure Machine Learning Studio Classic)

SQL Data Warehouse
  • For external data, historical operational
  • Denormalized (into larger table [notes unclear])
  • Near unlimited storage with 240 TB
  • Paused post analysis
  • Limited number of uses
  • Query Limit - 32


Popular posts from this blog

The Updated "What I'm Looking For In A Role" Post (2020)

Thank you for wanting to help with my job search! Here are some parameters.

Part time remote, text based support [Example Description]. It's a little far fetched, but the positions do exist. I enjoy having the flexibility to take on temporary projects from time to time!
Also; If anything sounds weird, out there, or unusual - Feel free to e-mail me. Doesn't have to be tech related. I just have to find it interesting and flexible.

Looking For This Type of Work:
Simplified writing about tech. [Example Job Description] You want to pay me to write more of *waves hand* this blog? I am game.
IT SupportUX Auditing [See Here]eCommerce merchandising [See Here]Email Marketing Specialist [Example Job Description]  ProofreadingThe following is what I was trained in. Roles will be considered, and I am looking to pivot to the above. Still part-time, contract, and/or temporary
Cisco routing and switching technician

Find me on Jumpstart and CareerVillage.

Remote is…

Azure Networking Options - Core Cloud Services

I have done a lot of AWS things on here. Time to give Azure some attention. After all, since employers don't think Cisco or COMPTIA certifications are important, maybe Microsoft ones are?

First, let's really think about why these are the two biggest cloud services providers in the world:

They've been doing internet things for a long time.Amazon launched in 1995, a virtual bookstore.
Microsoft, well, you know. 

They've lived, breathed, and frankly, created, infrastructure that we use today, that they're selling to us today. Of course the Store of Everything and the Company of Everything would encourage us to put everything in their hands.

Also: Azure has a lot less silly names for modules. Important. I appreciate straightforwardness.

I said 'a lot less', not '100% sensible names'

Microsoft has a clear set of Azure Fundamentals that anyone can interact with. Let's talk about networking basics, basically to say, again, "Hi, employers, I have an …

Grace Hopper Celebration 2019 (GHC19)

From Aicha Evans' speech at the Keynote.
September 6th - I receive an email from Anita B Organization, saying "We read your application, we like your website, and here's a free ticket to GHC 2019 in Orlando, Florida!"

After a few more questions, it seemed everything was on the up and up, and so I accepted - and that's what this post is about!

For those who don't know, Grace Hopper Celebration is the largest gathering of Women in Technology in the world.

On a personal note, This is the first trip I've taken without my parents. Sure, they've left me behind to go on vacations, but I've never left them. I was totally worried! But you know what happened?

I met a lot of cool people in Orlando, learned a lot of neat things, and had a blast just walking around airports for upwards of 8 hours.

New Delta Sky Club on Wikimedia I really, really love airports! And I survived.

I know in the past, I've wormed my way out of jobs despite being interested simpl…