Skip to content
Menu
e-lo [IT Engineer life]
  • Home
    • Note
  • Database
    • T-SQL
    • SQL Server quick
    • SQL server docs
    • MySql quick sheet
    • Postgre
    • InfluxDB
  • Programming
    • MS Azure Powershell
    • MS Azure Command-Line Interface (CLI) doc
    • Python Docs
    • Python Logging
    • Python-cheat-sheet
    • Git-guide
  • Azure
    • MS Windows virtual machines in Azure
    • MS ARM Docs
    • MS ARM Template Docs
    • MS ARM Functions
    • MS Bicep+ARM
    • MS ARM Tutorial
    • MS Deployment scripts (intern/extern)
    • MS Virtual Network
  • Az-nutshell
    • ms-technology-choices-compute-decision-tree
    • ms-data-store-decision-tree
    • ms-data-explorer
    • ms-storage-explorer
    • ms-azure-sql
    • ms-common-data-services
    • ms-azure-mysql-daas
    • ms-sla
    • az paas
    • az glossary-quicksheet
    • az-test-vm-script-quickguide
  • Linux
    • Top CMD’s
    • Useful CMD Linux
    • ss64 Linux
    • Ubuntu
    • 30 things Ubuntu 18.04
    • Bootable Ubuntu USB
    • LinuxFilesystemTreeOverview
  • Sys Admin
    • System Administrator
    • Sys News
  • Zen
    • Not thinking about anything is Zen
e-lo [IT Engineer life]

Category: Sql

Normalization

Posted on December 8, 2020August 23, 2021 by espenk

https://vertabelo.com/blog/how-to-remember-database-normal-forms/ Normal Forms: A Recap The key, the whole key, and nothing but the key, so help me Codd. The key stands for 1NF: all tables must have a (primary) key because all records in the table must be unique.The whole key stands for 2NF: no functional dependencies on part of the key are allowed.Nothing…

+

Zabbix on VM remote MySql (Na market)

Posted on October 13, 2020October 15, 2020 by espenk

Lets continue and install Zabbix on a VM and MySql on another: BasicsSubscriptionFree TrialResource groupzabbix-rgVirtual machine namevm-zabbixRegionWest USAvailability optionsNo infrastructure redundancy requiredImageUbuntu Server 18.04 LTS – Gen1SizeStandard DS1 v2 (1 vcpu, 3.5 GiB memory)Authentication typePasswordUsernameespentestPublic inbound portsSSHAzure SpotNoDisksOS disk typeStandard HDDUse managed disksYesUse ephemeral OS diskNoNetworkingVirtual network(new) zabbix-rg-vnetSubnet(new) default (10.0.0.0/24)Public IP(new) vm-zabbix-ipAccelerated networkingOffPlace this virtual…

+

OD20761C – Querying Data with Transact-SQL

Posted on May 25, 2020August 3, 2020 by espenk

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…

+

SQL Server Data Manipulation

Posted on April 1, 2020April 29, 2020 by espenk

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

Posted on February 27, 2020October 7, 2020 by espenk

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…

+

MariaDb linux Python ORM

Posted on October 24, 2019October 25, 2019 by espenk

https://linuxize.com/post/how-to-install-mariadb-on-ubuntu-18-04/ MariaDB is an open source, multi-threaded relational database management system, backward compatible replacement for MySQL. It is maintained and developed by the MariaDB Foundation including some of the original developers of the MySQL. https://linuxize.com/post/how-to-create-a-sudo-user-on-ubuntu/ sudo apt update sudo apt install mariadb-server sudo mysql -V sudo systemctl status mariadb Run the mysql_secure_installation command to improve…

+

8 Ways to Fine-tune your SQL Queries (for production databases)

Posted on February 26, 2019February 26, 2019 by espenk

‘Sanitization’ is the removal of malicious data from user input, such as form submissions or maybe more simply… The cleaning of user input to avoid code-conflicts (duplicate ids for instance), security issues (xss codes etc), or other issues that might arise from non-standardized input & human error/deviance. Define Business Requirements before Beginning Write very specific…

+

PostgreSql jsonb

Posted on February 4, 2019 by espenk

https://www.postgresql.org/docs/9.4/datatype-json.html JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 7159. Such data can also be stored as text, but the JSON data types have the advantage of enforcing that each stored value is valid according to the JSON rules. There are also assorted JSON-specific functions and operators available…

+

Django database API migrations and models 101

Posted on August 8, 2018November 4, 2018 by espenk

Django API Once you’ve created your data models, Django automatically gives you a database-abstraction API that lets you create, retrieve, update and delete objects. This document explains how to use this API. Refer to the data model reference for full details of all the various model lookup options. https://docs.djangoproject.com/en/2.0/topics/db/queries/ So our testmodel is a simple…

+

Grafana with Postgresql and MS SQL (2020)

Posted on July 30, 2018December 16, 2020 by espenk

Grafana https://grafana.com/ The open platform for beautifulanalytics and monitoring.The leading open source software for time series analytics I used:4.6.0-beta2, the reason for that was to test Postgresql data source function that just came out for about 6-12 months ago. https://grafana.com/grafana/download/4.6.0-beta2?platform=windows Getting started http://docs.grafana.org/guides/getting_started/ Start Grafana: Navigate to http://localhost:3000 Grafana Dashboard: In PostgreSql, make a table…

+

RSS Azure

  • Scale your cloud-native apps and accelerate app modernization with Azure, the best cloud for your apps May 24, 2022

RSS RabbitMQ

  • RabbitMQ 3.8.15 release

RSS Python

  • PEP 691: JSON-based Simple API for Python Package Indexes May 4, 2022

Tags

5 min (26) Ansible (1) ARM (10) azure (40) cmd (3) Django (4) Docker (1) e-lo (2) Flask (2) Github (9) Grafana (2) Information (7) Information Retrieval (13) JAVA (1) kivy (2) Kotlin (6) linux (15) mobile (2) Natural Language Prossesing (NLP) (2) Net.Core (1) Networking and Security (6) OPC (2) PEP8 (1) Philosophy (3) Python (47) Python Networking and Security (5) Reason (2) RMQ (3) Solr (11) Sql (10) Uncategorized (2) VSC (1) Warframe (2) WMVARE (4) Zabbix (7)

Recent Posts

  • 5 min Logic App Storage Table
  • 5 min Logic App PSQL
  • 5 min Logic App
  • 5 MIN Azure Data Explorer
  • TODO Build a Hash Table in Python With TDD Real Python

Archives

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Photo by Markus Spiske from Pexels "Matrix"

©2022 e-lo [IT Engineer life] | Powered by WordPress & Superb Themes