e-lo:Engineer log out. > Home > Sql
mysql Sql

Understanding the changes in the Root CA change for Azure Database for MySQL single server (SSL)

/

https://learn.microsoft.com/en-us/azure/mysql/single-server/concepts-certificate-rotation#create-a-combined-ca-certificate They changed supplier Download new cert from link and edit in your connection string Connect with HeidiSQL and check version That is if ssl in enforced in mysql for single server and version is selected, i.e 1.2 in Azure. Note This article applies to Azure Database for MySQL – Single Server ONLY. For Azure […]

,

Understanding the changes in the Root CA change for Azure Database for MySQL single server (SSL) Read Post »

Sql

Normalization

/

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

Normalization Read Post »

Azure Monitoring mysql Sql

Zabbix on VM remote MySql (Na market)

/

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

Zabbix on VM remote MySql (Na market) Read Post »

Sql

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

SQL Server Data Manipulation Read Post »

octopus Sql

MS SQL Server 2016 Express with SSMS

/

Update, get the one with localdb SQL Server Express LocalDB – SQL Server | Microsoft Learn Then get SSMS Then you can connect: Choose master on options 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

,

MS SQL Server 2016 Express with SSMS Read Post »

Linux Python Sql

MariaDb linux Python ORM

/

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

MariaDb linux Python ORM Read Post »

Sql

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

/

‘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

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

Python Sql

PostgreSql jsonb

/

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

PostgreSql jsonb Read Post »

Github Sql

Django database API migrations and models 101

/

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

Django database API migrations and models 101 Read Post »

Scroll to Top