The following is from Azure Developer Training lab for AZ-203 Encryption Encryption is the process of translating plain text data (plaintext) into something that appears to be random and meaningless (ciphertext). Decryption is the process of converting ciphertext back to plaintext. To encrypt more than a small amount of data,symmetric encryption is used. A symmetric […]
Azure develop solutions Blob Storage
The following is from Azure Developer Training lab for AZ-203 Introduction to Azure Blob storage Azure Blob storage is Microsoft’s object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as text […]
Azure develop solution for Cosmos DB
The following is from Azure Developer Training lab for AZ-203 Azure Cosmos DB Microsoft Azure Cosmos DB is a database service native to Azure that focuses on providing a high-performance database regardless of your selected API or data model. Azure Cosmos DB offers multiple APIs and models that can be used interchangeably for various application […]
Azure develop solution for Table Storage
The following is from Azure Developer Training lab for AZ-203 Introduction to Table storage in Azure Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schema less design. Because Table storage is schema less, it’s easy to adapt your data as the needs of […]
Azure Data Services
The following is from Azure Administrator Training lab for AZ-103 CDN Benefits A content delivery network (CDN) is a distributed network of servers that canefficiently deliver content to users. CDNs store cached content on edgeservers that are close to end-users. CDNs are typically used to deliver static content such as images, style sheets,documents, client-side scripts, […]
Serverless Application using AWS Lambda, API Gateway and DynamoDB and NodeJS
This is small sample project that demonstrates a Serverless Application. It uses the following AWS Services: API Gateway Lambda DynamoDB The repository of this project can be found on github here: https://github.com/johnlee/habits The application is used as a personal goal tracker. It stores daily attempts (with timestamps) and an overall score for the day. […]
Serverless App using AWS API, DynamoDB, Lambda, S3 and Visual Studio .Net
This is a sample project using Visual Studio 2017 (.Net 4.5 + Core 2) and the following AWS services: API Gateway DynamoDB Lambda S3 CloudFormation This project will have an Angular web front end hosted on S3, which calls APIs in the API Gateway. Those APIs are defined as Lambda functions and interact with DynamoDB […]
Working with DynamoDB SDK API and .Net
In this post I’m doing a deep dive of AWS DynamoDB database and using the available APIs with .Net Core. For more general information on DynamoDB, refer to this post: http://solidfish.com/overview-of-aws-dynamodb/ The code shown here is from another post where I created a complete serverless web application in AWS using DynamoDB. Below is a […]
AWS Databases
This article covers database services in AWS Elasticache RDS / Aurora RedShift DynamoDB EMR / Hadoop Which database service to use OLTP vs OLAP Online Transaction Processing (OLTP) differs from OLAP Online Analytic Processing (OLAP) in terms of the types of queries you will run. OLTP is like an order placed in a shopping app. […]
Database Access from IIS Best Practices
This document reviews techniques and best practices in securing connections between a web application server and database system. This document focuses on .Net based web applications running on IIS and connecting to a MS SQL Server database. It assumes the web application is accessible to an intranet or internet. This document references IIS7.5+, Windows Server […]
Entity Framework 6
These are my notes while reviewing the latest release of Entity Framework EF6 Migrations = creates or updates database automatically as models in the application change. This lets developers focus on the application models and not worry about the database. EF SaveChanges() This does the actual SQL command execution. It is […]
Relational vs Non-Relational Databases
Other notes here regarding types of databases and cloud providers for these types of databases. http://solidfish.com/types-of-databases/ History Relational theory Tuples = unordered set of attribute values (row and attribute of column in a table) Relation = collection of tuples and corresponding relations Constraints = enforce consistency; used to identify tuples and relationships between them […]
Types of Databases
These are some notes on different types of databases used in the current industry. Refer to my other post on Relational vs Non-Relational Database for more information specific to NoSQL Document Databases. http://solidfish.com/relational-vs-non-relational-databases/ Below is a list of some different types of databases as well as some platforms/tools for these database types. Document Databases […]