.::: Change Mirror Server Instance to Single User/Server on SQL Server 2012,2014,2016 :::.

1. Open SQL using SQL Management Studio

2. Open Mirror Server Instance and query and execute
alter database teguhtrihartodb set partner off
go
restore database teguhtrihartodb with recovery
go

3. expand Database on SQL Management Studio

.::: Install MySQL 56 On Linux Rhel/Centos using RPM/Offline :::.

1. Download rpm instalation from http://dev.mysql.com/downloads/mysql/ as sample
MySQL-server-5.6.34-1.el6.x86_64.rpm
MySQL-client-5.6.34-1.el6.x86_64.rpm 
MySQL-devel-5.6.34-1.el6.x86_64.rpm

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.34-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.34-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-devel-5.6.34-1.el6.x86_64.rpm

.::: How To Check Serial Number Machine On Windows, Linux, Solaris :::.

Cheng Xiao

A serial code is a unique identifier assigned incrementally or sequentially to an item. It is also called a serial number, although it may be a character string that includes letters and other typographical symbols, not just numerical digits.

1. Check Serial number linux machine
# dmidecode -t system
[root@cpam /]# dmidecode -t system
# dmidecode 2.12
SMBIOS 2.4 present.

.::: Troubleshoot Cannot Run Command df, df -kh Hang on Redhat/Rhel, Linux, FreeBSD :::.

This  manual page documents the GNU version of df.  df displays the amount of disk space available on the file system containing each file name argument.   If  no  file  name  is given, the space available on all currently mounted file systems is shown.  Disk  space  is  shown  in  1K  blocks  by default,  unless the environment variable POSIXLY_CORRECT is set, in which case 512-byte blocks are used.

If an argument is the absolute file name of a disk device node  containing a  mounted  file  system, df shows the space available on that file system rather than on the file system containing the device node (which is always the root file system).  This version of df cannot show the space available on unmounted file systems, because on  most  kinds  of  systems  doing  so requires very nonportable intimate knowledge of file system structures.

     

1. User root cannot run command df -kh

[root@TEGUHTH ~]# df -kh

^C ^C

[root@TEGUHTH ~]# ^C

.::: Troubleshoot Cannot Run Command df, df -kh Hang on Redhat/Rhel, Linux, FreeBSD :::.

This  manual page documents the GNU version of df.  df displays the amount of disk space available on the file system containing each file name argument.   If  no  file  name  is given, the space available on all currently mounted file systems is shown.  Disk  space  is  shown  in  1K  blocks  by default,  unless the environment variable POSIXLY_CORRECT is set, in which case 512-byte blocks are used.

If an argument is the absolute file name of a disk device node  containing a  mounted  file  system, df shows the space available on that file system rather than on the file system containing the device node (which is always the root file system).  This version of df cannot show the space available on unmounted file systems, because on  most  kinds  of  systems  doing  so requires very nonportable intimate knowledge of file system structures.

     

1. User root cannot run command df -kh

[root@TEGUHTH ~]# df -kh

^C ^C

[root@TEGUHTH ~]# ^C

.::: How to Upgrade RHEL/Redhat/Centos 6.5 / 6.x to rhel 6.6 from ISO file :::.

after we know about linux, sometimes we must know where location the package installer it’s. this time we will discuss about how to setting local repository, what is the repository? repository is a group of linux installer package that stored in a server that can be accessed via Internet or intranet, now how about someone who want install package and they don’t have internet connection. for detail about repository will discussed later, now we will explain how to setting repository from cdrom . this is following step to setting local repository from ISO file :

1. copy iso file to /data/
    rhel-server-6.6-x86_64-dvd.iso
2. create directory /mnt
   # mkdir mnt
   # chmod -R 777 mnt

.::: How to Setting Local Repository RHEL/Redhat/Centos from ISO file :::

after we know about linux, sometimes we must know where location the package installer it’s. this time we will discuss about how to setting local repository, what is the repository? repository is a group of linux installer package that stored in a server that can be accessed via Internet or intranet, now how about someone who want install package and they don’t have internet connection. for detail about repository will discussed later, now we will explain how to setting repository from cdrom . this is following step to setting local repository from ISO file :

1. copy iso file to /data/
    rhel-server-6.6-x86_64-dvd.iso
