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
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
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
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
OD20761C – Querying Data with Transact-SQL 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