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 […]