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

Connecting IoT Devices to a Registration Server (Packet Tracer, Cisco)

In Packet Tracer, a demo software made by Cisco Systems. It certainly has changed a lot since 2016. It's almost an Olympic feat to even get started with it now, but it does look snazzy. This is for the new CCNA, that integrates, among other things, IoT and Automation, which I've worked on here before. Instructions here . I don't know if this is an aspect of "Let's make sure people are paying attention and not simply following blindly", or an oversight - The instructions indicate a Meraki Server, when a regular one is the working option here. I have to enable the IoT service on this server. Also, we assign the server an IPv4 address from a DHCP pool instead of giving it a static one. For something that handles our IoT business, perhaps that's safer; Getting a new IPv4 address every week or so is a minimal step against an intruder, but it is a step. There are no devices associated with this new server; In an earlier lab (not shown), I attached them to 'H

What Do You Need? [List of Offered Services]

2023 Version is here, at this handy Notion Page.

Building, Breaking, and Building A CRM with Retool

 I like no- or low-code solutions to things. I've often wanted to simply push a button or move some GUI around and have the code implement itself.  I've thought about building something that's like a customer relationship management (CRM) system for keeping up with my network better than my little spreadsheet where I click links and then go like something. The general idea in this CRM Development is:  To have a GUI to add people to a NRM (Network Relationship Management).       Attach it to a database (MySQL is what I went with eventually using Amazon Relational Database service, but you can use PostGRES, and probably others).     Make sure components are connected to each other in the retool interface. This video is a good start. Watching the tutorial video, heard some SQL commands and went 'Oh no 😳" before going "Wait I know basic SQL", which is good, because you'll see.  When you get set up, there's a plethora of resources you can use -- Incl