Thursday, November 23, 2017

Product Key Windows 10 for Activation via Phone

Windows 10 Phone Activation MAK-RETAIL Keys #Windows 10 MAK Keys capable to activate both Volume License & Retail Edition.# =========================================== Win 10 RTM Professional Volume:MAK slmgr.vbs -ipk N9M2T-MBJ4W-68KGB-Q2GCH-HXMQB ******************************************* Win 10 RTM Pro Retail slmgr.vbs -ipk GQT4N-87K8K-KGVP3-XXT8D-QRR9G slmgr.vbs -ipk J2JN2-MCTJ7-3RKVY-DCTR2-VFR9G slmgr.vbs -ipk JN87H-QT4CV-CBWBT-X7KCC-4RG6T slmgr.vbs -ipk JTFKT-RNVXX-4VY4G-RC4GQ-FM49G slmgr.vbs -ipk KY7NF-7QTPY-VMJQD-7TVHT-WXCKG slmgr.vbs -ipk M9XNB-MYQKK-2CCYH-C9WMQ-JTYP6 slmgr.vbs -ipk N2BF8-2KVXW-XYRHD-3PVPH-XD726 slmgr.vbs -ipk N2XYX-DMY3M-VB7PH-FXKX9-C7JXG slmgr.vbs -ipk N7TGG-G7BMJ-49Y88-PCKX3-2WF9G slmgr.vbs -ipk N84XF-6WK69-K3KXX-QC2W7-T3BP6 slmgr.vbs -ipk NFXVQ-2TJWJ-Q86HT-4VPT6-VCFC6 slmgr.vbs -ipk NH27R-YTMKJ-Q9TP4-GM4X3-63BP6 slmgr.vbs -ipk NK2PX-D47V4-3X3MX-2379V-6XXTT slmgr.vbs -ipk NMK43-JQVM3-7Q6KY-TX3MK-3RR9G slmgr.vbs -ipk NRHY2-34MRQ-PYCMT-B883W-J8F9G slmgr.vbs -ipk NXFX3-RH294-DGV3X-T7C8F-HQWXG slmgr.vbs -ipk P637D-VNBRD-WFR82-W2T99-WTYP6 slmgr.vbs -ipk QH74P-FNHYM-39MBG-42FQV-DRR9G slmgr.vbs -ipk QJNDC-6MKJB-QC3K2-XFKD6-MKMP6 slmgr.vbs -ipk QN3VX-H6T39-3W679-BVBGY-K766T slmgr.vbs -ipk RNJ7V-8M79J-YGW4Y-X8D2P-6JF9G ----------------------------- Win 10 RTM Pro N Volume:MAK slmgr.vbs -ipk RWR88-K7NYC-GK8FW-CC3XT-BP2KY ----------------------------- Win 10 RTM Pro N Retail slmgr.vbs -ipk P2TN-3TDW4-FQ8GV-WFK88-K2FDG ----------------------------- Win 10 RTM Enterprise Volume:MAK slmgr.vbs -ipk CY9JN-MJVG3-K2VFR-9CVWY-39MPF ------------------------------------------------------ Win 10 RTM EnterpriseS Volume:MAK ( Enterprise LTSB ) Product Key(s)---------------------------------Remaining Activation Counts Not available right now.! ------------------------------------------------------ Win 10 RTM EnterpriseSN Volume:MAK (Enterprise LTSB N) slmgr.vbs -ipk 84333-N23HF-CP6QV-DC9RT-P7JW9 ------------------------------------------------------ Win 10 RTM Education Volume:MAK Not available right now.! ******************************************* Win 10 RTM Education Retail Not available right now.! ------------------------------------------------------ Win 10 RTM Home Edition Retail Not available right now.! ------------------------------------------------------ [Tested working on VM3 14 March 2016] ================================================================================= More Info Windows 10 Phone-KMS Activation -- http://bit.ly/1mSpLRW Download Links Windows 10.0.10586 Version 1511 RTM MSDN -- http://bit.ly/1WQ1tV0 ================================================================================= Permanent Activation Windows 10 Via Phone ========================================= Step By Step Instruction: 1. Right click the start menu and choose "command prompt (admin)" 2. Type this script and hit Enter slmgr.vbs -ipk Product Key Example of Product Key: XXXXX-XXXXX-XXXXX-XXXXX-M98WY 3. You are still on "command prompt (admin)" ---- type: slui 4 4. Enter >> Select any country from the drop-down menu and click on Next. You will get Installation ID in this step 5. You will see some toll-free phone numbers which you can call. UK Free Call Skype Dial Number [+448000188354] l USA Free Call Skype Dial Number [+18007548300] l [url=https://www.microsoft.com/en-us/licensing/existing-customer/activation-centers.aspx]Worldwide telephone numbers[/url] l * Make sure have a microphone plugged into your PC in order for the dial pad to work ! * # If you don't have microphone plug in any JACK into your motherboard headphone port & use your soundbox to hear voice or Download & Install Skype for Mobile.# Full Skype conversation & respond the right answer to order to get successfully verification: Verification Numbers: For security reason please enter the following number using your touch-tone pad. == Dial the numbers using touch-tone pad robot speaker has given to you.=== --------------------------------------------------------------------- Press one as a home user and two if you are a business customer with a volume license agreement. ===DIAL 1 using touch-tone pad=== Press one if you have your Installation ID available if not press 2 ===DIAL 1 using touch-tone pad=== If you want to to activate Microsoft Product press one now if you activate office for Mac press two ===DIAL 2 using touch-tone pad=== --------------------------------------------------------------------- In this stage robot Speaker will ask your 9 group of Installation ID dial one by one using touch-tone pad Finally speaker will ask you last question: On how many computer is your product currently installed? *** DIAL 1 using your touch-tone pad.... *** In the end you will get Confirmation ID just type the ID in the activation wizard confirmation ID sectiction. Click ACTIVATE to finalize --- Done. : ) --------------------------------------------------------------------- Check your Windows Permanent Activation: cmd (admin) : slmgr.vbs -XPR ================================================================================= november_ra1n ================================================================================= Fake/Block key database: https://github.com/CNMan/balala =================================================================================

