Category: MS SQL

Microsoft SQL Server

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

Assign table to filegroup

We can assign table to filegroup when table creation. Besides,…

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

Management of File data

File data is used to store all object and data of…

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

Filegroup in MS SQL

Filegroup is a logical group of data file. Data file…

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

Data file in MS SQL

Data file is an file which store all object and…

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

Access control of MS SQL – Part 3

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

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…