Friday, February 08, 2019

GitOps

What is GitOps? - Quora

"GitOps literally means using Git everywhere from development to deployment.
  1. Code : Write your application code and push it to Git (GitHub/GitLab etc)
  2. 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.
  3. 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)
  4. 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 - Operations by Pull Request"


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


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
(22 GB => 250 GB)