Chai is a BDD / TDD assertion library for node and the browser that can be paired with any javascript testing framework.

Chai is a testing framework for Javascript like NUnit for .NET.

References:

• http://chaijs.com/

Lazy initialization of an object means that its creation is deferred until it is first used.

System.Lazy<T> class

• Assemblies: System.Runtime.dll, mscorlib.dll, netstandard.dll and System.Core.dll

References:

• https://docs.microsoft.com/en-us/dotnet/framework/performance/lazy-initialization
• https://docs.microsoft.com/en-us/dotnet/api/system.lazy-1

Asymptotic Notations are languages that allow us to analyze an algorithm’s running time by identifying its behavior as the input size for the algorithm increases. This is also known as an algorithm’s growth rate.

http://bigocheatsheet.com/

https://www.khanacademy.org/computing/computer-science/algorithms

Iris Flowers Dataset is used as the "hello world" dataset in machine learning and statistics.

https://en.wikipedia.org/wiki/Iris_flower_data_set

https://archive.ics.uci.edu/ml/datasets/iris

https://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data

Tuckman's stages of group development

The forming–storming–norming–performing model of group development was first proposed by Bruce Tuckman in 1965.

https://en.wikipedia.org/wiki/Tuckman%27s_stages_of_group_development

Use EXEC to execute a dynamically generated SQL statement or query.

Executes a command string or character string within a Transact-SQL batch, or one of the following modules: system stored procedure, user-defined stored procedure, CLR stored procedure, scalar-valued user-defined function, or extended stored procedure.

declare @sourceDb sysname = N'[dbSource].[schema].[SourceTable]';
declare @sqlCommand varchar(max);

-- get count of source database table
SET @sqlCommand = 'select count(*) from ' + @sourceDb;
EXEC (@sqlCommand)

References:

• https://docs.microsoft.com/en-us/sql/t-sql/language-elements/execute-transact-sql?view=sql-server-2017
• Also see sp_executesql

• Syntax: Create Table #UseTempTable
• Temporary tables are created by prefixing your table name with a #.
• To get a list of temp tables: select * from tempdb..sysobjects;

References:

• https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-temporary
• https://www.w3schools.com/sql/sql_insert_into_select.asp

A pivot table allows for reorganizing and summarizing selected columns and rows in a data set. This data set could be from a spreadsheet or a database table to form a desired report.

A pivot table doesn't change the underlying data.

Pivoting means to turn a data set to view it from different perspectives.

References:

• https://searchsqlserver.techtarget.com/definition/pivot-table

• 302 - temporary redirect
• 301 - permanent redirect

References:

• https://httpstatuses.com

To build intelligent security solutions correlate alerts, get additional context to speed up investigation, automate security operations, use Microsoft Graph Security API.

• A federated system
• Microsoft Graph Security API
• Security API notification subscription
• Secure Score, system wide
• Identity security score, AD

https://www.microsoft.com/en-us/security/intelligence-security-api

• GA of Cassandra API
  • Table API
  • MongoDB
• Keyspace ?
• CQL Query Builder
• CQL Shell (CQLSH)
• Cassandra Stress, to verify performance
• Scale throughput
  • Change the throughput for any table
• SDK access
  • org.apache.spark...

Ignite 2018 session: https://myignite.techcommunity.microsoft.com/sessions/65369?source=schedule#ignite-html-anchor

Cheatsheets: https://docs.microsoft.com/en-us/azure/cosmos-db/query-cheat-sheet

https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

Net customer/user Satisfaction (NSAT)

NSAT is an index of net satisfaction scores across a number of segments and audiences as measured by the Global Relationship Study.

• Gabe Monroy
• Kubernetes, container orchestration
• Portability
• Extensible
• Self healing
• Kubectl
• Etcd
• Kubelet, heart beat back to the API server
• Ingress
• Kube-proxy
• Lift and Shift application moving strategy, without refactoring your app
• Azure managed control plane
  • Devops project, Azure resource
  • Azure Dev Spaces ?
  • Helm chart ?
  • CI/CD pipelines
  • Key Vault is used to store secrets for Kubernetes
  • Vnet ?
  • Traffic Manager, in Azure
  • ACI ?, Azure Container Instances