Thursday, November 16, 2017

PERINTAH FUNGSI SUM, COUNT, MAX, MIN, & AVG PADA MYSQL DENGAN CMD & Command Line Linux

Gak usah basa basi ya.... :D
Saya menggunakan command line di Linux, tapi jangan kuatir perintahnya gak berdeda dengan CMD di Windows. Hanya saja untuk mengaktifkan XAMPP Linux ya lewat command line.

Baca juga perintah dasar mysql cmd.

Ini dia.













Yah itu aja dah...
Semoga bermanfaat.

Salomo Silaban


salomo@silaban-X455LAB:~$ sudo /opt/lampp/lampp start
[sudo] password for salomo: 
Starting XAMPP for Linux 7.0.24-0...
XAMPP: Starting Apache...already running.
XAMPP: Starting MySQL...already running.
salomo@silaban-X455LAB:~$ /opt/lampp/bin/mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 10.1.28-MariaDB Source distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> Create database Akademik;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> Use Akademik;
Database changed
MariaDB [Akademik]> Create table Tabel_MK (Kode_MK char(17),
    -> Nama_MK char (30),
    -> SKS int (1),
    -> Semester int (1));
Query OK, 0 rows affected (0.38 sec)

MariaDB [Akademik]> Show databases;
+-----------------------+
| Database              |
+-----------------------+
| Akademik              |
| catatan               |
| information_schema    |
| latihan_android       |
| mysql                 |
| pendaftaran_mahasiswa |
| performance_schema    |
| phpmyadmin            |
| test                  |
| wordpress             |
+-----------------------+
10 rows in set (0.00 sec)

MariaDB [Akademik]> desc Tabel_MK;
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| Kode_MK  | char(17) | YES  |     | NULL    |       |
| Nama_MK  | char(30) | YES  |     | NULL    |       |
| SKS      | int(1)   | YES  |     | NULL    |       |
| Semester | int(1)   | YES  |     | NULL    |       |
+----------+----------+------+-----+---------+-------+
4 rows in set (0.10 sec)

MariaDB [Akademik]> Insert into Tabel_MK values ('14213201/15916313','Basis Data','2','3'),
    -> ('14213202/15916413','Statistik Probabilitas','2','3'), 
    -> ('14213203/15916324','Matematika Diskrit','2','3'), 
    -> ('14213206/15916354','Teori Graph','2','3'), 
    -> ('14213404/15916343','Sistem Operasi','4','3'), 
    -> ('14213405/15916364','Rekayasa Perangkat Lunak','4','3'),
    -> ('142AI2208/14784422','Arsitektur & Organisasi Komputer','2','2'),
    -> ('142AP2210/14783053','Pendidikan Kewarganegaraan','2','2'),
    -> ('142I2202/14784082','Logika Informatika','2','2'),
    -> ('142I2403/14784082','Jaringan Komputer 1','4','2'),
    -> ('142I2404/14783364','Struktur Data','4','2'),
    -> ('142S2201/14838025','Praktikum Struktur Data','2','2'),
    -> ('142AI12025/14498183','Pengantar Teknologi Informasi','2','1'),
    -> ('142AP1204/14315645','Pendidikan Agama','2','1'),
    -> ('142I1402/14530654','Konsep Bahasa Pemograman','2','1'),
    -> ('142I1204/14266845','Algoritma & Pemograman','4','1'),
    -> ('142I1403/14225363','Kalkulus','4','1'),
    -> ('142I1405/14478324','Pengantar Basis Data','4','1'),
    -> ('142S1202/14547914','Praktikum Pemograman','2','1'),
    -> ('142S1201/14468603','Praktikum Internet','2','1');
Query OK, 20 rows affected, 5 warnings (0.18 sec)
Records: 20  Duplicates: 0  Warnings: 5

