DraganSr: 2019-02-08

Friday, February 08, 2019

GitOps

"GitOps literally means using Git everywhere from development to deployment.

Code : Write your application code and push it to Git (GitHub/GitLab etc)
Build (Pipeline as Code): Write a declarative build pipeline code(yaml) in Git to build your code on the fly using CI tools like TravisCI or GitLabCI.
Provision (Infrastructure as Code): Write a terraform (.tf)file or Ansible playbook(yaml) in Git to provision a kubernetes cluster or server i.e.compute instances on cloud(ec2/gce/azureVM)
Deploy : Write a deployment manifest(yaml) for kubernetes or based on the type of application/artifact, git web hooks use declarative CI(yaml) to deploy it on a kubernetes cluster/server/container registry(ecr/gcr/jfrog)

Resources for GitOps:

GitOps: 'Git Push' All the Things - The New Stack

From GitOps to Adaptable CI/CD Patterns for Kubernetes At Scale - The New Stack

The Must-Haves for Making the Shift to Cloud Native - The New Stack

Sample SQL databases

Microsoft/sql-server-samples: Official Microsoft GitHub Repository containing code samples for SQL Server @GitHub (MIT license)

sql-server-samples/samples/databases at master · Microsoft/sql-server-samples

Release Wide World Importers sample database v1.0 · Microsoft/sql-server-samples

wide-world-importers

The new sample database for SQL Server 2016 and Azure SQL Database. It illustrates the core capabilities of SQL Server 2016 and Azure SQL Database, for transaction processing (OLTP), data warehousing and analytics (OLAP) workloads, as well as hybrid transaction and analytics processing (HTAP) workloads.
contoso-data-warehouse

Sample data warehouse that illustrates loading data into Azure SQL Data Warehouse.
AdventureWorks

Sample databases and Analysis Services models for use with SQL Server.
northwind-pubs

Northwind and pubs sample databases. originally created for SQL Server 2000

iot-connected-car

This code sample demonstrates how a SQL Server 2016 (or higher) memory optimized database could be used to ingest a very high input data rate and ultimately help improve the performance of applications with this scenario. The code simulates an IoT Connected Car scenario where multiple cars are constantly sending telemetry data to an the Azure SQL database.

Sample Databases - PostgreSQL wiki

PostgreSQL Sample Database
"DVD rental database"
Sample Databases for PostgreSQL and More – Titus Barik

Top 3 Sample Databases for PostgreSQL - Embarcadero Community

The Sports Standards Alliance (Sample DBs)

MySQL :: Other MySQL Documentation

MySQL :: Employees Sample Database

MySQL :: Sakila Sample Database

Freebase - Wikipedia

Freebase is dead, long live Freebase – Iain – Medium

Data Dumps | Freebase API (Deprecated) | Google Developers