{"id":414347,"date":"2024-12-05T11:21:55","date_gmt":"2024-12-05T04:21:55","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=414347"},"modified":"2024-12-05T11:21:55","modified_gmt":"2024-12-05T04:21:55","slug":"tai-sql","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/tai-sql\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea3i, c\u00e0i \u0111\u1eb7t SQL Server 2019 c\u1ef1c \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"

Microsoft ph\u00e1t h\u00e0nh r\u1ea5t nhi\u1ec1u ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng qu\u1ea3n l\u00fd t\u1ed1t c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. Trong \u0111\u00f3, SQL Server l\u00e0 m\u1ed9t \u1ee9ng c\u1eed vi\u00ean s\u00e1ng gi\u00e1 trong vi\u1ec7c gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd c\u00e1c d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch b\u1ea3o m\u1eadt v\u1edbi hi\u1ec7u su\u1ea5t th\u00f4ng minh. Ngay trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n <\/span>c\u00e1ch t\u1ea3i SQL Server<\/b> c\u1ef1c \u0111\u01a1n gi\u1ea3n. \u0110i k\u00e8m v\u1edbi, b\u1ea1n c\u0169ng s\u1ebd bi\u1ebft c\u00e1ch c\u00e0i \u0111\u1eb7t ph\u1ea7n m\u1ec1m n\u00e0y \u0111\u1ec3 s\u1eed d\u1ee5ng b\u1ea5t c\u1ee9 khi n\u00e0o c\u00f3 nhu c\u1ea7u nh\u00e9.<\/span><\/p>\n

SQL Server l\u00e0 g\u00ec?<\/b><\/h2>\n

SQL Server l\u00e0 m\u1ed9t h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u (RDBMS) \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 l\u01b0u tr\u1eef v\u00e0 qu\u1ea3n l\u00fd c\u00e1c d\u1eef li\u1ec7u trong c\u00e1c \u1ee9ng d\u1ee5ng t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn. \u0110\u01b0\u1ee3c ph\u00e1t h\u00e0nh l\u1ea7n \u0111\u1ea7u v\u00e0o n\u0103m 1989, SQL Server \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t trong nh\u1eefng h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn nh\u1ea5t tr\u00ean th\u1ebf gi\u1edbi. Nh\u1edd v\u00e0o kh\u1ea3 n\u0103ng m\u1edf r\u1ed9ng, b\u1ea3o m\u1eadt cao v\u00e0 t\u00ednh linh ho\u1ea1t trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/span><\/p>\n

\"tai-sql-1\"<\/picture><\/p>\n

SQL Server h\u1ed7 tr\u1ee3 ng\u00f4n ng\u1eef truy v\u1ea5n c\u1ea5u tr\u00fac (SQL), cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u nh\u01b0 th\u00eam, s\u1eeda, x\u00f3a, v\u00e0 truy v\u1ea5n d\u1eef li\u1ec7u. SQL Server c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng tr\u00ean nhi\u1ec1u h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows v\u00e0 Linux. V\u1edbi c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c nhau nh\u01b0 <\/span>t\u1ea3i SQL Server Express, SQL Server Standard v\u00e0 SQL Server Enterprise<\/b>, gi\u00fap \u0111\u00e1p \u1ee9ng nhu c\u1ea7u c\u1ee7a c\u00e1c t\u1ed5 ch\u1ee9c t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn.<\/span><\/p>\n

SQL Server g\u1ed3m nh\u1eefng th\u00e0nh ph\u1ea7n n\u00e0o?<\/b><\/h2>\n

