Resource manger (RM) Infrastructure: VM’s, storage acc., vnet, web api, db etc. Deploy, monitor and manage all as a group with Azure Resource Manager Update, deploy, delete all with one operation Template for deploy for several environments, test, qa, prod RM has security, tagging, auditing Terminology Resource, item, vm, storage acc, db Resource group, container…
Author: espenk
Governance and Compliance 102
Region is an area, geographical containing on or more datacenters. Azure subscription, Logical unit of services linked to account, billing is by subscription, organize access to services. Azure accounts, account is identity in AD. Types of account, enterprise, resellers, partners, personal. Free, wont be charged before you upgrade. Cost Management Pay for what you use,…
AD 101
AD Concepts Identity, can be user, app, servers that need auth through cert or keys Account, an identity that has some data associated Azure AD Account, identity created through Azure AD Azure subscription, pays for cloud services Azure tenant, dedicated and trusted instance of Azure AD, automatically made when signs up for MS cloud subscription…
OD20761C – Querying Data with Transact-SQL
Database diagram used for some learning (Bikestore) The rest is here: https://github.com/spawnmarvel/t-sql https://github.com/spawnmarvel/t-sql In MSSM, on every object there it a property options, if you do some changes, you can press the script before the change is applied to get the SQL used. Run just portions of the query, mark the section and execute: docs…
Git pull request
https://opensource.com/article/19/7/create-pull-request-github Account donaldtest fork the repos from spawnmarvel: https://github.com/donaldtest/powershellcode git clone https://github.com/request-user/demo cd foldergit checkout -b new_branch git remote add upstream https://github.com/fork-user/demo Now you can make changes to the code. Once you push the changes to your repo, the Compare & pull request button will appear in GitHub. Click Compare & pull request Open a…
SS64 cmd/ ps reference
https://ss64.com/ CMD ARP – Address Resolution Protocol. View the contents of the local ARP cache table arp -a TRACERTTrace Route – Find the IP address of any remote host. TRACERT is useful for troubleshooting large networks where several paths can be taken to arrive at the same point, or where many intermediate systems (routers or…
AZ-104-MS Azure Administrator 101 quick ref
Ava Down pr year Month Week 90% 1-9 36.5 d 72 h 16.8 h 99% 2-9 3.65 d 7.2 h 1.68 h 99.9% 3-9 8.76 h 43.2 m 10.1 m 99.99% 4-9 52.56 m 4.32 m 1.01 m 99.999% 5-9 5.26 m 25.9 s 6.05 s 99.9999% 6-9 31.5 s 2.5 s 0.6 s Inbound…
SQL Server Data Manipulation
Version used here SQL Server Management Studio 15.0.18206.04 The following illustrates the BikeStores database diagram: 5 Load Sample Database After that data is loaded, you can make your own diagram, navigate like this: Go to Sql Server Management Studio >Object Explorer >Databases >Choose and expand your Database.Under your database right click on “Database Diagrams” and…
MS SQL Server 2016 Express with SSMS
Download MS SQL Server 2016 Express: https://www.microsoft.com/en-us/download/confirmation.aspx?id=56840 Install also the SSMS tool from the install, or download it from MS. https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and…
Azure SDK Pyhon
https://azure.github.io/azure-sdk/python_introduction.html Python Guidelines: Introduction: Design principlesIdiomaticConsistentApproachableDiagnosableDependablePython Design Principles:–PEP 20 — The Zen of Python, import this https://www.python.org/dev/peps/pep-0020/ General Guidelines: https://azure.github.io/azure-sdk/general_introduction.html Gitub: https://github.com/azure/azure-sdk-for-python Supported python versions:Code style: https://www.python.org/dev/peps/pep-0008/ Naming conventions: service_client = ServiceClient() service_client.list_things() def do_something(): class ThisIsCorrect(object): pass MAX_SIZE = 4711 database_module.py Method signatures: DO NOT use, static, do not use get set, use properties…