2. create directory /mnt
   # mkdir mnt
   # chmod -R 777 mnt

.::: How to Setting Local Repository RHEL/Redhat/Centos from CDROM :::.

after we know about linux, sometimes we must know where location the package installer it’s. this time we will discuss about how to setting local repository, what is the repository? repository is a group of linux installer package that stored in a server that can be accessed via Internet or intranet, now how about someone who want install package and they don’t have internet connection. for detail about repository will discussed later, now we will explain how to setting repository from cdrom . this is following step to setting local repository from cdrom :

Modul Purpose : Understand how to setting local repository with DVD RHEL 6.3

1. Open Desktop console to mount DVD room

.::: Enable VNC Server on Redhat, Rhel/Centos :::.

Virtual Network Computing (VNC) is a graphical desktop sharing system that uses the Remote Frame Buffer protocol (RFB) to remotely control another computer. It transmits the keyboard and mouse events from one computer to another, relaying the graphical screen updates back in the other direction, over a network.

1. Install patch tigervnc-server
  # yum install tigervnc-server

.::: How to Customize CSS in Blogspot :::.

The Blogger Template Designer allows you to insert custom CSS code to change your blog's appearance. You can access the advanced settings of the Template Designer to change all design elements of your blog, including the page layout, background, links and more. You can safely tweak your blog's design by using custom CSS code, as it will not alter your blog's core HTML design. Make any necessary changes to your blog's CSS code in the future from the same location in the Blogger Template Designer

Step 1

Open your browser and go to Blogger.com

.::: Display Image Link Preview on Hover :::.

Preview web
Image Undangan

Web Undangan

<p id="p1"><a href="http://ratna-dan-teguh.blogspot.co.id/">Web Undangan</a></p>
<p id="p2"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4CG1cpDkGzaNLWn5SEa2p4YnJCMPPoc5n5PDB35FjSuykKtXa0Dyu9CAR7MI5PxFZpksvLIKcKGMQnB_rkiX-T6fMEHIj7zREkAUjaWjvgNNIzvyRS9Ny_d_oXcVA4E5WVOYXOzBB8Fr4/s1600/UNDANGAN_RATNA_TEGUH.jpg">Image Undangan</a></p>
<p id="p3"><a href="http://teguhth.blogspot.co.id/">Learning Centre</a></p>


<script src="http://ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
  <link href="http://codegena.com/assets/css/image-preview-for-link.css" rel="stylesheet">     
  <script type="text/javascript">
    $(function() {
                $('#p1 a').miniPreview({ prefetch: 'pageload' });
                $('#p2 a').miniPreview({ prefetch: 'parenthover' });
                $('#p3 a').miniPreview({ prefetch: 'none' });
            });
  </script> <script src="http://codegena.com/assets/js/image-preview-for-link.js"></script>

id="p1" - Fetch image preview on page load.
id="p2" - Fetch preview on hover.
id="p3" - Fetch preview image each time you hover.

.::: .::: Additional OIS/MIB on Rhell/Redhat/Centos7 or Why SNMP is unable to query the interface, disk, memory, and CPU information in Red Hat Enterprise Linux? :::.

SNMP, or Simple Network Management Protocol, is widely used to communicate with and monitor network devices, servers, and more, all via IP. In this case, we’ll be installing an SNMP agent on a CentOS 6.5 server, which will allow for collection of data from our server, and make the information available to a remote SNMP manager.

1.    Make sure package net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python
   # yum install net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python
   # rpm -q net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python
2.  Go to your product manufacturer and download the product's MIB & activation MIB/add MIB UCD-SNMP-MIB<cpu memory example>
3. Rename the mib to UCD-SNMP-MIB.txt
4. Copy the MIB inside /usr/share/snmp/mibs/
5.    Edit /etc/snmp/snmp.conf

.::: Simple Configuration Enable SNMP on Centos 6 & Centos 7 :::.

SNMP, or Simple Network Management Protocol, is widely used to communicate with and monitor network devices, servers, and more, all via IP. In this case, we’ll be installing an SNMP agent on a CentOS 6.5 server, which will allow for collection of data from our server, and make the information available to a remote SNMP manager.

1.    Make sure net-snmp utilitas package on centos7
  # yum install net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python
  # rpm -q net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python