V\u1edbi m\u1ee5c ti\u00eau cung c\u1ea5p m\u1ed9t n\u1ec1n t\u1ea3ng linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 cho vi\u1ec7c qu\u1ea3n l\u00fd, l\u01b0u tr\u1eef v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u. SQL Server bao g\u1ed3m nhi\u1ec1u th\u00e0nh ph\u1ea7n quan tr\u1ecdng, m\u1ed7i th\u00e0nh ph\u1ea7n \u0111\u00f3ng m\u1ed9t vai tr\u00f2 c\u1ee5 th\u1ec3 trong vi\u1ec7c gi\u00fap h\u1ec7 th\u1ed1ng ho\u1ea1t \u0111\u1ed9ng m\u01b0\u1ee3t m\u00e0 v\u00e0 hi\u1ec7u qu\u1ea3. Trong \u0111\u00f3 c\u00f3 th\u00e0nh ph\u1ea7n ch\u00ednh l\u00e0 Database Engine v\u00e0 SQLOS, \u0111\u00e2y c\u0169ng l\u00e0 hai th\u00e0nh ph\u1ea7n quan tr\u1ecdng nh\u1ea5t c\u1ee7a ph\u1ea7n m\u1ec1m n\u00e0y.<\/span><\/p>\n

\"tai-sql-2\"<\/picture><\/p>\n

Database Engine l\u00e0 th\u00e0nh ph\u1ea7n c\u1ed1t l\u00f5i ch\u1ecbu tr\u00e1ch nhi\u1ec7m l\u01b0u tr\u1eef, qu\u1ea3n l\u00fd v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u. Database Engine cung c\u1ea5p c\u00e1c d\u1ecbch v\u1ee5 c\u01a1 b\u1ea3n nh\u01b0 t\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u, th\u1ef1c hi\u1ec7n c\u00e1c truy v\u1ea5n SQL, v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh to\u00e0n v\u1eb9n c\u1ee7a d\u1eef li\u1ec7u. N\u00f3 bao g\u1ed3m c\u00e1c b\u1ed9 ph\u1eadn nh\u01b0 Query Processor (x\u1eed l\u00fd truy v\u1ea5n), Storage Engine (qu\u1ea3n l\u00fd l\u01b0u tr\u1eef d\u1eef li\u1ec7u), v\u00e0 Transaction Log (qu\u1ea3n l\u00fd c\u00e1c giao d\u1ecbch d\u1eef li\u1ec7u).<\/span><\/p>\n

SQLOS ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t l\u1edbp trung gian gi\u1eefa h\u1ec7 \u0111i\u1ec1u h\u00e0nh v\u00e0 c\u00e1c d\u1ecbch v\u1ee5 c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a SQL Server. SQLOS qu\u1ea3n l\u00fd c\u00e1c t\u00e0i nguy\u00ean h\u1ec7 th\u1ed1ng v\u00e0 cung c\u1ea5p c\u00e1c d\u1ecbch v\u1ee5 c\u01a1 b\u1ea3n nh\u01b0 qu\u1ea3n l\u00fd b\u1ed9 nh\u1edb, x\u1eed l\u00fd lu\u1ed3ng v\u00e0 qu\u1ea3n l\u00fd ti\u1ebfn tr\u00ecnh cho SQL Server.<\/span><\/p>\n

L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng SQL Server l\u00e0 g\u00ec?<\/b><\/h2>\n

T\u1ea3i SQL <\/b>v\u1ec1 m\u00e1y t\u00ednh s\u1eed d\u1ee5ng s\u1ebd mang \u0111\u1ebfn cho b\u1ea1n r\u1ea5t nhi\u1ec1u l\u1ee3i \u00edch thi\u1ebft th\u1ef1c, nh\u1ea5t l\u00e0 \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, c\u0169ng nh\u01b0 \u0111\u1ed1i v\u1edbi c\u00e1c m\u00f4i tr\u01b0\u1eddng y\u00eau c\u1ea7u qu\u1ea3n l\u00fd v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3.\u00a0<\/span><\/p>\n

Hi\u1ec7u su\u1ea5t cao<\/b><\/h3>\n