MariaDB [Akademik]> Select*from Tabel_MK;
+-------------------+--------------------------------+------+----------+
| Kode_MK           | Nama_MK                        | SKS  | Semester |
+-------------------+--------------------------------+------+----------+
| 14213201/15916313 | Basis Data                     |    2 |        3 |
| 14213202/15916413 | Statistik Probabilitas         |    2 |        3 |
| 14213203/15916324 | Matematika Diskrit             |    2 |        3 |
| 14213206/15916354 | Teori Graph                    |    2 |        3 |
| 14213404/15916343 | Sistem Operasi                 |    4 |        3 |
| 14213405/15916364 | Rekayasa Perangkat Lunak       |    4 |        3 |
| 142AI2208/1478442 | Arsitektur & Organisasi Komput |    2 |        2 |
| 142AP2210/1478305 | Pendidikan Kewarganegaraan     |    2 |        2 |
| 142I2202/14784082 | Logika Informatika             |    2 |        2 |
| 142I2403/14784082 | Jaringan Komputer 1            |    4 |        2 |
| 142I2404/14783364 | Struktur Data                  |    4 |        2 |
| 142S2201/14838025 | Praktikum Struktur Data        |    2 |        2 |
| 142AI12025/144981 | Pengantar Teknologi Informasi  |    2 |        1 |
| 142AP1204/1431564 | Pendidikan Agama               |    2 |        1 |
| 142I1402/14530654 | Konsep Bahasa Pemograman       |    2 |        1 |
| 142I1204/14266845 | Algoritma & Pemograman         |    4 |        1 |
| 142I1403/14225363 | Kalkulus                       |    4 |        1 |
| 142I1405/14478324 | Pengantar Basis Data           |    4 |        1 |
| 142S1202/14547914 | Praktikum Pemograman           |    2 |        1 |
| 142S1201/14468603 | Praktikum Internet             |    2 |        1 |
+-------------------+--------------------------------+------+----------+
20 rows in set (0.00 sec)

MariaDB [Akademik]> Select SUM(SKS) as Total_SKS from Tabel_MK;
+-----------+
| Total_SKS |
+-----------+
|        54 |
+-----------+
1 row in set (0.05 sec)


MariaDB [Akademik]> Select SUM(SKS) as Total_SKS_Semester_1 from Tabel_MK where Semester='1';
+----------------------+
| Total_SKS_Semester_1 |
+----------------------+
|                   22 |
+----------------------+
1 row in set (0.00 sec)

MariaDB [Akademik]> Select COUNT(Nama_MK) as Total_MK From Tabel_MK;
+----------+
| Total_MK |
+----------+
|       20 |
+----------+
1 row in set (0.00 sec)

MariaDB [Akademik]> Select COUNT(Nama_MK) as Total_MK_Semester_1 From Tabel_MK where Semester='1';
+---------------------+
| Total_MK_Semester_1 |
+---------------------+
|                   8 |
+---------------------+
1 row in set (0.00 sec)

MariaDB [Akademik]> Select AVG(SKS) as Average_SKS From Tabel_MK;
+-------------+
| Average_SKS |
+-------------+
|      2.7000 |
+-------------+
1 row in set (0.00 sec)

MariaDB [Akademik]> Select AVG(SKS) as Average_SKS_Semester_1 From Tabel_MK where Semester='1';
+------------------------+
| Average_SKS_Semester_1 |
+------------------------+
|                 2.7500 |
+------------------------+
1 row in set (0.00 sec)

MariaDB [Akademik]> Select MIN(SKS) as Min_SKS From Tabel_MK;
+---------+
| Min_SKS |
+---------+
|       2 |
+---------+
1 row in set (0.00 sec)

MariaDB [Akademik]> Select MAX(SKS) as Min_SKS From Tabel_MK;
+---------+
| Min_SKS |
+---------+
|       4 |
+---------+
1 row in set (0.00 sec)

MariaDB [Akademik]> Select MAX(Semester) as Max_Semester,COUNT(Nama_MK) as Total_MK,SUM(SKS) as Total_SKS from Tabel_MK;
+--------------+----------+-----------+
| Max_Semester | Total_MK | Total_SKS |
+--------------+----------+-----------+
|            3 |       20 |        54 |
+--------------+----------+-----------+
1 row in set (0.00 sec)

MariaDB [Akademik]> Select Semester, COUNT(*) as Total_MK, SUM(SKS) as Total_SKS
    -> from Tabel_MK
    -> group by Semester
    -> order by Semester;
+----------+----------+-----------+
| Semester | Total_MK | Total_SKS |
+----------+----------+-----------+
|        1 |        8 |        22 |
|        2 |        6 |        16 |
|        3 |        6 |        16 |
+----------+----------+-----------+
3 rows in set (0.05 sec)

MariaDB [Akademik]> Ctrl-C -- exit!
Aborted
salomo@silaban-X455LAB:~$
http://www.salomo.tk/2017/11/perintah-fungsi-sum-count-max-min-avg.html

Sunday, May 28, 2017

Product Key Windows 10 Home, Pro, Enterprise, Education

PILIH SALAH SATU YANG MASIH AKTIF.


Windows 10 Education:
NW6C2-QMPVW-D7KKK-3GKT6-VCFB2

