jsheridanwells

MS SQL Server 2016

Desde aqui.

SQL Server configuration manager:

• Found here: C:\Windows\SysWOW64\SQLServerManager14.msc

• Mostly used for starting and stopping and determining if it starts automatically or not.

jsheridanwells

C# Design Patterns

Desde aqui.

Categories

Creational: Concerned w/ creating objects

• Abstract
• Factory - define an interface for creating an object, let subclasses decide which class to instantiate.

jsheridanwells

DevOps For DB w/ VSTS and Azure

Desde Aqui

SSDT

Relational DB Project - Analysis Service Project - Reporting Services Project - Integration Service Project

(Supports cloud and on-prem)

GUI Tools

jsheridanwells

Windows Server 2016: Install and Config

Desde Aqui.

Shutting Down Command

# /s means server, /c means comment
> shutdown /s /c "This is my reason for shutting down"

jsheridanwells

Deploying_to_on-prem-in-AzureDevOps

desde aqui e tambem aqui

Set Up Build

An ASP.NET template works -

• Use NuGet
• NuGet Restore

jsheridanwells

# GENERAL

alias c='clear'
alias ca='clear &&'
alias la='ls -la'

# GIT ALIASES
alias g='git'
alias gs='git status'
alias ga='git add'

jsheridanwells

1. Create public and private RSA keys (public.key, private.key). Generate them here.
2. npm install --save-dev jsonwebtokens json-server faker
3. create users.json with at least email and password for a fake user.
4. Add these to package.json (assumes code is in a directory called api):

    "api-noAuth": "node_modules/.bin/json-server api/seed.js",
    "api-auth": "node ./api/server.js",
    "api-seed": "node ./api/seed.js > api/db.json"

1. npm run api-seed will create db.json, npm run api-noAuth is just the api npm run api-auth will create and require tokens.

jsheridanwells

Blueprints

A typical setup:

app_dir/
  manage.py
  application.py
  module_dir/
    views.py

jsheridanwells

# bash
$ echo 'export const apiKey = "<YOUR OPEN WEATHER MAP API KEY>";' >> javascripts/apiKey.js

jsheridanwells

# bash

$ dotnet new webapi -o WeatherWalkingSkeleton