SQL Server s\u1eed d\u1ee5ng nhi\u1ec1u k\u1ef9 thu\u1eadt t\u1ed1i \u01b0u h\u00f3a truy v\u1ea5n v\u00e0 qu\u1ea3n l\u00fd t\u00e0i nguy\u00ean \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c c\u1ee7a h\u1ec7 th\u1ed1ng, bao g\u1ed3m vi\u1ec7c s\u1eed d\u1ee5ng ch\u1ec9 m\u1ee5c \u0111\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 t\u00ecm ki\u1ebfm v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u. C\u00e1c ch\u1ec9 m\u1ee5c n\u00e0y gi\u00fap gi\u1ea3m thi\u1ec3u th\u1eddi gian truy v\u1ea5n b\u1eb1ng c\u00e1ch t\u1ea1o ra c\u00e1c b\u1ea3ng ph\u1ee5 gi\u00fap nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n qu\u00e9t to\u00e0n b\u1ed9 b\u1ea3ng.<\/span><\/p>\n

\"tai-sql-3\"<\/picture><\/p>\n

B\u00ean c\u1ea1nh \u0111\u00f3, SQL Server c\u00f2n h\u1ed7 tr\u1ee3 ph\u00e2n m\u1ea3nh d\u1eef li\u1ec7u, cho ph\u00e9p ph\u00e2n chia c\u00e1c b\u1ea3ng l\u1edbn th\u00e0nh c\u00e1c ph\u1ea7n nh\u1ecf h\u01a1n, gi\u00fap gi\u1ea3m t\u1ea3i cho h\u1ec7 th\u1ed1ng v\u00e0 t\u0103ng c\u01b0\u1eddng hi\u1ec7u su\u1ea5t khi truy v\u1ea5n. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u l\u1edbn, v\u00ec n\u00f3 gi\u00fap c\u00e1c truy v\u1ea5n \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nhanh ch\u00f3ng m\u00e0 kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn t\u00e0i nguy\u00ean h\u1ec7 th\u1ed1ng.<\/span><\/p>\n

B\u1ea3o m\u1eadt m\u1ea1nh m\u1ebd<\/b><\/h3>\n

R\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi l\u1ef1a ch\u1ecdn <\/span>t\u1ea3i SQL<\/b> thay v\u00ec c\u00e1c ph\u1ea7n m\u1ec1m kh\u00e1c c\u0169ng v\u00ec n\u00f3 c\u00f3 kh\u1ea3 n\u0103ng b\u1ea3o m\u1eadt qu\u00e1 m\u1ea1nh m\u1ebd. Theo \u0111\u00f3, ph\u1ea7n m\u1ec1m s\u1eed d\u1ee5ng t\u00ednh n\u0103ng m\u00e3 h\u00f3a d\u1eef li\u1ec7u, cho ph\u00e9p m\u00e3 h\u00f3a th\u00f4ng tin quan tr\u1ecdng c\u1ea3 khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef v\u00e0 khi truy\u1ec1n t\u1ea3i gi\u1eefa c\u00e1c h\u1ec7 th\u1ed1ng. Nh\u1edd v\u00e0o \u0111\u00f3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u lu\u00f4n \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7, ngay c\u1ea3 khi b\u1ecb t\u1ea5n c\u00f4ng ho\u1eb7c truy c\u1eadp tr\u00e1i ph\u00e9p.<\/span><\/p>\n

\"tai-sql-4\"<\/picture><\/p>\n

SQL Server c\u0169ng cung c\u1ea5p c\u00e1c ph\u01b0\u01a1ng th\u1ee9c x\u00e1c th\u1ef1c ng\u01b0\u1eddi d\u00f9ng m\u1ea1nh m\u1ebd, bao g\u1ed3m x\u00e1c th\u1ef1c Windows v\u00e0 x\u00e1c th\u1ef1c SQL. C\u00f4ng c\u1ee5 n\u00e0y h\u1ed7 tr\u1ee3 ch\u1ec9 nh\u1eefng ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n m\u1edbi c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0 th\u1ef1c hi\u1ec7n thao t\u00e1c tr\u00ean c\u01a1 s\u1edf d\u1eef li\u1ec7u. Th\u00eam v\u00e0o \u0111\u00f3, t\u00ednh n\u0103ng ki\u1ec3m so\u00e1t quy\u1ec1n truy c\u1eadp chi ti\u1ebft cho ph\u00e9p qu\u1ea3n tr\u1ecb vi\u00ean c\u1ea5p quy\u1ec1n truy c\u1eadp theo t\u1eebng \u0111\u1ed1i t\u01b0\u1ee3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u, gi\u00fap h\u1ea1n ch\u1ebf quy\u1ec1n truy c\u1eadp ch\u1ec9 \u0111\u1ebfn c\u00e1c t\u00e0i nguy\u00ean c\u1ea7n thi\u1ebft v\u00e0 gi\u1ea3m thi\u1ec3u nguy c\u01a1 l\u1ea1m d\u1ee5ng.<\/span><\/p>\n