Windows 10 Education N:
2WH4N-8QGBV-H22JP-CT43Q-MDWWJ

Windows 10 Enterprise:
NPPR9-FWDCX-D2C8J-H872K-2YT43

Windows 10 Enterprise N:
DPH2V-TTNVB-4X9Q3-TJR4H-KHJW4

Windows 10 Enterprise 2016 LTSB:
DCPHK-NFMTC-H88MJ-PFHPY-QJ4BJ

Windows 10 Enterprise 2016 LTSB N:
QFFDN-GRT3P-VKWWX-X7T3R-8B639

Windows 10 Enterprise 2015 LTSB:
WNMTR-4C88C-JK8YV-HQ7T2-76DF9

Windows 10 Enterprise 2015 LTSB N:
2F77B-TNFGY-69QQF-B8YKP-D69TJ

Windows 10 Professional:
VK7JG-NPHTM-C97JM-9MPGT-3V66T
W269N-WFGWX-YVC9B-4J6C9-T83GX

Windows 10 Professional N:
MH37W-N47XK-V7XM9-C7227-GCQG9

Windows 10 RTM Enterprise Volume:MAK
BNJ87-JYH2B-DGXWM-JJVMR-Q9MPF
F3C2D-NWJHV-WFQ6X-VTJXF-CR4CF
NKV62-XMG4T-MXHBB-WFKXW-TQ72F
NM2DF-K222V-PD7HF-MGR32-V8RCF
QG2NR-J3M4R-VPXVY-3C7PW-Q69R4
F8H7N-WCW7B-KGPTK-YKFYQ-BG9R4
H9NFB-BK4KB-JW9H2-DWHFX-9HJWR
N98V8-PFTK6-HGBXX-FXFCW-9TPJR
XMXVV-3FNG6-MM2F3-94JYB-8FG44
NYVRG-DCRXB-49373-6D4TY-CWF8R
4CJ6N-QVY4V-3QR6T-TKTJK-KQBPF
4H2RN-DYH66-XTY9G-6JVC2-W2QF4
4N4MM-BVQW9-CCVDH-RW4HK-RM48R
4NVWR-29462-TFGDR-RBB7G-GMT44
4RNP7-YQ7JR-42QDQ-QJ884-F6YPF
4WYQN-T7M9F-J2T6B-VKF6R-Q9MPF
6BNP9-FBD2C-RPQ3G-VCB43-97644
6N7MJ-CBH4D-MKY36-2G3M3-49CJR
6NMBW-QQTQ7-Y64TT-H2VVF-FC2JR
7BNPV-G3V47-T4V8Y-G2FQD-49CJR
7FNKH-HKYFQ-9VBPQ-4BG98-VH644
7K9MX-NTDJ7-X3X92-2D4HB-DPFCF
7NCBT-RKXY9-T823F-VM4KK-BKMPF
7WK28-3NX2D-DHBWX-DKMYV-KHJWR
82QGN-D6CK3-4Y27R-9JTD2-9QBPF
877TM-NKQ3W-T4MBM-WXDYY-K7644
8D2QX-NW4D8-38W9V-R9X74-6Q72F
8GNRG-TJMDK-R4B7M-QF8PP-9QBPF
8KCDP-7N6FV-4HQ9B-C3PVG-CGYPF
8MNTD-VM2PB-M79PV-X7RDP-VFR8R
8QRMF-HN3PX-CCBQF-CPFBK-DYH2F
937MQ-NRFXR-4VFTW-B4PTH-FJRCF
99QNC-9YRT4-KVFGG-672RC-MP2JR
9C4P8-NJ43W-JKT32-RCPGV-VT9R4
9DD6N-VMRT4-R3QC2-W4PQ9-3RR8R
9DRCW-N6VJC-DB77T-TRFRB-VQWWR
9TF6N-9CGJT-V8KQ7-C6B3H-CYT44
9YX92-NRX39-7MC3D-G7GMG-MKMPF
B6FR4-2NKMM-9Q7YX-DPTKB-F9CJR
BB2FY-NVRXP-8X6TT-DWBV7-46YPF
BCVH9-N9YC8-DRKTV-PKKWH-G6PJR
BNXR4-DPMCQ-HFR8B-QCF4G-D3WWR
BPNC3-CRCYC-K2HR7-WGMDV-M4G44
C9JXK-N63CC-C4TY3-K6T96-QYH2F
C9RNB-WMHWV-3V3CD-VFGYW-HMH2F
CBYVH-XVN7F-TPRGQ-KPYYG-683F4
CFNJY-Y7CDH-6Q9PJ-687C7-B7V2F
CN387-H3Y3F-HM9CY-VRQ6T-3V644
CNM6Y-7G8WR-GTXRT-4D4M4-DJ3F4
CNYJ7-RFKM2-Y3GFG-FGGW8-Q69R4
CVN9J-43FT9-PJ47J-BRD9X-GJF8R
D2DXQ-Q3N9P-HW26T-KFPT9-CDKR4
DCHRH-N82WY-GKXP4-QYY44-369R4
DCVHN-MJ8PW-QW69V-JBC4D-PYT44
DMNGR-4J4GY-76M6P-R86H2-27JWR
DTFMN-JJ7XJ-K28T2-J87WM-3GPJR
DTYN2-7PXR2-R3GDF-TGG9X-Y7V2F
DY7KW-XN3PP-CGYX3-326RB-88F8R
F64FT-8NW3W-W7GTC-9TWYC-KW3F4
F7XNK-PT63R-2FKPC-KVR6M-QJ3F4
F83MW-NGHTD-FJKMF-WJW7D-C372F
F9WQR-T3NK9-PBBFC-P8RCF-FC2JR
FMJN6-9J2CM-KKPHT-RR8GF-YTDF4
FMXPQ-KKN3P-8DVVX-DV6FH-QPFCF
FNT2Y-MV2X4-69HHJ-X2Y9W-78RCF
FYVYN-GQ69T-K3XD2-6DTPT-683F4
GBNC9-XXFH3-KCKY6-H3QFJ-W44CF
GCCH3-KWNRF-DK3JB-CY3HV-8HV2F
GCCKF-NT3H7-Y9T3M-BXTQX-C7JWR
GHPTN-JPWWB-34M4V-7RDK4-X2FCF
GN3F7-JKFH8-46R47-RRJ83-XHJWR
GVNR3-DPVD4-8Q3VK-HC6PJ-QDBPF
GYB4T-PFNQF-DJQP6-3X9BY-2PQF4
H487V-26NK2-GVPGB-GPT2Q-3PFCF
H62TN-C68JW-6CGXV-7CVBB-X4R8R
H6Y63-YNRRF-JX2Q9-QP3B6-BP2JR
H6YFB-P6NCK-Q44J6-6YWYQ-FM48R
HHHRB-ND69C-HRF7R-KWGHM-39MPF
HV9WG-WN7WG-3TPPW-3YRYV-B7V2F
HX8MN-9PBQ6-BMC6J-2FT3G-4M48R
J79N9-Y22KM-4P7KR-HXTHX-DYH2F
J8N2Y-93RPP-G8W66-QQRWQ-2WF8R
J9NWQ-DPT3W-3H7Q6-QJY6W-7FR8R
JD3N6-GRC8B-6MWB6-TGD7J-F3KR4
JTJYN-G2XFX-64BG7-H687H-3J3F4
JW9BH-MNYC6-Q2QMX-3WK6B-JK8WR
JWRRK-NTGT4-MQ6MK-H3D9T-VCFCF
K39NB-CDTMF-9QB69-XPFVW-CPQF4
K3HXX-3QN24-GK29P-HMC2Y-43KR4
KQRFX-BN8XH-YRMVT-KCJ9P-XTPJR
KVHHN-7V73K-HJH3K-B8B9K-4JRCF
KXXK6-X3NV7-B8H4F-TB2VC-BTDF4
M43X6-QJN9T-PW244-8JCC6-XQBPF
MFQN6-TYBJ8-GPPV8-723K7-DRR8R
MGHCN-B8YYB-YHHFX-GC7QB-RC2JR
MN6W8-BQJMM-CKG7J-F9P2H-R9CJR
MRBWB-P4N4J-3K2H7-JYY2J-YP2JR
MTKWJ-NFTTJ-DVDRC-RC4PH-HXMPF
MYNV9-VDFTM-G4GHW-TKHK6-GMT44
N33G6-RR2DY-CT7WV-H48TW-7FR8R
N46FQ-C6FDT-7GP78-VMD3Y-PR4CF
N4PKM-7RHJD-CYPDC-6DGCX-M98WR
N648X-KMBMK-F28T8-VRRK4-369R4
N6WF8-YC4JD-JTJV4-Q4PMB-PR4CF
N773C-BQC8X-4X8BR-HTFY3-49CJR
N7K64-DRQB3-MRB4D-Q9T6B-39MPF
N84J9-PVWHG-66FF3-R49VB-MY48R
N8CJB-RXBJW-RV9T3-4F4FR-MWRCF
N8GJK-WCX8W-HYMQT-XT7K4-X2FCF
N8JJP-H7VQJ-342KB-F4HFT-BP2JR
N8QKQ-XRQG4-PCG62-6B8DY-BBH2F
N8V7Y-P8B86-6K4YY-7FDWD-Y4G44
NDWJ6-9W4TB-7F776-FPYVP-GQ72F
NGFPX-3YFY9-2QPYV-X3Q7R-KBT44
NGTGM-939R6-8WTKR-GBYM7-WK8WR
NHQRM-G4FM6-4K7HY-J284Q-GF4CF
NJMF6-B9VQC-44QYD-W4TFM-6VJWR
NKBHP-9G2VG-BMXYK-R6HB4-7H644
NKJ76-6HW7P-PXP6H-W8H44-8B48R
NKKJ9-8MRB2-8FBPF-XDM2G-QYH2F
NP8FH-WHQQ2-8F64M-D86KW-TQ72F
NPT7D-9DWWR-PPGX7-DHMRG-PDKR4
NQGDH-Y2TC8-VMKW8-48Q67-MBH2F
NR4FR-M8234-VYFV9-4MQMQ-T6PJR
NTQ4P-WQRPH-DH8FC-QPY2W-GVJWR
NTY6B-MD82R-7R6RG-DJMG6-4M48R
NVXGG-64H39-GFRXG-HRQW4-4X8WR
NWCRW-QHTM6-BT6BT-Q8DX4-TVJWR
NWHD3-FFX7G-B8BHD-V6RXJ-HMH2F
NWJQ2-Q8RKP-JYQ8Q-878K3-RJRCF
NX4WK-4TW2Y-X778G-YWFDX-HCFCF
P4CH3-QQNW7-7XMYC-97X8H-2R4CF
P6XQ3-CN6YK-23RT2-MY2RW-78RCF
P7N43-7CKCH-8DJ7T-3Y6RV-G6PJR
P9C2R-NM3BW-JR7DG-2R38J-D9MPF
PFNX9-BBBQ9-QCVJR-TTQR6-GMT44
PG9N3-PM7T8-VC3RD-PFHB6-J2QF4
PNBQK-2J7HQ-YQ7JV-C9QD6-2372F
PT6JN-4DWXJ-KRFC2-43FF6-V6DF4
PTK64-VNPHP-CYWFK-K8M3Y-39MPF
Q2K6R-BNJT8-GWVXY-7CRJK-V22JR
Q38P9-PMN6Y-CQHW7-C86GD-DV644
Q3RNH-XG8CQ-V2WVK-GFM92-BTDF4
Q49XN-F78FP-9FW3M-DJHPM-X4R8R
Q7684-83NB2-4GV39-GGCBT-D3WWR
Q9XNY-DHB9T-VWGMV-247RT-P7JWR
QCDW3-NKMR4-3YQ8P-BKGXJ-7FR8R
QFW6N-TG2R6-KBWXT-7KQTT-PDKR4
QN9TC-V9RV2-P8CQ7-4R4MJ-CPQF4
QNK9K-Y69RT-3KHP2-G678Q-MDWWR
QNKFP-9TKVJ-B9GVK-RQ8F2-FX8WR
QT7ND-G7HKR-CGVQY-XVX8Y-PR4CF
QXTNG-7BD3Q-RG9RC-VHD8B-K7644
QY6N6-JQQC3-3CFBH-TYH33-3PFCF
QYJN2-MWKPY-RH4T7-F63JM-DPFCF
R3NPV-GW4QG-GQY3F-KFDJ4-QGPJR
RC77N-X7JT9-J2TQK-RW278-HMH2F
RDNJC-Y4WP7-BPB9F-MJTR8-QDBPF
RDP2K-NJ2H2-YHG2G-7TF8V-R9CJR
RF9NH-QX84T-7TTJ6-WBGBR-2KCJR
RQKG3-DNYK7-7WTKV-Q9GXM-CWF8R
RRNHY-63948-T29KK-X6WBX-YDWWR
TG7YN-T29RB-3CFGQ-TWCHG-KTPJR
TJG6W-N8MJR-P3YM4-X6VDJ-33WWR
TMDBT-NTKQP-QQ2K3-6JCRX-QV644
TN2CV-VF8R3-TB7FF-3QKPJ-BWRCF
TNHYH-CRKHY-JHPXX-PFQTR-GXXR4
VBWNQ-X6W98-M6J44-PH3WR-X2FCF
VFJNG-V7FGX-CKQD2-3MGQ9-7XMPF
VXMBM-VNW9Q-KYTJP-4FGPX-H6DF4
W6HKD-QNDF2-YFKHR-M77Q8-K2FCF
W73HG-N2KDR-FTYC8-WDP7D-97644
W98PN-8YFFJ-J9GCH-PKWJJ-D9MPF
WBM6F-QPNVD-BWMMC-82VYH-X7644
WD8FB-KBNM3-XTX2M-9YFGV-YY48R
WJKVV-NDK3K-FJBD6-PX2JM-HT9R4
WMQTN-VJH7P-KW8MH-BQKX2-8XCJR
WPJ3T-CMN8T-2DQ2C-T4WQD-9D72F
WXN7B-P2D3P-7VP8R-TBY2C-FX8WR
X832N-D74VH-2W76D-XXYGM-VQWWR
X86K6-NKG23-2RX8B-VJCW9-DYH2F
XC23N-DXGHV-M2GBR-8G86V-QPFCF
XGNBC-Y9VJW-4C422-4G7WQ-RJRCF
XKHXN-GTRHG-JP4JX-V3CHX-7XMPF
XNRYC-VKPB6-GT76J-DRQK2-J44CF
Y268N-DYRVQ-4R3TB-2WYD3-H22JR
Y4VBP-CNTDY-R896G-VPGQQ-63BPF
Y62VY-NR7WR-HM3MY-CXXF7-R9CJR
Y8HCN-8KFYV-MXHJ9-XXCCY-YWRCF


