MSSQL-Feature-Image
Author: Joe Chan Published Date: 10 Feb, 2019
Posted in MS SQL

Access control of MS SQL – Part 2

At Access control of MS SQL – Part 1, we tell…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 07 Feb, 2019 1 Comment on Access control of MS SQL – Part 1
Posted in MS SQL

Access control of MS SQL – Part 1

SQL Server has 2 authentication mode: 1: Windows Authentication Mode…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 06 Feb, 2019
Posted in MS SQL

Install Sample Database for Lab

Microsoft provide a sample database called AdventureWorks. We can download it…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 05 Feb, 2019 1 Comment on How to map network drive in SSMS
Posted in MS SQL

How to map network drive in SSMS

We can use “xp_cmdshell” to run windows command, it also…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 04 Feb, 2019
Posted in MS SQL

Install SSMS on client

SSMS stand for “SQL Server Management Studio”. It is used…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 04 Feb, 2019
Posted in MS SQL

Building MS SQL for Lab

The following is Network Diagram of the Lab: If you…

Window-Server-Feature-Image
Author: Joe Chan Published Date: 02 Feb, 2019 1 Comment on Building AD DS for Lab
Posted in Window Server

Building AD DS for Lab

Before we start configure Windows Server as AD DS, we need to prepare the following information.Host name: AD01IP: 10.10.10.10 /24DNS: 10.10.10.10Default Gateway: 10.10.10.1 (optional) Pre-Step…