T\u00ednh linh ho\u1ea1t v\u00e0 kh\u1ea3 n\u0103ng t\u00edch h\u1ee3p<\/b><\/h3>\n

M\u1ed9t trong nh\u1eefng \u0111i\u1ec3m m\u1ea1nh c\u1ee7a SQL Server l\u00e0 kh\u1ea3 n\u0103ng t\u00edch h\u1ee3p v\u1edbi nhi\u1ec1u n\u1ec1n t\u1ea3ng v\u00e0 c\u00f4ng c\u1ee5 kh\u00e1c nhau, bao g\u1ed3m c\u00e1c h\u1ec7 th\u1ed1ng kh\u00e1c ngo\u00e0i Microsoft ho\u1eb7c c\u00e1c \u1ee9ng d\u1ee5ng t\u1eeb b\u00ean th\u1ee9 ba. M\u1ee5c \u0111\u00edch c\u1ee7a t\u00ednh n\u0103ng n\u00e0y l\u00e0 gi\u00fap c\u00e1c t\u1ed5 ch\u1ee9c d\u1ec5 d\u00e0ng x\u00e2y d\u1ef1ng c\u00e1c gi\u1ea3i ph\u00e1p k\u1ebft h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n v\u00e0 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a c\u01a1 s\u1edf h\u1ea1 t\u1ea7ng c\u00f4ng ngh\u1ec7 hi\u1ec7n c\u00f3.<\/span><\/p>\n

\"tai-sql-5\"<\/picture><\/p>\n

Khi b\u1ea1n <\/span>t\u1ea3i SQL Server 2019<\/b> th\u00ec n\u00ean t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 c\u00e1c c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd nh\u01b0 SQL Server Integration Services (SSIS). N\u00f3 cho ph\u00e9p t\u00edch h\u1ee3p v\u00e0 di chuy\u1ec3n d\u1eef li\u1ec7u gi\u1eefa c\u00e1c h\u1ec7 th\u1ed1ng kh\u00e1c nhau, t\u1eeb c\u00e1c ngu\u1ed3n d\u1eef li\u1ec7u b\u00ean ngo\u00e0i nh\u01b0 file CSV, Excel, \u0111\u1ebfn c\u00e1c h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u00e1c. SSIS h\u1ed7 tr\u1ee3 qu\u00e1 tr\u00ecnh tr\u00edch xu\u1ea5t, chuy\u1ec3n \u0111\u1ed5i v\u00e0 t\u1ea3i (ETL), gi\u00fap t\u1ed5 ch\u1ee9c d\u1ec5 d\u00e0ng chu\u1ea9n h\u00f3a v\u00e0 \u0111\u1ed3ng b\u1ed9 h\u00f3a d\u1eef li\u1ec7u \u0111\u1ec3 s\u1eed d\u1ee5ng trong c\u00e1c \u1ee9ng d\u1ee5ng ph\u00e2n t\u00edch, b\u00e1o c\u00e1o v\u00e0 \u1ee9ng d\u1ee5ng doanh nghi\u1ec7p.<\/span><\/p>\n