Semoga bermanfaat.

Wednesday, May 17, 2017

Cara memutar segala format video di Windows Media Player. (MKW,AVI,3GP,DAT,MPG,MOV,MP4,RM,WMV) dan lainnya

Tanpa basa basi.

Langsung saja..!

Pernah mengalami hal yang seperti  gambar ini saat memutar video yang berformat selain MP4 ?
Ini solusinya...!!
Download codec Media Player dari situs resminya di sini.
Install.. lalu mainkan video yang tidak bisa diputar tadi.
Semoga berhasil

Sunday, May 14, 2017

INSTALL IDM FULL FERSION 2017 TANPA VIRUS, CRACK, PATCH.

TANPA BASA-BASI LANGSUNG AJA...!!!

Jika belum punya IDM, silahkan download dari situr resminya biar aman .. :D
Lalu install.

1. Turn off your internet conection (MATIKAN KONEKSI INTERNET)
2. Open IDM, enter your registration.(BUKA IDM LALU REGISTRASI)

3. Choose one of your series (PILIH SALAH SATU SERIAL INI)

OP3BQ-I5EAR-UN52H-VR7QX
7TSFG-YWZ5O-YWLSB-89N41
ZJ14C-KHNV1-I9YPK-YITD9
84X1I-3HVW3-MX7ZK-QBG0M
P40GN-Z6V66-FMUW8-NKAC5
1B0C2-NOGKB-AH0DH-W8R3C
S89JW-J3KDR-KBHW5-RMQ8H
QVD3H-ZY9K1-GW94Z-XOLQS
1XL56-8BB1L-TTQII-89DFX
X33SI-6BW37-SQG4D-FGN8M
1O6SO-LOOFL-ZFW66-EIF97
UXX3S-9N0NT-M74X0-DESMI
W3J5U-8U66N-D0B9M-54SLM
EC0Q6-QN7UH-5S3JB-YZMEK
GZLJY-X50S3-0S20D-NFRF9
4. Open windows exploler go to C:\WINDOWS\system32\drivers\etc\hosts (SILAHKAN TUJU file host di C)

