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

Comments

Popular posts from this blog

What Do You Need? [AKA; List of Offered Services] (2020)

I am a remote consultant.   I enjoy having the flexibility to take on temporary projects from time to time! I start at part-time, temp work for now. If we like each other, we can renegotiate. 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. Services Offered Writing about tech [ Example Job Description , 2 , 3 ]      You want to pay me to write more of *waves hand* this blog? I am game .   Email Marketing Specialist [ Example Job Description ]       I write B2C e-mails going out to over 280 people weekly.   Technical Analyst [ Example Job Description ]      Let me find out what works and what doesn't for your internal software.    IT Operations Tech [ Example Job Description ]     Hardware and SaaS support.  Web Support [ Example Job Description ]      I help you with adjustments in HTML, CSS, and Javascript. Text-based support [ Example Description ].           Wh

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, &quo

Portfolio of UX/Product Feedback {Updated: November 20 2020}

Have You Looked at Your Webpage From the Customer's View Lately? You have probably been linked here from a form or my resume. If you have any questions about what I'm looking for in a role, click here .   This post is not to shame, but to point out errors and hopefully make my talent for finding and documenting such mistakes clear to someone hiring. Contents: Instances where I offer constructive feedback on someone's website, logo, or app. Actions that were taken by the developers or artists.  I'm glad you want your webpages to be the best they can be with my help; If you need your sites audited, e-mail me . Latest Update -  November 20th, 2020.