B\u00ean c\u1ea1nh \u0111\u00f3 c\u00f2n c\u00f3 c\u00e1c c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch v\u00e0 b\u00e1o c\u00e1o nh\u01b0 SQL Server Reporting Services (SSRS) v\u00e0 SQL Server Analysis Services (SSAS). SRS cho ph\u00e9p t\u1ea1o b\u00e1o c\u00e1o \u0111\u1ed9ng v\u00e0 t\u00f9y ch\u1ec9nh t\u1eeb d\u1eef li\u1ec7u trong SQL Server. Trong khi SSAS h\u1ed7 tr\u1ee3 vi\u1ec7c x\u00e2y d\u1ef1ng c\u00e1c m\u00f4 h\u00ecnh d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p v\u00e0 th\u1ef1c hi\u1ec7n ph\u00e2n t\u00edch d\u1eef li\u1ec7u chuy\u00ean s\u00e2u.<\/span><\/p>\n

Kh\u1ea3 n\u0103ng ph\u1ee5c h\u1ed3i v\u00e0 sao l\u01b0u m\u1ea1nh m\u1ebd<\/b><\/h3>\n

\u0110i\u1ec3m r\u1ea5t hay \u1edf ph\u1ea7n m\u1ec1m n\u00e0y l\u00e0 cung c\u1ea5p c\u00e1c c\u01a1 ch\u1ebf sao l\u01b0u linh ho\u1ea1t, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n sao l\u01b0u d\u1eef li\u1ec7u theo l\u1ecbch tr\u00ecnh. Th\u1eadm ch\u00ed, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn c\u00e1c ph\u01b0\u01a1ng th\u1ee9c sao l\u01b0u kh\u00e1c nhau nh\u01b0 sao l\u01b0u to\u00e0n b\u1ed9, sao l\u01b0u t\u1eebng ph\u1ea7n ho\u1eb7c sao l\u01b0u log giao d\u1ecbch. C\u00e1c c\u00e1ch th\u1ee9c n\u00e0y \u0111\u1ec1u nh\u1eb1m m\u1ee5c \u0111\u00edch gi\u1ea3m thi\u1ec3u m\u1ea5t m\u00e1t d\u1eef li\u1ec7u trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 s\u1ef1 c\u1ed1.<\/span><\/p>\n

\"tai-sql-6\"<\/picture><\/p>\n

H\u01a1n n\u1eefa, SQL Server c\u00f2n cung c\u1ea5p t\u00ednh n\u0103ng kh\u00f4i ph\u1ee5c \u0111i\u1ec3m th\u1eddi gian, cho ph\u00e9p kh\u00f4i ph\u1ee5c d\u1eef li\u1ec7u \u0111\u1ebfn m\u1ed9t th\u1eddi \u0111i\u1ec3m c\u1ee5 th\u1ec3 trong qu\u00e1 kh\u1ee9. Ch\u00ednh \u0111i\u1ec1u n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u1ed5 ch\u1ee9c ph\u1ee5c h\u1ed3i sau c\u00e1c s\u1ef1 c\u1ed1 ho\u1eb7c l\u1ed7i ng\u01b0\u1eddi d\u00f9ng m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t m\u00e1t d\u1eef li\u1ec7u quan tr\u1ecdng. T\u00ednh n\u0103ng n\u00e0y r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c kh\u00f4i ph\u1ee5c d\u1eef li\u1ec7u sau khi b\u1ecb t\u1ea5n c\u00f4ng ho\u1eb7c trong c\u00e1c t\u00ecnh hu\u1ed1ng kh\u00f4i ph\u1ee5c sau th\u1ea3m h\u1ecda.<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn t\u1ea3i SQL Server 2019 v\u00e0 c\u00e0i \u0111\u1eb7t tr\u00ean m\u00e1y t\u00ednh<\/b><\/h2>\n