5. Open hosts file with notepad. (BUKA MENGUNAKAN NOTEPAD)
6. Copy this scrip and paste under the script. (COPAS SCRIP INI DI BAWAH)

127.0.0.1 tonec.com
127.0.0.1 www.tonec.com
127.0.0.1 registeridm.com
127.0.0.1 www.registeridm.com
127.0.0.1 secure.registeridm.com
127.0.0.1 internetdownloadmanager.com
127.0.0.1 www.internetdownloadmanager.com
127.0.0.1 secure.internetdownloadmanager.com
127.0.0.1 mirror.internetdownloadmanager.com
127.0.0.1 mirror2.internetdownloadmanager.com
127.0.0.1 mirror3.internetdownloadmanager.com

Then save. (LALU SIMPAN)
Your IDM has full version. (SELESAI)
End Enjoy...!!

Monday, May 8, 2017

CARA DOWNLOAD WINDOWS 10 ORIGINAL DARI SERVER MICROSOFT

CARA DOWNLOAD WINDOWS 10 ORIGINAL DARI SERVER MICROSOFT


Tanpa basa-basi.
Berikut cara download Windows 10 file ISO, yang pasti aman dan terhindar dari pihak-pihak yang suka mengubah isi, atau menyisipkan sesuatu yang tidak di butuhkan dalam sebuah OS.
Ok..
Kita akan download file ISOnya dengan sebuah software yang disediakan oleh Microsoft untuk download Windows 10 dalam file ISO.
Pertama download Media Creation Tool dari situs resminya Di sini..

