Tech-Today
- How To Enable Jmxremote Authentication And Connect With Jconsole
This tutorial will summarize how to setup a jmxremote access, so that a remote jconsole can be authenticated and connect. We will be interested in 2 files, located in: JAVA_HOME\jre\lib\management jmxremote.accessjmxremote.password.template, rename to jmxremote.passwordWhat...
- How To Alter The Sequence Value In Postgresql
This script will change the value of the sequence value, for example we have a table EMPLOYEE and sequence EMPLOYEE_SEQ: DROP SEQUENCE EMPLOYEE_SEQ_SEQ; CREATE SEQUENCE EMPLOYEE_SEQ_SEQ start with 2 increment by 1; The script will set the sequence to...
- Database Diagram Support Objects Cannot Be Installed Because This Database Does Not Have A Valid Owner
I encountered the error below when creating a diagram in the Management Studio. "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog...
- Mssql How To Update A Column Base On A Row Number
Just recently I was asked to normalized or divide a table into 2 tables. Unfortunately, the only column that linked them (email) allows multiple same values, even aggregate would not do (email, password, etc). This is because there's a field that...
- Mysql Engine: Myisam Vs Innodb
MyISAM (http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html) -to create a MyISAM table, add ENGINE = MYISAM; at the end of create table script -supports table locking (this is an issue when you need to backup the whole database) -fast execution...
Tech-Today
Table of Contents
- Mobile Development
- JavaEE Development
- Java Development
- CSharp Development
- Operating Systems
- Database
- Web Development
- Repository Management
- How To Enable Jmxremote Authentication And Connect With Jconsole
This tutorial will summarize how to setup a jmxremote access, so that a remote jconsole can be authenticated and connect. We will be interested in 2 files, located in: JAVA_HOME\jre\lib\management jmxremote.accessjmxremote.password.template, rename to jmxremote.passwordWhat...
- How To Alter The Sequence Value In Postgresql
This script will change the value of the sequence value, for example we have a table EMPLOYEE and sequence EMPLOYEE_SEQ: DROP SEQUENCE EMPLOYEE_SEQ_SEQ; CREATE SEQUENCE EMPLOYEE_SEQ_SEQ start with 2 increment by 1; The script will set the sequence to...
- Database Diagram Support Objects Cannot Be Installed Because This Database Does Not Have A Valid Owner
I encountered the error below when creating a diagram in the Management Studio. "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog...
- Mssql How To Update A Column Base On A Row Number
Just recently I was asked to normalized or divide a table into 2 tables. Unfortunately, the only column that linked them (email) allows multiple same values, even aggregate would not do (email, password, etc). This is because there's a field that...
- Mysql Engine: Myisam Vs Innodb
MyISAM (http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html) -to create a MyISAM table, add ENGINE = MYISAM; at the end of create table script -supports table locking (this is an issue when you need to backup the whole database) -fast execution...