Vi\u1ec7c t\u1ea3i v\u00e0 c\u00e0i \u0111\u1eb7t ph\u1ea7n m\u1ec1m SQL tr\u00ean m\u00e1y t\u00ednh kh\u00f4ng qu\u00e1 kh\u00f3 kh\u0103n nh\u01b0ng b\u1ea1n c\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n qua kh\u00e1 nhi\u1ec1u thao t\u00e1c. V\u00ec th\u1ebf, b\u1ea1n h\u00e3y tham kh\u1ea3o v\u00e0 th\u1ef1c hi\u1ec7n theo \u0111\u00fang h\u01b0\u1edbng d\u1eabn c\u1ee7a Ho\u00e0ng H\u00e0 Mobile b\u00ean d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 ti\u1ebfn tr\u00ecnh thi\u1ebft l\u1eadp ph\u1ea7n m\u1ec1m \u0111\u01b0\u1ee3c \u0111\u00fang nh\u1ea5t c\u00f3 th\u1ec3 nh\u00e9.<\/span><\/p>\n

C\u00e1ch t\u1ea3i<\/b><\/h3>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, ng\u01b0\u1eddi d\u00f9ng h\u00e3y truy c\u1eadp v\u00e0o \u0111\u01b0\u1eddng link \u201c<\/span>https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads<\/b>\u201d. \u1ede m\u1ee5c \u201cDeveloper\u201d b\u1ea1n h\u00e3y nh\u1ea5n ch\u1ecdn v\u00e0o n\u00fat \u201cT\u1ea3i xu\u1ed1ng – Download\u201d.<\/span><\/p>\n

\"tai-sql-7\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Tr\u00ean th\u01b0 m\u1ee5c v\u1eeba t\u1ea3i xu\u1ed1ng b\u1ea1n h\u00e3y m\u1edf n\u00f3 l\u00ean v\u00e0 th\u1ea5y \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o v\u1ec1 3 t\u00f9y ch\u1ecdn m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m.\u00a0<\/span><\/p>\n

\"tai-sql-8\"<\/picture><\/p>\n

Trong \u0111\u00f3, <\/span>Basic <\/b>l\u00e0 b\u1ea1n ch\u1ec9 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c c\u00e1c t\u00ednh n\u0103ng c\u01a1 b\u1ea3n nh\u1ea5t c\u1ee7a ph\u1ea7n m\u1ec1m. <\/span>Custom <\/b>s\u1ebd l\u00e0 phi\u00ean b\u1ea3n chuy\u00ean s\u00e2u h\u01a1n, n\u1ebfu b\u1ea1n ch\u1ecdn phi\u00ean b\u1ea3n n\u00e0y th\u00ec n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t c\u1ea5u h\u00ecnh c\u1ee7a SQL. C\u00f2n <\/span>Download Media<\/b> s\u1ebd t\u1ea3i xu\u1ed1ng cho b\u1ea1n m\u1ed9t file offline \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 c\u00e0i \u0111\u1eb7t n\u00f3 tr\u00ean nhi\u1ec1u thi\u1ebft b\u1ecb kh\u00e1c nhau.<\/span><\/p>\n

B\u01b0\u1edbc 3: Trong ph\u1ea1m vi b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd l\u1ef1a ch\u1ecdn m\u1ee5c \u0111\u00edch l\u00e0 \u201cBasic\u201d. Sau khi b\u1ea1n ch\u1ecdn v\u00e0o \u0111\u00f3 th\u00ec ti\u1ebfp t\u1ee5c nh\u1ea5n v\u00e0o \u201cAccept\u201d v\u00e0 ti\u1ebfp t\u1ee5c l\u00e0 n\u00fat \u201cInstall\u201d.<\/span><\/p>\n

\"tai-sql-9\"<\/picture><\/p>\n

C\u00e1ch c\u00e0i \u0111\u1eb7t<\/b><\/h3>\n

B\u01b0\u1edbc 1: Ngay khi b\u1ea1n th\u1ef1c hi\u1ec7n \u0111\u00fang 3 b\u01b0\u1edbc <\/span>t\u1ea3i SQL Server 2019<\/b> m\u00e0 Ho\u00e0ng H\u00e0 Mobile chia s\u1ebb \u1edf tr\u00ean. B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn m\u1ed9t trang th\u00f4ng tin kh\u00e1c, t\u1ea1i \u0111\u00e2y b\u1ea1n s\u1ebd ch\u1ecdn v\u00e0o \u201cCustomize\u201d \u0111\u1ec3 ti\u1ebfn h\u00e0nh \u201csetting\u201d c\u1ea5u h\u00ecnh s\u1eed d\u1ee5ng cho m\u00e1y t\u00ednh.<\/span><\/p>\n