Kunjungi juga cara menonaktifkan update otomatis windows 10


Lalu setelah selesai download aplikasinya.
Run as Administrator pada filenya.



Klik  Accept.



Nah.. di bagian ini kita ditawari untuk Upgrate ke Windows 10 atau download file ISOnya saja.
Kita ingin download file ISO, maka kita centang Create installation media (USB flash drive, DVD, or ISO file) for PC lalu next seperti gambar.
 
Pilih bahasa dan versi windows dan 32 atau 64 bit, sesuaikan dengan komputer anda.



Ikuti gambar berikut..


Menentukan lokasi penyimpanan file ISO yang kita download.

Sekarang tunggu proses downloading selesai.



Sekian tutorial CARA DOWNLOAD WINDOWS 10 ORIGINAL DARI SERVER MICROSOFT saya buat..
Semoga bermanfaat.
Terimakasih.
salomo516.blogspot.co.id


Friday, May 5, 2017

Cara menonaktifkan Update Otomatis Windows 10 Home, Pro, dan Enterprise.

Cara menonaktifkan Update Windows 10  Home, Pro, dan Enterprise

Saya akan berbagi cara menonaktifkan Windows Update Otomatis pada Windows 10 Home, Pro, dan Enterprise

Cara pertama dengan Task Maneger.
Pertama tekan Tombol Win + X secara bersamaan. Pilih "Task Maneger"

Pilih Services..


Open Sevices

Scroll kebawah dan pilih Windows Update
Klik kanan pada Windows Update dan pilih Stop

Klik kanan lagi pada Windows Update dan pilih Properties


