ส่วนตัวครับ
#FOR BACKUP BACKUP DATABASE [DBNAME] TO DISK = N’D:\BackUp\Full_DBNAME_comp.bak’ WITH COMPRESSION GO BACKUP DATABASE [DBNAME] TO DISK = N’D:\BackUp\Full_DBNAME_diff.bak’ WITH COMPRESSION, DIFFERENTIAL GO #FOR RESTORE USE master; GO RESTORE DATABASE …
MSSQL Command Reference Read MoreSteps to configure Remote SSL VPN in FortiGate with CLI Create a ssl.root interface for SSL VPN Tunnel config system interface edit “ssl.root” set vdom “root” set type tunnel set …
Configure Remote SSL VPN in FortiGate with CLI Read MoreThis is an update to an earlier tutorial I wrote, GeoIP Blocking which worked for Ubuntu 16.04LTS and 18.04LTS, but apparently not with Ubuntu 20.04LTS. The included version of the …
GeoIP Blocking Ubuntu Read MoreIn this guidance, I am using CentOS 7 with kernel 3.10 and xtables-addons 2.14. The latest release of xtables-addons when this article was written is version 3.9. However, the kernel …
How to Block Access Based on GeoIP on CentOS 7 [iptables] Read MorePlacement Groups A preselection of pg_num When creating a new pool with: ceph osd pool create {pool-name} pg_num it is mandatory to choose the value of pg_num because it cannot …
Jewel Ceph (PG) Read Moredownload wget https://docs.broadcom.com/docs-and-downloads/raid-controllers/raid-controllers-common-files/8-07-14_MegaCLI.zip or curl -LO https://docs.broadcom.com/docs-and-downloads/raid-controllers/raid-controllers-common-files/8-07-14_MegaCLI.zip unzip unzip 8-07-14_MegaCLI.zip install package For Debian cd Linux sudo alien MegaCli-8.07.14-1.noarch.rpm # convert from rpm to deb first sudo dpkg …
Install MegaCli in Linux Read MoreShow Logical disk MegaCli -LDinfo -Lx -aN Show all Physical disk MegaCli -PDList -aN Delete Raid MegaCli -CfgLdDel -Lx -aN Make JBOD MegaCli -PDMakeJBOD -PhysDrv[Encrosure:diskID] -aN Check Disks Status # …
Megacli Cheat Sheet Read MoreThis article is a Work in Progress, and may be unfinished or missing sections. Using rsync to migrate from an old ZCS mailstore to a new ZCS mailstore can be …
ZCS to ZCS rsync Migration Read MoreIn this ZFS training/tutorial series,this article will talk about ZFS performance issues.If you didn’t tune the system according to the application requirement or vise-verse,definitely you will see the performance issues.For …
ZFS – ZPOOL Cache and Log Devices Administration Read MoreHow to prevent spam on zimbra. To use zimbra spamassassin filter. To backlist and whitelist all email from address or domain. To spam-check mail incoming email to system your email …
zimbra custom spamassassin rules Read More