{"id":5213,"date":"2018-09-23T21:05:45","date_gmt":"2018-09-23T14:05:45","guid":{"rendered":"https:\/\/tmp.phongvu.vn\/?p=5213"},"modified":"2018-09-23T21:28:58","modified_gmt":"2018-09-23T14:28:58","slug":"1800344-2","status":"publish","type":"post","link":"https:\/\/tmp.phongvu.vn\/hoi-dap\/1800344-2\/","title":{"rendered":"1800344"},"content":{"rendered":"

\u0110\u00e1nh gi\u00e1 s\u1ea3n ph\u1ea9m Ph\u1ea7n m\u1ec1m SQLCAL 2017 SNGL OLP<\/a> NL UsrCAL (359-06557)<\/strong><\/h2>\n

T\u1ed5ng quan v\u1ec1\u00a0SQL Server (OLP)<\/strong><\/h3>\n

SQL Server\u00a0hay Structure Query Language l\u00e0 c\u00f4ng c\u1ee5 qu\u1ea3n l\u00fd\u00a0d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong nhi\u1ec1u l\u0129nh v\u1ef1c. \u0110\u01b0\u1ee3c bi\u1ebft, h\u1ea7u h\u1ebft c\u00e1c ng\u00f4n ng\u1eef b\u1eadc cao \u0111\u1ec1u c\u00f3 tr\u00ecnh h\u1ed7 tr\u1ee3 SQL nh\u01b0\u00a0Visual C, Visual Basic, Oracle\u2026<\/p>\n

SQL Server \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n t\u1eeb ng\u00f4n ng\u1eef SEQUEL2 b\u1edfi IBM theo m\u00f4 h\u00ecnh Codd t\u1ea1i trung t\u00e2m nghi\u00ean c\u1ee9u c\u1ee7a IBM \u1edf California,v\u00e0o nh\u1eefng n\u0103m 70 cho\u00a0h\u1ec7 th\u1ed1ng\u00a0QTCSDL l\u1edbn.<\/p>\n

\u0110\u1ea7u ti\u00ean SQL Server \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c ng\u00f4n ng\u1eef qu\u1ea3n l\u00fd CSDL v\u00e0 ch\u1ea1y tr\u00ean c\u00e1c m\u00e1y \u0111\u01a1n l\u1ebb. Song do s\u1ef1 ph\u00e1t tri\u1ec3n nhanh ch\u00f3ng c\u1ee7a nhu c\u1ea7u x\u00e2y d\u1ef1ng nh\u1eefng CSDL l\u1edbn theo m\u00f4 h\u00ecnh kh\u00e1ch ch\u1ee7 (trong m\u00f4 h\u00ecnh n\u00e0y to\u00e0n b\u1ed9 CSDL \u0111\u01b0\u1ee3c t\u1eadp trung tr\u00ean m\u00e1y ch\u1ee7 (Server). M\u1ecdi thao t\u00e1c\u00a0x\u1eed l\u00fd d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean m\u00e1y ch\u1ee7 b\u1eb1ng c\u00e1c l\u1ec7nh SQL m\u00e1y tr\u1ea1m ch\u1ec9 d\u00f9ng \u0111\u1ec3 c\u1eadp nh\u1eadp ho\u1eb7c l\u1ea5y th\u00f4ng tin t\u1eeb m\u00e1y ch\u1ee7). Ng\u00e0y nay trong c\u00e1c\u00a0ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh b\u1eadc cao \u0111\u1ec1u c\u00f3 s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a SQL. Nh\u1ea5t l\u00e0 trong l\u0129nh v\u1ef1c ph\u00e1t tri\u1ec3n c\u1ee7a Internet ng\u00f4n ng\u1eef SQL c\u00e0ng \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng h\u01a1n. N\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 nhanh ch\u00f3ng t\u1ea1o c\u00e1c trang Web \u0111\u1ed9ng…<\/p>\n

SQL \u0111\u00e3 \u0111\u01b0\u1ee3c vi\u1ec7n ti\u00eau chu\u1ea9n qu\u1ed1c gia M\u1ef9 (ANSI) v\u00e0 t\u1ed5 ch\u1ee9c ti\u00eau chu\u1ea9n qu\u1ed1c t\u1ebf (ISO) ch\u1ea5p nh\u1eadn nh\u01b0 m\u1ed9t ng\u00f4n ng\u1eef chu\u1ea9n cho CSDL quan h\u1ec7. Nh\u01b0ng cho \u0111\u1ebfn nay chu\u1ea9n n\u00e0y ch\u01b0a \u0111\u01b0a ra \u0111\u1ee7 100%. N\u00ean c\u00e1c SQL nh\u00fang trong c\u00e1c ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh kh\u00e1c nhau \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ed5 xung m\u1edf r\u1ed9ng cho SQL chu\u1ea9n cho ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a m\u00ecnh. Do v\u1eady c\u00f3 s\u1ef1 kh\u00e1c nhau r\u00f5 r\u00e0ng gi\u1eefa c\u00e1c SQL.\"Ph\u1ea7n<\/p>\n

\u0110\u1eb7c \u0111i\u1ec3m c\u1ee7a SQL Server v\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0m vi\u1ec7c<\/h3>\n

SQL Server ho\u1ea1t \u0111\u1ed9ng theo m\u00f4 h\u00ecnh kh\u00e1ch – ch\u1ee7, do \u0111\u00f3 s\u1ebd c\u00f3 2 th\u00e0nh ph\u1ea7n l\u00e0\u00a0Workstation\u00a0<\/strong>v\u00e0\u00a0Server.<\/strong><\/p>\n

    \n
  • Workstation<\/strong>\u00a0\u0111\u01b0\u1ee3c c\u00e0i tr\u00ean b\u1ea5t k\u00ec thi\u1ebft b\u1ecb n\u00e0o ho\u1eb7c tr\u00ean thi\u1ebft b\u1ecb c\u1ee7a ng\u01b0\u1eddi v\u1eadn h\u00e0nh m\u00e1y ch\u1ee7. \u0110\u00e2y l\u00e0 c\u00e1c giao di\u1ec7n ph\u1ea7n m\u1ec1m \u0111\u1ec3 t\u01b0\u01a1ng t\u00e1c v\u1edbi Server, v\u00ed d\u1ee5 nh\u01b0 SSMS, SSCM, Profiler, BIDS hay SQLEM\u2026<\/li>\n
  • Server<\/strong>\u00a0\u0111\u01b0\u1ee3c c\u00e0i tr\u00ean m\u00e1y ch\u1ee7 t\u1eadp trung. N\u00f3 ch\u00ednh l\u00e0 c\u00e1c d\u1ecbch v\u1ee5 nh\u01b0 SQL Server, SQL Server Agent, SSIS, SSAS, SSRS, SQL Browser, SQL Full Text Search\u2026<\/li>\n<\/ul>\n

    Instance c\u1ee7a SQL Server<\/h3>\n
      \n
    • L\u00e0 m\u1ed9t b\u1ea3n c\u00e0i \u0111\u1eb7t SQL Server.<\/li>\n
    • L\u00e0 b\u1ea3n sao ch\u00e9p ch\u00ednh x\u00e1c c\u1ee7a ph\u1ea7n m\u1ec1m.<\/li>\n
    • N\u1ec1u c\u00e0i \u201cn\u201d l\u1ea7n th\u00ec s\u1ebd t\u1ea1o ra \u201cn\u201d b\u1ea3n c\u00e0i.<\/li>\n
    • C\u00f3 hai lo\u1ea1i b\u1ea3n c\u00e0i SQL Server l\u00e0 Default – M\u1eb7c \u0111\u1ecbnh v\u00e0 Named – \u0110\u1eb7t t\u00ean m\u1edbi.<\/li>\n
    • Ch\u1ec9 c\u00f3 m\u1ed9t b\u1ea3n c\u00e0i m\u1eb7c \u0111\u1ecbnh \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 tr\u00ean m\u1ed9t Server.<\/li>\n
    • Nhi\u1ec1u b\u1ea3n c\u00e0i t\u1ea1o m\u1edbi \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 tr\u00ean m\u1ed9t Server.<\/li>\n
    • B\u1ea3n c\u00e0i m\u1eb7c \u0111\u1ecbnh s\u1ebd l\u1ea5y t\u00ean m\u00e1y ch\u1ee7 l\u00e0m t\u00ean Instance.<\/li>\n
    • T\u00ean c\u1ee7a b\u1ea3n c\u00e0i m\u1eb7c \u0111\u1ecbnh l\u00e0 MSSQLSERVER.<\/li>\n<\/ul>\n

      L\u1ee3i \u00edch c\u1ee7a c\u00e1c b\u1ea3n c\u00e0i<\/h3>\n
        \n
      • C\u00e0i nhi\u1ec1u phi\u00ean b\u1ea3n MS SQL kh\u00e1c nhau tr\u00ean c\u00f9ng m\u1ed9t m\u00e1y.<\/li>\n
      • C\u1eaft gi\u1ea3m chi ph\u00ed.<\/li>\n
      • Duy tr\u00ec ri\u00eang bi\u1ec7t c\u00e1c m\u00f4i tr\u01b0\u1eddng s\u1ea3n xu\u1ea5t, ph\u00e1t tri\u1ec3n, th\u1eed nghi\u1ec7m.<\/li>\n
      • Gi\u1ea3m thi\u1ec3u c\u00e1c v\u1ea5n \u0111\u1ec1 t\u1ea1m th\u1eddi tr\u00ean c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/li>\n
      • T\u00e1ch bi\u1ec7t c\u00e1c \u0111\u1eb7c quy\u1ec1n b\u1ea3o m\u1eadt.<\/li>\n
      • Duy tr\u00ec m\u00e1y ch\u1ee7 d\u1ef1 ph\u00f2ng.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        \u0110\u00e1nh gi\u00e1 s\u1ea3n ph\u1ea9m Ph\u1ea7n m\u1ec1m SQLCAL 2017 SNGL OLP NL UsrCAL (359-06557) T\u1ed5ng quan v\u1ec1\u00a0SQL Server (OLP) SQL Server\u00a0hay Structure Query Language l\u00e0 c\u00f4ng c\u1ee5...<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19],"tags":[],"_links":{"self":[{"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/posts\/5213"}],"collection":[{"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/comments?post=5213"}],"version-history":[{"count":3,"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/posts\/5213\/revisions"}],"predecessor-version":[{"id":5224,"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/posts\/5213\/revisions\/5224"}],"wp:attachment":[{"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/media?parent=5213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/categories?post=5213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tmp.phongvu.vn\/hoi-dap\/wp-json\/wp\/v2\/tags?post=5213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}