I am a CTO with over 5 years of experience in start-up and over 10 years in working at managing position for big companies. I am also a full-stacks developer with over 12 years in system design, product development and technology product deployment.User experience and system security are the things I care about most.

Author: tran.travis

  • Home
  • Tran.travis - Travis Tran - Page 15 Of 16

Articles By This Author

Log Rotation 1

Log Rotation

  • tran.travis
  • July 27, 2019
  • 2 min read

Linux script rollback log by interval.

log-rotation.sh

Read More
Install Gnome 3 GUI on RHEL CentOS 1

Install Gnome 3 GUI on RHEL, CentOS

  • tran.travis
  • July 27, 2019
  • 1 min read

Kiểm tra yum package đã có sẵn gói cài đặt giao diện hay chưa bằng lệnh:

sudo yum group list

Cài đặt gói giao diện:

sudo yum -y groupinstall "GNOME Desktop" "Graphical Administration Tools"
sudo ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target

Read More
Open port for SQL Server remote connection 1 1

Open port for SQL Server remote connection

  • tran.travis
  • July 27, 2019
  • 2 min read

Ports and protocols used by Microsoft SQL Server database engine (SQLServer).

About this task

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) which is used by Microsoft. You need to allow distant users to connect to the SQL server so they can address it their queries.
SQL Server is used by:

Read More
Open port for SQL Server remote connection 1

Open port for SQL Server remote connection

  • tran.travis
  • July 27, 2019
  • 2 min read

Ports and protocols used by Microsoft SQL Server database engine (SQLServer).

About this task

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) which is used by Microsoft. You need to allow distant users to connect to the SQL server so they can address it their queries.
SQL Server is used by:

Read More
Restoring database from .mdf and .ldf files of SQL Server 2008 1 1

Restoring database from .mdf and .ldf files of SQL Server 2008

  • tran.travis
  • July 27, 2019
  • 1 min read

  1. First Put the .mdf and .ldf file in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATA folder
  2. Then go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box
  3. Click the “Add” button to open and Locate Database Files From C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAfolder
  4. Click the “OK” button. SQL Server Management Studio loads the database from the .MDF file.

Read More
Solving SQL Server Connection Problem 1

Solving SQL Server Connection Problem

  • tran.travis
  • July 27, 2019
  • 6 min read

Inspect Server Settings

There are three significant aspects that users may neglect, which lead to the failure of the connection to the SQL Server.

Enable TCP/IP Connection

To check whether your server enabled to TCP/IP connections:

Read More
Uninstall Oracle DB on Windows completely 1

Uninstall Oracle DB on Windows completely

  • tran.travis
  • July 27, 2019
  • 1 min read

Manually

  1. START -> RUN -> Services.msc
  2. Locate all Ora* services & click on STOP
  3. Start -> RUN -> Regedit
  4. Locate HKEY_LOCAL_MACHINE folder in the registry
  5. Open Software folder
  6. Delete the Oracle folder under Software
  7. Open System folder in HKEY_LOCAL_MACHINE
  8. Open CurrentControlSet folder within the System folder
  9. Open Services
  10. Delete all keys related to Oracle. Every key starts with “ORA..”
  11. Close the regedit
  12. Delete ORACLE_HOME folder
  13. Delete the Oracle folder in Program Files
  14. Reboot

Uninstall all Oracle components using the Oracle Universal Installer (OUI).

Read More
Oracle DB Grant Privilege on all objects in a Schema to a user 1

Grant privilege on all objects in a Schema to a user in Oracle Database

  • tran.travis
  • July 27, 2019
  • 3 min read

In this example I have given select on all tables in schema test1 to user test2. As well grant all DML privilege on tables and views, and grant execute on procedures, functions and packages in a schema test1 to user test2.

SQL> create user test1 identified by test1;
User created.
SQL> grant connect,resource to test1;
Grant succeeded.
SQL> create user test2 identified by test2;
User created.
SQL> grant connect,resource to test2;
Grant succeeded.
SQL> conn test1/test1
Connected.
SQL> create table test_table1(id number,name varchar2(30));
Table created.
SQL> create table test_table2(id number,name varchar2(30));
Table created.
SQL> show user;
USER is "TEST1"

If you want to grant select privilege:

Read More