Tag: T-SQL

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…