.::: Create Report SQL Server Using SSRS (Sample Lab ) :::.

A. Check Table SQL Server
select * from barang;

B. Install & Enable SSRS Service

.::: Performance Compare 4 CPU vs 1 CPU In SQL Server Using Execution Plan (Setting MaxDop Max Degree Of Parallelism) :::.

 
1. Download & restore AdventureWorks2019
2. Open New Query and run Query below & Execute
set Statistics io, time on
use AdventureWorks2019

-- Query running on 4 logical processors

.::: Lab Integration SSIS with SQL Server using SQL Jobs Agent :::.

A. Create Database & Table from Source & Destination

1. Create database source

tgh_source

2. create table source

create table barang(

KODE_BARANG char(6) not null ,

NAMA_BARANG varchar(25), 

SATUAN_BARANG varchar(20),

STOK_BARANG decimal(4),

primary key (KODE_BARANG));

.::: Configure Enable NTP Server & Client Windows Server using Group Policy Editor :::.

 A. Windows Server become NTP Server

1. Open Group Policy Editor (gpedit.msc)

2. Open Time Provider

Computer Configuration > Administrative Templates > System > Windows Time Service > Time Providers.

.::: Cannot Remote Desktop Connection : An Authentication error has Occured. Due to CredSSP Encryption Oracle Remedian :::.

 

1. Open Registry

2. Open Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System\CredSSP\Parameters

3. Double-click the AllowEncryptionOracle DWORD to open its Edit DWORD window.

Enter the value ‘2‘ in the Value data text box, and press the OK button.

.::: Create & Test Maintenance Cleanup Task in SQL Server MSSQL :::.

1. Create Maintenance Plan