• Azure Monitor for containers
• RBAC control for fine grained Kubernetes resources access control
• Scenarios
  • Lift and Shift to containers
  • Micro services
  • Machine Learning scenarios
  • IoT
    • Azure IoT Edge
• Maersk
  • NSAT, customer satisfaction
• Terraform
• CaaS
• OpenAI, a not for profit organization
• Azure IoT Edge

Open Neural Network Exchange is a format for deep learning models that allows interoperability between different open source AI frameworks.

ONNX is being co-developed as an open-source project by:

• Microsoft
• Amazon
• Facebook

https://en.wikipedia.org/wiki/Onnx

• Event Notification pattern
• Tight coupling prevention in the design
• Eg adding a queue between the order module and the shipping module
• System becomes more resilient
• Events should have as much context around then as they can
• Event sourcing pattern, writing the events to a log
  • Audit History
  • Decoupling
  • Materialized views
  • Integration with other systems
  • Teleporting ?
• Microservices
• Fault tolerance
• Functions can be triggered based on an event

• Azure CosmosDB
• RU: Request Unit
• Five consistency models ?
• A multi model database, key value, column family, documents, graph
• ARS, Atomic Record Sequence
• Schema agnostic
• Change Feed: log updates or others
  • Triggers for Azure Functions
  • Stream Processing
  • Data Movement, moving the data downstream
• Multiple consumers of the change feed

• Azure Functions
  • Bindings and Triggers
  • Proxies
  • Monitoring
  • Local Debugging
  • CI/CD
  • Doable Functions, will save their own states
• Azure Event Grid
  • Event handlers: Functions, etc
• Use the Change Feed to light up your micro services architecture
• Jet.com uses micro services on CosmosDB and Azure Event Grid
• Skype as well
• CQRS

• Roadmap
  • Q2, had public preview
  • Q3, GA
  • Q4
• Scale with backplane with Redis etc
• Azure Function binding, in preview
• For GA, Free Tier and standard
• Auto Scaling... ??
• Scenarios
  • In app notifications
  • Live dashboard
  • Co authoring
• It's realtime messaging
• An Azure resource
• dotnet build; dotnet run;
• Azure SignalR Service on asp.net Core SignalR
• Hub base class
• First negotiates. If configured to use Azure SignalR service, it returns negotiation points on Azure.

• Rest API
  • Gyro tracker demo
• Azure Function binding for SignalR Service

• 12 Factor

• Mongoose SDK Node.js sdk
• Develop locally with MongoDB
• Switch to CosmosDB in the cloud
  • Choose MongoDB api for CosmosDB
• Make app cloud ready

• dotenv package ??
• VS Code, Ctrl+shift B, run commands

• LiveTiles Bots
• Scenarios
  • Personal Assistant
  • Team Assistant
  • Enterprise Assistant
  • External Assistant
• What's a typical development cycle?
• Site application as a service as a bot!!
• QnA Maker
• LiveTiles Bot designer
• AIconics ?
• EthicalOS.org

• git push origin master:demo
  • If you forget to create a branch before pushing code remotely
• Branch policies
  • Require PR
  • Item linking
• Build Validation policy
  • Build must pass before merge into branch/master
• Checkout pull requests locally ??
• Continuous Code Quality with Automation
  • Static code analysis
    • sonarqube/sonarcloud.io
    • whitesource, security scanning
  • Drop these into pipeline
• Git Large File Support
  • Git LFS
  • Instead of shallow cloning
  • BFG Repo Cleaner ??
• Always use the latest version of Git
  • git update
• Trunk-based development
  • GitHub flow is different that Release flow branching structure
  • master is never in production?? Why?
  • Cherry pick a Pull request into a new branch