.::: Check Table Capacity & Size Report SQL Server on LocalServer & Linked Server (Open Query) :::.

A. Access Local Server
1. Check Database_ID
select @@Servername as LocalServer,@@servername as ServerName_Link, name as dbname,database_id  from sys.databases
select @@Servername as LocalServer,@@servername as ServerName_Link, name as dbname,database_id  from sys.databases where name = 'teguhth';

.::: Study Kasus Praktis belajar Query create & insert table/Collection MongoDB (Data Warehouse) :::.

1. Create Database teguhth
use teguhth
show dbs 

log 
> use teguhth
switched to db teguhth
> show dbs
admin   0.000GB
brgxxx  0.000GB
config  0.000GB
kampus  0.000GB
local   0.000GB
toko    0.000GB
>

.::: Tutorial MongoDB, create Database & Collection (table) nosql :::.

C:\Users\teguh>cd "c:\Program Files\MongoDB\Server\4.4\bin"

.::: Database size & Table Capacity in MySQL MariaDB :::.

https://teguhth.blogspot.com/2020/12/database-size-table-capacity-in-mysql.html
http://teguhth.blogspot.com/2022/08/create-store-procedure-for-database.html
https://teguhth.blogspot.com/2022/08/create-event-scheduler-to-run-query.htm

A. Create database nms tools ;

create database teguhthtools;
use teguhthtools;

MariaDB [(none)]> use teguhthtools;
Database changed
MariaDB [teguhthtools]>

B. table Database size capacity

1. query database size capacity
 

.::: Steps for Installing SQL Server AlwaysOn Availability Groups :::.

SQL Server 2012's new features and enhancements include Always On SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new spatial features, metadata discovery, sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and partition level operations and security enhancements including provisioning during setup, new permissions, improved role management, and default schema assignment for groups.

.::: How to remove and add replica, database, listener on AlwaysOn MSSQL Server :::.

SQL Server 2012's new features and enhancements include Always On SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new spatial features, metadata discovery, sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and partition level operations and security enhancements including provisioning during setup, new permissions, improved role management, and default schema assignment for groups.

1. Avaibility Databases
Remove >>Availability Databases >> Remove Database From Availability Group

.::: Sript multiple dig domain (DNS) using Script :::.

1. Sample host
[root@server-teguht teguht]# cat hostdomain.txt
www.example.com
example.com
a.example.com
aaa.example.com
aaaa.example.com
example.com
info.example.com
cname.example.com
examplealias.example.com
[root@server-teguht teguht]#

.::: Study Kasus Praktis belajar Query create & insert table Postgress SQL (Create Data Warehouse) include via CLI & GUI :::.

1. Create database using query or GUI

CREATE DATABASE tgh

WITH

OWNER = postgres

ENCODING = 'UTF8'

LC_COLLATE = 'English_United States.1252'

LY_TYPE = 'English_United States.1252'

TABLE_SPACE = pg_default

CONNECT LIMIT = -1 ;

GRANT CREATE, CONNECT ON DATABASE tgh TO postgres;

GRANT TEMPORARY ON DATABASE tgh TO postgres WITH GRANT OPTION;

GRANT TEMPORARY, CONNECT ON DATABASE tgh TO PUBLIC ;

.::: How To Install Cursor and PowerAdmin for powerDNS :::.

after install powerdns as http://teguhth.blogspot.com/2019/08/how-to-install-powerdns-and-poweradmin.html now install poweradmin

1. Installing PowerAdmin to Manage PowerDNS
[root@powerdns-teguht ~]# yum -y install httpd php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext

2. Install additonal package
[root@powerdns-teguht ~]# yum -y install php-pear-DB php-pear-MDB2-Driver-mysqli

.::: How to Install PowerDNS and Poweradmin on CentOS 7 :::.

PowerDNS (pdns) is an open source DNS server written in C++ and released under GPL License. It has become a good alternative for the traditional DNS server Bind, designed with better performance and low memory requirements. PowerDNS provides two products, the Authoritative server, and the Recursor. The PowerDNS Authoritative server can be configured through the different backend, including the plain Bind zone files, RDBMS such as MySQL, PostgreSQL, SQLite3 or LDAP.

1. Disable /allow firewall, selinux and add hosts
[root@powerdns-teguht data]# systemctl stop firewalld
[root@powerdns-teguht data]# systemctl disable firewalld
rm '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'
rm '/etc/systemd/system/basic.target.wants/firewalld.service'
[root@powerdns-teguht data]#

.::: Block a domain using RPZ on Bind DNS server on CentOS 7 Redhat 7 8 9 :::.

Domain Name Service Response Policy Zones (DNS RPZ) is a method that allows a nameserver administrator to overlay custom information on top of the global DNS to provide alternate responses to queries. It is currently implemented in the ISC BIND nameserver (9.8 or later). Another generic name for the DNS RPZ functionality is "DNS firewall".

1. Create zone for block using RPZ

[root@server-teguht ~]# cat /var/named/rpz.db

$TTL 1D

@    IN SOA ns1.example.com. root.example.com. (

                                        0      ;   serial

                                        1D     ;   refresh

                                        1H     ;   retry

                                        1W      ;  expire

                                        3H )     ; minimum

.::: Join Domain Active Directory on Centos 7 / Redhat 7, 8, 9 :::.

In Most of the Organizations users and groups are created and managed on Windows Active Directory.  We can integrate our RHEL 7 and CentOS 7 servers with AD(Active Directory) for authenticate purpose. In other words we can join our CentOS 7 and RHEL 7 Server on Windows Domain so that system admins can login to these Linux servers with AD credentials. While creating UNIX users on AD we can map these users to a specific group so that level of access is controlled centrally from AD

1. Install Package realmd, sssd, samba dan kerberos
[root@radius-teguht ~]# yum install sssd realmd oddjob oddjob-mkhomedir adcli samba-common samba-common-tools krb5-workstation openldap-clients policycoreutils-python -y

 

centos 9

yum install sssd realmd oddjob oddjob-mkhomedir adcli samba-common samba-common-tools krb5-workstation openldap-clients policycoreutils-python-utils -y

2. additional IP, domain, hostname on /etc/hosts , and /etc/resolv.conf

[root@radius-teguht ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
10.10.10.102 radius-teguht
10.10.10.110  ad ad.teguht.com
[root@radius-teguht ~]#

.::: How to Install Webmin on CentOS/Redhat 7, 8, 9 :::.

Webmin is a web-based interface for system administration for Unix. Using any modern web browser, you can setup user accounts, Apache, DNS, file sharing and much more. Webmin removes the need to manually edit Unix configuration files like /etc/passwd, and lets you manage a system from the console or remotely. See the standard modules page for a list of all the functions built into Webmin.

1. download
[root@server /]# wget http://prdownloads.sourceforge.net/webadmin/webmin-1.920-1.noarch.rpm