The following is from Azure Developer Training lab for AZ-203 The Azure SQL Database service SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML. SQL Database delivers dynamically scalable performance within two different purchasingmodels: a vCore-based purchasing model and a DTU-based […]
Azure Storage In Depth
The following is from Azure Administrator Training lab for AZ-103 Azure Storage Azure Storage is Microsoft’s cloud storage solution for modern data storage scenarios. Azure Storage offers a massively scalable objectstore for data objects, a file system service for the cloud, a messaging store for reliable messaging, and a NoSQL store. Azure Storage is: Durable […]
Azure Storage
The following is from Azure Administrator Training lab for AZ-103 These are some reference notes using Azure Storage services as of 12/2018. The main storage services available are listed below and explained further in the sections below. Azure Blobs (objects/media) Azure Data Lake Storage (gen2) Azure Files (File Server) Azure Queues Azure Tables Azure Cosmos DB […]
Benchmarking AWS Databases
This was a quick app I created to run some basic tests against database services in AWS. It does basic read and writes using ADO.NET-ish frameworks. The dataset used is a 10 column varchar object called Item found in the mocks folder. The program can be run with different dataset sizes. Everything is configured through […]
.Net Core EF (Entity Framework v2.1)
This is an overview of EFCore 2.1 which contains many new features from EF6, such as lazy loading – which was not in EF Core until v2.1. EF Core Migrations EF Migrations We can run EF Migrations through Visual Studio in the PM console or through a plain command line console using […]
AWS Storage and Data Services
This article covers Storage services in AWS. EBS EC2 Instance Store EFS S3 S3 Glacier ElastiCache EMR CloudFront StorageGateway Import / Export Snowball / Snowmobile EBS Amazon Elastic Block Store (Amazon EBS) provides block level storage volumes for use with EC2 instances. EBS volumes behave like raw, unformatted block devices. You can mount these […]
ASP.NET MVC, WEBAPI, SQL, Unit Test and EF on Azure
This is a sample project that contains the following: ASP.NET MVC (4.6) ASP.NET WEBAPI SQL (SQL SERVER 2014) ENTITY FRAMEWORK (5) UNIT TESTS All is deployed on Azure here: http://samplewidgets.azurewebsites.net/ This is a project I use as kind of a template for other projects that use similar technologies and frameworks. I’ve also used it to […]
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 […]
SQL Server Account Types and Security
A quick reference to SQL Server Account Types and System Security Ports Clients connect to SQL Server through UDP 1434 SQL server responds with a TCP Port number to continue their connection Default TCP port is 1433 Server and System Security SQL Service runs under a service account, can be: Windows account […]
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 […]