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
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-MicrosoftAzureAdministrator
Module 01 – Identity 01 – Manage Azure Active Directory IdentitiesModule 02 – Governance and Compliance 02a – Manage Subscriptions and RBACModule 02 – Governance and Compliance 02b – Manage Governance via Azure PolicyModule 03 – Azure Administration 03a – Manage Azure resources by Using the Azure PortalModule 03 – Azure Administration 03b – Manage…
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
Download: https://www.microsoft.com/en-us/download/confirmation.aspx?id=56840 Install also the SSMS tool 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 databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your…
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…
Docker-compose ubuntu
Install it from here, the two first lines https://get.docker.com/ curl -fsSL https://get.docker.com -o get-docker.sh sh get-docker.sh docker –version Compose is a tool for defining and running multi-container Docker applications. With Compose, you use a YAML file to configure your application’s services. Then, with a single command, you create and start all the services from your…
PEP 8
Programming Recommendations https://www.python.org/dev/peps/pep-0008/#programming-recommendations Use is not operator rather than not … is. While both expressions are functionally identical, the former is more readable and preferred. Always use a def statement instead of an assignment statement that binds a lambda expression directly to an identifier. Derive exceptions from Exception rather than BaseException. Direct inheritance from BaseException…
Python debugging in VS Code
Debugging 101 https://github.com/microsoft/vscode-recipes/tree/master/debugging%20python We need VSC, Python extension and a launch.json with the minimum of integrated and external. The launch.json Debug->Open configurations Ok, let’s run a script and test it. F5 is for run, F10 is for step into. We are going to test Python set functions, union and intersection. The breakpoint will be at…