\"tai-sql-10\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: \u1ede c\u1eeda s\u1ed5 \u0111\u1ea7u ti\u00ean, ng\u01b0\u1eddi d\u00f9ng c\u1ee9 b\u1ea5m ch\u1ecdn \u201cNext\u201d.<\/span><\/p>\n

\"tai-sql-11\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: H\u1ec7 th\u1ed1ng ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng ki\u1ec3m tra xem c\u1ea5u h\u00ecnh m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u1ea1t y\u00eau c\u1ea7u hay ch\u01b0a. Nh\u1eefng d\u1ea5u \u201ctick xanh\u201d \u0111\u1ed3ng vi\u1ec7c v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh \u0111\u00e3 \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c ti\u00eau ch\u00ed. Th\u00f4ng th\u01b0\u1eddng, nh\u1eefng m\u1ee5c \u201cFirewall\u201d s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 m\u00e0u v\u00e0ng, nh\u01b0ng b\u1ea1n h\u00e3y c\u1ee9 y\u00ean t\u00e2m m\u00e0 b\u1ea5m ch\u1ecdn \u201cNext\u201d.<\/span><\/p>\n

\"tai-sql-12\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: K\u1ebf \u0111\u1ebfn l\u00e0 b\u1ea1n ch\u1ecdn \u201cDeveloper\u201d \u1edf ph\u1ea7n \u201cProduct key\u201d \u0111\u1ec3 s\u1eed d\u1ee5ng mi\u1ec5n ph\u00ed ph\u1ea7n m\u1ec1m.<\/span><\/p>\n

\"tai-sql-13\"<\/picture><\/p>\n

B\u01b0\u1edbc 5: B\u1ea1n ti\u1ebfp t\u1ee5c ch\u1ecdn v\u00e0o \u201cI accept the license terms and Privacy Statement\u201d v\u00e0 \u201cNext\u201d.<\/span><\/p>\n

\"tai-sql-14\"<\/picture><\/p>\n

B\u01b0\u1edbc 6: T\u1ea1i ph\u1ea7n \u201cFeatures Selection\u201d, b\u1ea1n s\u1ebd ch\u1ecdn l\u1ea7n l\u01b0\u1ee3t v\u00e0o \u201cDatabase Engine Services, Data Quality Client v\u00e0 Client Tools Connectivity\u201d.<\/span><\/p>\n

\"tai-sql-15\"<\/picture><\/p>\n

B\u01b0\u1edbc 7: T\u1ea1i ph\u1ea7n \u201cInstance\u201d b\u1ea1n h\u00e3y \u0111\u1eb7t m\u1ed9t c\u00e1i t\u00ean t\u00f9y \u00fd, nh\u01b0ng l\u01b0u \u00fd l\u00e0 kh\u00f4ng c\u00f3 kho\u1ea3ng tr\u1ed1ng v\u00e0 d\u1ea5u nh\u00e9.<\/span><\/p>\n

\"tai-sql-16\"<\/picture><\/p>\n

B\u01b0\u1edbc 8: N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n <\/span>t\u1ea3i SQL Server 2019<\/b> th\u00e0nh c\u00f4ng th\u00ec \u1edf b\u01b0\u1edbc n\u00e0y b\u1ea1n c\u1ea7n click ch\u1ecdn ch\u1ee9c n\u0103ng \u201cMix Mode\u201d. T\u00ednh n\u0103ng n\u00e0y \u0111\u1ea3m b\u1ea3o vai tr\u00f2 b\u1ea3o m\u1eadt th\u00f4ng tin c\u1ee7a b\u1ea1n. Th\u1eadm ch\u00ed, b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0 click \u201cAdd current User\u201d \u0111\u1ec3 th\u00eam t\u00e0i kho\u1ea3n c\u1ee7a m\u00ecnh.\u00a0<\/span><\/p>\n