Pilih Disable lalu Ok.

Done..
Selamat Windows anda selamat dari Update Otomatis dari Pihak Microsoft.

Cara yang kedua dengan PowerShell.
Pertama tekan Tombol Win + R Lalu ketikkan PowerShell
Lalu salin perintah berikut.
stop-service wuauserv [Enter]
set-service wuauserv –startup disabled [Enter]Cara ini lebih cepat.
Namun dengan cara pertama akan membuat kita lebih banyak otak-atik komputer heheee...

Sekian.
Semoga bermanfaat

Tuesday, March 7, 2017

PERINTAH DASAR MYSQL

C:\XAMMP\MYSQL\BIN

1. Membuat database sekolah
CREATE DATABASE sekolah;
2. Menghapus database sekolah
DROP DATABASE sekolah;
3. Menampilkan database.
SHOW DATABASES;
4. Mengaktifkan database sekolah
USE sekolah;
5. Membuat tabel siswa
CREATE TABLE siswa (NIS int(12) primary key,
->Nama char (20),
->Kelas char (10),
->Jenis_kelamin char (15),
->Alamat char (15));
6. Melihat daftar tabel.
SHOW TABLES;
7. Melihat deskripsi tabel siswa
DESC siswa;
8. Menambah kolom baru dengan tipe dan posisi tertentu.
ALTER TABLE siswa ADD umur int(3);
9. Merename nama tabel.
ALTER TABLE siswa RENAME tbl_siswa;
10. Menambah field baru.
ALTER TABLE tbl_siswa ADD COLUMN status varchar (15);
11. Mengubah nama field dan ukurannya.
ALTER TABLE tbl_siswa CHANGE siswa id_siswa int(15);
12. Mengubah ukuran field.
ALTER TABLE tbl_siswa MODIFY id_siswa int(20) not null auto_increment;
13. Menghapus field.
ALTER TABLE tbl_siswa DROP status;
14. Memasukkan data ke dalam tabel dan menampilkan data tabel.
INSERT INTO tbl_siswa (Nama, Alamat, Jenis_Kel) values ('Salomo Silaban','Palembang','Laki-laki');
15. Menampilkan data berdasarkan kriteria tertentu.
SELECT * FROM tbl_siswa WHERE alamat='Palembang';
16. Menghapus data berdasarkan kriteria tertentu.
DELETE FROM tbl_siswa WHERE alamat ='Jakarta';
17. Menampikan data tertentu.
SELECT nama,alamat FROM tbl_siswa;
18. Menampilakan data berdasarkan data tertentu dan dengan syarat tertentu.
SELECT * FROM tbl_siswa WHERE alamat='Medan' AND nama LIKE 'Ber%';
SELECT * FROM tbl_siswa WHERE alamat='Jambi' AND umur>17;
19. Menampilkan data menurut field yang bukan menurut kriteria tertentu.
SELECT nama, alamat FROM tbl_siswa where alamat!='Medan';
20. Mengurutkan data pada database mysql.
SELECT * FROM tbl_siswa ORDER BY umur ASC; (dari data terbesar ke terkecil)
SELECT * FROM tbl_siswa ORDER BY umur DESC; (dari data terkecil ke terbesar)
21. Menampilkan data berdasarkan mulai dari baris ke berapa dan berapa baris.
SELECT * FROM tbl_siswa LIMIT 1, 3;
SELECT * FROM tbl_siswa LIMIT 2, 2;
22. Update recort database tertentu.
UPDATE tbl_siswa SET alamat='Medan', Umur=19 WHERE Nama='Jujuria Silaban';
(Mengubah alamat dan umur pada Jujuria Silaban)
23. Menambahkan kolom pada tabel dan letak posisinya.
ALTER TABLE tbl_siswa ADD Hoby varchar(10) AFTER alamat;
(menambah kolom Hoby pada tbl_siswa, posisinya setelah kolom alamat)
24. Mengisi kolom baru yang masih kosong.
UPDATE tbl_siswa SET Hoby='Musik';
25. Menghitung angka di tabel.
UPDATE tbl_gaji set Total_Gaji = Gaji_Pokok + Tunjangan + Lembur WHERE nama='Salomo Silaban';
(Menotalkan setiap pendapatan dan mengisinya ke kolom Total_Gaji pada Salomo Silaban)
26. Untuk Menampilkan waktu sekarang .
SELECT NOW(), CURDATE(), CURTIME();
27. Menampilkan nama siswa yang diawali huruf A dan diakhiri huruf i
SELECT * FROM SISWA where nama like 'A%i;
SELECT * FROM SISWA where nama regxp'^A' and nama regexp  'i$;
SELECT * FROM SISWA where nama like 'A%i;

"FUNGTIONS"

27. Menampilkan total angka dalam kolom
SELECT SUM(sks) FROM nama_tabel;
28. Menampilkan total data dalam kolom
SELECT cout
Sekian info...
Semoga membantu...
Terima kasih kunjungannya...
Tugas..
database akademik, tabel mk dengan fungsi sum, count, avg, min, max
semester 1, 2, 3

Salomo Silaban