\"tai-sql-17\"<\/picture><\/p>\n

B\u01b0\u1edbc 9: \u0110\u1ebfn ph\u1ea7n cu\u1ed1i c\u00f9ng n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n ch\u1ecdn \u201cInstall\u201d v\u00e0 ch\u1edd trong \u00edt ph\u00fat \u0111\u1ec3 ph\u1ea7n m\u1ec1m \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp th\u00e0nh c\u00f4ng nh\u00e9.<\/span><\/p>\n

\"tai-sql-18\"<\/picture><\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea3i SQL Server Management Studio v\u00e0 c\u00e0i \u0111\u1eb7t phi\u00ean b\u1ea3n 2019<\/b><\/h2>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, ng\u01b0\u1eddi d\u00f9ng h\u00e3y nh\u1ea5n ch\u1ecdn v\u00e0o n\u00fat \u201cInstall SSMS\u201d \u0111\u1ec3 h\u1ec7 th\u1ed1ng t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u h\u01b0\u1edbng b\u1ea1n \u0111\u1ebf link t\u1ea3i file.<\/span><\/p>\n

\"tai-sql-19\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: T\u1ea1i \u0111\u00e2y, b\u1ea1n h\u00e3y ch\u00fa \u00fd \u0111\u1ebfn bi\u1ec3u t\u01b0\u1ee3ng \u201cDownload\u201d v\u00e0 nh\u1ea5n ch\u1ecdn v\u00e0o \u0111\u00f3.<\/span><\/p>\n

\"tai-sql-20\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Tr\u00ean file v\u1eeba t\u1ea3i v\u1ec1, ng\u01b0\u1eddi d\u00f9ng h\u00e3y nh\u1ea5n ch\u1ecdn \u201cInstall\u201d \u0111\u1ec3 ti\u1ebfn h\u00e0nh tr\u00ecnh c\u00e0i \u0111\u1eb7t giao di\u1ec7n c\u1ee7a ph\u1ea7n m\u1ec1m.<\/span><\/p>\n

\"tai-sql-22\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: Ngay khi c\u00e0i \u0111\u1eb7t xong th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m ch\u1ecdn \u201cClose\u201d \u0111\u1ec3 ch\u00ednh th\u1ee9c ho\u00e0n t\u1ea5t c\u00e1c thao t\u00e1c nh\u00e9.<\/span><\/p>\n

\"tai-sql-22\"<\/picture><\/p>\n

K\u1ebft lu\u1eadn<\/b><\/h2>\n

T\u00f3m l\u1ea1i, vi\u1ec7c <\/span>t\u1ea3i SQL Server tr\u00ean m\u00e1y t\u00ednh<\/b> l\u00e0 m\u1ed9t quy tr\u00ecnh kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n. V\u1edbi c\u00e1c b\u01b0\u1edbc r\u00f5 r\u00e0ng t\u1eeb vi\u1ec7c t\u1ea3i v\u1ec1 phi\u00ean b\u1ea3n SQL Server ph\u00f9 h\u1ee3p \u0111\u1ebfn c\u00e0i \u0111\u1eb7t v\u00e0 c\u1ea5u h\u00ecnh c\u01a1 s\u1edf d\u1eef li\u1ec7u. SQL Server mang l\u1ea1i nhi\u1ec1u t\u00ednh n\u0103ng m\u1ea1nh m\u1ebd cho ng\u01b0\u1eddi d\u00f9ng nh\u1eb1m \u0111\u00e1p \u1ee9ng nhu c\u1ea7u ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng, ph\u00e2n t\u00edch d\u1eef li\u1ec7u hay v\u1eadn h\u00e0nh c\u00e1c h\u1ec7 th\u1ed1ng l\u1edbn.<\/span><\/p>\n

Xem th\u00eam:<\/b><\/p>\n