{"id":15622,"date":"2018-07-03T08:00:55","date_gmt":"2018-07-03T03:30:55","guid":{"rendered":"https:\/\/www.apk.co.ir\/?post_type=manual_kb&p=15622"},"modified":"2018-07-11T13:24:52","modified_gmt":"2018-07-11T08:54:52","slug":"keeping-your-data-secure-with-sql-server-2016-part3","status":"publish","type":"manual_kb","link":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/","title":{"rendered":"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u0633\u0648\u0645"},"content":{"rendered":"

\"\u0628\u0631\u0631\u0633\u06cc<\/p>\n

\u062f\u0631 \u0642\u0633\u0645\u062a \u0627\u0648\u0644<\/a> \u0627\u0632 \u0645\u0642\u0627\u0644\u0647\u200c\u06cc \u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016\u060c \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0645\u0639\u0631\u0641\u06cc \u0627\u06cc\u0646 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0648 \u0628\u0631\u0631\u0633\u06cc \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u0622\u0646\u060c \u0628\u0647 \u0644\u0627\u06cc\u0647\u200c\u06cc \u062d\u0641\u0627\u0638\u062a \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0634\u062f \u0648 \u062f\u0631 \u0628\u062e\u0634 \u062f\u0648\u0645<\/a> \u0627\u0632 \u0627\u06cc\u0646 \u0645\u062c\u0645\u0648\u0639\u0647 \u0645\u0642\u0627\u0644\u0627\u062a\u060c \u0644\u0627\u06cc\u0647\u200c\u06cc \u062d\u0641\u0627\u0638\u062a \u0627\u0632 \u0634\u0628\u06a9\u0647\u200c\u06cc \u062f\u0627\u062f\u0647 \u0645\u0648\u0631\u062f \u0628\u0631\u0631\u0633\u06cc \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u06a9\u0647 \u0628\u062e\u0634 \u0633\u0648\u0645 \u0627\u0632 \u0627\u06cc\u0646 \u0645\u062c\u0645\u0648\u0639\u0647 \u0645\u06cc\u200c\u0628\u0627\u0634\u062f \u0628\u0647 \u0644\u0627\u06cc\u0647\u200c\u06cc \u062d\u0641\u0627\u0638\u062a \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n

\u062d\u0641\u0627\u0638\u062a \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0647\u0627 \u062f\u0631 SQL Server 2016<\/strong><\/h2>\n

\u062d\u0641\u0627\u0638\u062a \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0634\u062f\u06cc\u062f\u0627\u064b \u0628\u0647 \u062a\u0641\u06a9\u06cc\u06a9 Role\u200c\u0647\u0627 \u0648 \u0633\u0637\u0648\u062d \u062f\u0633\u062a\u0631\u0633\u06cc \u06cc\u0627 Permission \u06a9\u0647 \u0628\u0647 \u0627\u06cc\u0646 Role\u0647\u0627 \u0645\u0631\u0628\u0648\u0637 \u0647\u0633\u062a\u0646\u060c \u0648\u0627\u0628\u0633\u062a\u0647 \u0627\u0633\u062a. Role\u200c\u0647\u0627 \u0648 \u0633\u0637\u0648\u062d \u062f\u0633\u062a\u0631\u0633\u06cc \u0646\u0647 \u062a\u0646\u0647\u0627 \u062a\u0639\u06cc\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u06a9\u0647 \u0686\u0647 \u062f\u0627\u062f\u0647\u200c\u0627\u06cc \u0642\u0627\u0628\u0644 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0633\u062a\u060c \u0628\u0644\u06a9\u0647 \u062a\u0639\u06cc\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u06a9\u0647 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u0627\u062c\u0627\u0632\u0647\u200c\u06cc \u0627\u0646\u062c\u0627\u0645 \u0686\u0647 \u0627\u0639\u0645\u0627\u0644\u06cc \u0631\u0627 \u062f\u0631 \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0627\u0631\u062f \u0648 \u0627\u06cc\u0646\u06a9\u0647 \u0622\u06cc\u0627 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062d\u0633\u0627\u0633 \u0631\u0645\u0632\u200c\u06af\u0630\u0627\u0631\u06cc \u0646\u0634\u062f\u0647 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u062f \u0648 \u06cc\u0627 \u0631\u0648\u06cc Schema\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u0635\u0644\u0627\u062d\u0627\u062a\u06cc \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f \u06cc\u0627 \u062e\u06cc\u0631.<\/strong> \u0645\u062f\u06cc\u0631\u06cc\u062a Role \u0627\u06cc\u0645\u0646\u060c \u0628\u0631 \u0631\u0648\u06cc \u0641\u0631\u0627\u0647\u0645 \u06a9\u0631\u062f\u0646 \u062d\u062f\u0627\u0642\u0644 \u0633\u0637\u062d \u0627\u062c\u0627\u0632\u0647\u200c\u06cc \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u06cc\u06a9 Role \u0628\u062a\u0648\u0627\u0646\u062f Task\u0647\u0627\u06cc\u0634 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f\u060c \u062a\u0645\u0631\u06a9\u0632 \u062f\u0627\u0631\u062f. \u0628\u0627 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0646 \u062f\u0631 \u06cc\u06a9 \u0646\u0642\u0634 \u062f\u06cc\u06af\u0631 (Impersonation)\u060c \u0645\u062d\u0627\u0641\u0638\u062a \u0628\u06cc\u0634\u062a\u0631 \u0645\u0645\u06a9\u0646 \u0645\u06cc\u200c\u06af\u0631\u062f\u062f \u062a\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u0648\u0642\u062a \u0648 On-Demand\u060c \u0627\u062c\u0627\u0632\u0647\u200c\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0633\u0637\u062d \u0628\u0627\u0644\u0627 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f.<\/p>\n

\"\u0628\u0631\u0631\u0633\u06cc<\/p>\n

\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0639\u0645\u062f\u0647\u200c\u0641\u0631\u0648\u0634\u06cc \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u06a9\u0644\u06cc\u060c \u0628\u0631\u0627\u06cc \u062e\u0631\u062f\u0647\u200c\u0641\u0631\u0648\u0634\u0627\u0646 \u062f\u0631 \u0645\u0646\u0637\u0642\u0647 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u0646\u0645\u0627\u06cc\u062f. \u062f\u0631 \u0645\u0648\u0631\u062f \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc\u060c \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0646\u06cc\u0627\u0632\u200c\u0647\u0627\u06cc \u0645\u062a\u0641\u0627\u0648\u062a\u06cc \u062f\u0627\u0631\u0646\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 \u0645\u062f\u06cc\u0631\u0627\u0646 \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u0645\u0627\u0633 \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 \u0631\u0627 \u062d\u0641\u0638 \u06a9\u0631\u062f\u0647\u060c \u0628\u0647 \u067e\u0631\u062f\u0627\u062e\u062a\u200c\u0647\u0627 \u0631\u0633\u06cc\u062f\u06af\u06cc \u0646\u0645\u0648\u062f\u0647 \u0648 \u0633\u0641\u0627\u0631\u0634\u200c\u0647\u0627 \u0631\u0627 Log \u0645\u06cc\u200c\u0646\u0645\u0627\u06cc\u0646\u062f\u061b \u062f\u0631\u200c\u062d\u0627\u0644\u06cc \u06a9\u0647 \u0627\u0641\u0631\u0627\u062f \u062f\u0631 \u0628\u062e\u0634 \u0627\u062c\u0631\u0627\u060c \u0633\u0641\u0627\u0631\u0634\u0627\u062a \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0646\u0645\u0648\u062f\u0647\u060c \u0648\u0636\u0639\u06cc\u062a \u0631\u0627 \u0628\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u0645\u0648\u062c\u0648\u062f\u06cc \u06a9\u0627\u0644\u0627\u200c\u0647\u0627 \u0631\u0627 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc\u200c\u0646\u0645\u0627\u06cc\u0646\u062f. \u0647\u0631 \u062f\u0648 \u0628\u062e\u0634 \u062f\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0646\u06cc\u0627\u0632 \u0628\u0647 \u06af\u0632\u0627\u0631\u0634\u0627\u062a \u062f\u0648\u0631\u0647\u200c\u0627\u06cc \u062f\u0627\u0631\u0646\u062f. \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 \u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647\u200c\u06cc \u0641\u0627\u06a9\u062a\u0648\u0631\u200c\u0647\u0627\u060c \u0648\u0636\u0639\u06cc\u062a \u0633\u0641\u0627\u0631\u0634 \u0648 \u067e\u06cc\u0634\u06cc\u0646\u0647\u200c\u06cc \u0633\u0641\u0627\u0631\u0634 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0631\u0646\u062f. \u062a\u0639\u0627\u0645\u0644 \u0622\u0646\u200c\u0647\u0627 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647 \u0637\u0648\u0631 \u06af\u0633\u062a\u0631\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062a\u0639\u06cc\u06cc\u0646 Role \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0627\u0639\u0636\u0627\u06cc \u06af\u0631\u0648\u0647\u200c\u0647\u0627\u06cc Active Directory \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc\u200c\u06af\u0631\u062f\u062f (\u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 \u00ab\u0645\u0634\u062a\u0631\u06cc\u0627\u0646\u00bb\u060c \u00ab\u0645\u062f\u06cc\u0631\u0627\u0646 \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc\u00bb \u0648 \u00ab\u062a\u06cc\u0645 \u062a\u062d\u0648\u06cc\u0644\u00bb \u06a9\u0647 \u0628\u0647 \u0646\u0642\u0634\u200c\u0647\u0627\u06cc \u0645\u0634\u062e\u0635\u06cc \u062f\u0631 SQL Server\u060c Map \u0634\u062f\u0647\u200c\u0627\u0646\u062f).<\/p>\n

\u062f\u0631 \u0627\u06cc\u0646 \u0633\u0646\u0627\u0631\u06cc\u0648\u060c \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 Client \u0628\u0647 \u062c\u062f\u0627\u0648\u0644 \u062f\u0633\u062a\u0631\u0633\u06cc \u0646\u062f\u0627\u0631\u0646\u062f \u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 \u062a\u0648\u0627\u0646\u0627\u06cc\u06cc \u0627\u062c\u0631\u0627\u06cc \u00a0Query\u0647\u0627\u06cc \u0633\u0641\u0627\u0631\u0634\u06cc \u0631\u0627 \u0646\u062f\u0627\u0631\u0646\u062f. \u062f\u0631 \u0639\u0648\u0636 \u0646\u0645\u0627\u06cc\u0647\u200c\u0647\u0627 \u06cc\u0627 \u0641\u0631\u0627\u06cc\u0646\u062f\u200c\u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u0628\u0631\u0627\u06cc Role\u200c\u0647\u0627 \u0642\u0627\u0628\u0644 \u062f\u0633\u062a\u0631\u0633\u06cc \u0647\u0633\u062a\u0646\u062f \u0648 \u062f\u0631 \u0646\u062a\u06cc\u062c\u0647 \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u0645\u06cc\u200c\u06af\u0631\u062f\u062f \u06a9\u0647 \u062a\u0646\u0647\u0627 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc\u06cc \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0628\u0627\u0634\u0646\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062f\u0631 \u06cc\u06a9 Role \u062e\u0627\u0635 \u0645\u062f \u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u0646\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u062a\u06cc\u0645 \u062a\u062d\u0648\u06cc\u0644 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0646\u0645\u0627\u06cc\u0647\u200c\u0627\u06cc \u0631\u0627 \u06a9\u0647 \u062a\u0645\u0627\u0645 \u0633\u0641\u0627\u0631\u0634\u0627\u062a \u0628\u0627\u0632 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u062a\u0627\u0631\u06cc\u062e \u0645\u0642\u0635\u062f \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f\u060c \u062c\u0633\u062a\u062c\u0648 \u0646\u0645\u0627\u06cc\u0646\u062f\u060c \u062f\u0631\u062d\u0627\u0644\u06cc\u200c\u06a9\u0647 \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0641\u0631\u0627\u06cc\u0646\u062f\u200c\u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u06a9\u0647 \u0622\u062e\u0631\u06cc\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0633\u0641\u0627\u0631\u0634 \u0631\u0627 \u0628\u0627\u0632 \u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u0646\u062f\u060c \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f.<\/p>\n

\u062e\u062f\u0645\u0627\u062a IT \u0628\u0631\u0627\u06cc \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f\u06cc \u0646\u06cc\u0632 \u062f\u0627\u0631\u0627\u06cc Role \u0647\u0633\u062a\u0646\u062f. DBA\u0647\u0627 \u0633\u06cc\u0633\u062a\u0645 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0644\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f\u060c \u0627\u0645\u0627 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0642\u0627\u0628\u0644\u06cc\u062a \u0627\u06cc\u062c\u0627\u062f \u06cc\u0627 \u0645\u0634\u0627\u0647\u062f\u0647\u200c\u06cc \u0633\u0641\u0627\u0631\u0634\u0627\u062a \u062e\u0627\u0635 \u0646\u062f\u0627\u0631\u0646\u062f. \u06cc\u06a9 DBA \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u0645\u0627\u0698\u0648\u0644\u200c\u0647\u0627 (\u06a9\u0627\u0631\u0628\u0631\u062f\u200c\u0647\u0627\u060c \u0641\u0631\u0627\u06cc\u0646\u062f\u200c\u0647\u0627\u060c \u0635\u0641\u200c\u0647\u0627 \u06cc\u0627 Queue\u0647\u0627 \u0648 Trigger\u200c\u0647\u0627) \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0631 \u0646\u0642\u0634 \u06cc\u06a9 \u00ab\u0645\u0634\u062a\u0631\u06cc\u00bb \u06cc\u0627 \u00ab\u0645\u062f\u06cc\u0631 \u062d\u0633\u0627\u0628\u00bb \u0642\u0631\u0627\u0631 \u0628\u06af\u06cc\u0631\u0646\u062f \u062a\u0627 \u0639\u06cc\u0628\u200c\u06cc\u0627\u0628\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u0646\u062c\u0627\u0645 \u067e\u0630\u06cc\u0631\u062f. \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0646 \u062f\u0631 \u0646\u0642\u0634\u06cc \u062f\u06cc\u06af\u0631 \u062f\u0631 \u06cc\u06a9 \u0645\u0627\u0698\u0648\u0644 \u062a\u0648\u0627\u0646\u0627\u06cc\u06cc Elevation \u0631\u0627 \u062f\u0631 \u0645\u0627\u0698\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/strong> \u0627\u06cc\u0646 \u0645\u0627\u0698\u0648\u0644\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u06cc\u0627 \u0641\u0631\u0627\u06cc\u0646\u062f\u200c\u0647\u0627\u060c \u062f\u0633\u062a\u0631\u0633\u06cc \u0645\u0648\u0642\u062a\u06cc \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u0646\u0645\u0627\u06cc\u0646\u062f \u0627\u0645\u0627 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u067e\u0631\u0633\u200c\u0648\u200c\u062c\u0648\u0647\u0627\u06cc \u06a9\u0627\u0645\u0644\u0627\u064b Ad-Hoc \u0646\u062f\u0627\u0631\u0646\u062f. \u0628\u0647\u200c\u0639\u0644\u0627\u0648\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0637\u0631\u06cc\u0642 Just Enough Administration<\/a> \u06cc\u0627 JEA \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0627\u06a9\u062a\u06cc\u0648\u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0648\u06cc\u0646\u062f\u0648\u0632 \u0627\u0632 \u0627\u0641\u0632\u0627\u06cc\u0634 \u0633\u0637\u062d \u062f\u0633\u062a\u0631\u0633\u06cc \u0645\u0648\u0642\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f \u062a\u0627 \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0648\u06cc\u0646\u062f\u0648\u0632\u060c \u0633\u0637\u0648\u062d \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0631 SQL Server \u0646\u06cc\u0632 \u0627\u0631\u062a\u0642\u0627\u0621 \u06cc\u0627\u0628\u062f. \u062f\u0631 \u0633\u0637\u062d \u062d\u0641\u0627\u0638\u062a Database-Host \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f Active Directory \u0648 JEA \u0628\u062d\u062b \u0645\u06cc\u200c\u06af\u0631\u062f\u062f. \u0641\u0631\u0627\u06cc\u0646\u062f\u200c\u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u0628\u0627 DBA \u0645\u0634\u062e\u0635\u060c \u062a\u0648\u0627\u0646\u0627\u06cc\u06cc\u00a0 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0646 \u062f\u0631 \u06cc\u06a9 Role \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0648\u0642\u062a \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u0646\u0645\u0627\u06cc\u0646\u062f \u062a\u0627 \u062f\u0631 \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f\u0646 \u0639\u0644\u0644 \u06a9\u0627\u0647\u0634 \u0633\u0637\u062d \u0639\u0645\u0644\u06a9\u0631\u062f\u060c \u0645\u0624\u062b\u0631 \u0648\u0627\u0642\u0639 \u0634\u0648\u062f. \u0628\u0627 Always Encrypted \u06cc\u0627 CLE\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062d\u0633\u0627\u0633 \u0645\u0627\u0646\u0646\u062f \u062a\u0645\u0627\u0633 \u0645\u0634\u062a\u0631\u06cc \u06cc\u0627 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u067e\u0631\u062f\u0627\u062e\u062a \u0631\u0645\u0632\u06af\u0630\u0627\u0631\u06cc \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u062f\u0631 \u0646\u062a\u06cc\u062c\u0647 \u0627\u0645\u06a9\u0627\u0646 \u0639\u06cc\u0628\u200c\u06cc\u0627\u0628\u06cc \u062f\u0642\u06cc\u0642 \u0628\u062f\u0648\u0646 \u062f\u0631 \u062e\u0637\u0631 \u0627\u0646\u062f\u0627\u062e\u062a\u0646 \u0627\u0645\u0646\u06cc\u062a \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06af\u0631\u062f\u062f.<\/p>\n

\u0645\u062f\u06cc\u0631\u0627\u0646 \u0645\u0645\u06cc\u0632\u06cc\u060c \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u0645\u0645\u06cc\u0632\u06cc\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0639\u0644\u0627\u0645\u062a\u200c\u06af\u0630\u0627\u0631\u06cc (Flagging) \u0641\u0639\u0627\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631\u0639\u0627\u062f\u06cc \u062d\u0641\u0638 \u0645\u06cc\u200c\u0646\u0645\u0627\u06cc\u0646\u062f. \u0645\u062f\u06cc\u0631 \u0645\u0645\u06cc\u0632\u06cc \u0628\u0647 \u0642\u0627\u0628\u0644\u06cc\u062a \u0633\u0627\u062e\u062a \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u0645\u06cc\u0632\u06cc\u200c\u0647\u0627 \u0648 Trigger\u0647\u0627 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f. \u0641\u0631\u062f\u06cc \u06a9\u0647 \u0645\u0645\u06cc\u0632\u06cc \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u062f\u0647\u062f Trigger\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0628\u0647 \u062a\u06cc\u0645 \u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u0633\u0627\u0626\u0644\u06cc \u0628\u0647 \u062f\u0644\u0627\u06cc\u0644 \u0645\u062e\u062a\u0644\u0641 \u0647\u0634\u062f\u0627\u0631 \u0645\u06cc\u200c\u062f\u0647\u062f. \u062f\u0644\u0627\u06cc\u0644\u06cc \u0645\u0627\u0646\u0646\u062f \u0645\u062c\u0645\u0648\u0639 \u0633\u0641\u0627\u0631\u0634\u0627\u062a\u06cc \u06a9\u0647 \u0627\u0632 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u06cc \u062e\u0627\u0635\u06cc \u0641\u0631\u0627\u062a\u0631 \u0645\u06cc\u200c\u0631\u0648\u062f\u060c \u0633\u0641\u0627\u0631\u0634\u0627\u062a \u0628\u0627\u0632 \u0631\u0627\u06a9\u062f (Stagnated) \u0648 \u06cc\u0627 \u0639\u0644\u0627\u0626\u0645\u06cc \u0627\u0632 \u0641\u0639\u0627\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc DBA \u0645\u062e\u0631\u0628.<\/strong><\/p>\n

\u062d\u0641\u0627\u0638\u062a \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0647 \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627 \u0648 \u0634\u06cc\u0648\u0647\u200c\u0647\u0627\u06cc\u06cc \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u0645\u062a\u0641\u0627\u0648\u062a \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627 \u0647\u0645\u0686\u0648\u0646 \u06a9\u0646\u062a\u0631\u0644 \u062f\u0633\u062a\u0631\u0633\u06cc\u060c \u0631\u0645\u0632\u06af\u0630\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0648 \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0622\u06cc\u0646\u062f\u0647\u200c\u0646\u06af\u0631\u0627\u0646\u0647\u200c \u062a\u06a9\u06cc\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062a\u0641\u06a9\u06cc\u06a9 Role\u200c\u0647\u0627 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062d\u0633\u0627\u0628\u200c\u0634\u062f\u0647\u200c\u06cc \u0633\u0637\u0648\u062d \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0631 \u0645\u062d\u0627\u0641\u0638\u062a \u0627\u0632 \u062f\u0627\u062f\u0647 \u062f\u0631 \u0645\u0642\u0627\u0628\u0644 \u0645\u062f\u06cc\u0631\u0627\u0646 \u0645\u062a\u062e\u0644\u0641 \u0648 \u062f\u0631 \u0639\u06cc\u0646\u200c\u062d\u0627\u0644 \u0641\u0631\u0627\u0647\u0645 \u0622\u0648\u0631\u062f\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u0646\u0627\u0633\u0628 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646\u060c \u0627\u0645\u0631\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u0627\u0633\u062a. \u0627\u0631\u0627\u0626\u0647 \u062f\u0627\u062f\u0646 \u062d\u062f\u0627\u0642\u0644 \u0627\u062c\u0627\u0632\u0647\u200c\u0647\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646\u060c \u062f\u0631 \u0645\u0642\u0627\u0628\u0644 \u062d\u0645\u0644\u0647 \u0627\u0632 \u0622\u0646\u200c\u0647\u0627 \u0645\u062d\u0627\u0641\u0638\u062a \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0646 \u062f\u0631 \u0646\u0642\u0634\u06cc \u062f\u06cc\u06af\u0631\u060c \u062f\u0633\u062a\u0631\u0633\u06cc \u0645\u0648\u0642\u062a \u0648 \u0646\u0638\u0627\u0631\u062a\u200c\u0634\u062f\u0647\u200c\u0627\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u0627\u0646 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u0646\u0645\u0627\u06cc\u062f \u062a\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0646\u06cc\u0627\u0632\u060c \u0628\u062f\u0648\u0646 \u0627\u0639\u0637\u0627 \u06a9\u0631\u062f\u0646 \u0627\u062c\u0627\u0632\u0647\u200c\u0647\u0627\u06cc Full-Time\u060c \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627 \u0631\u0627 \u0639\u06cc\u0628\u200c\u06cc\u0627\u0628\u06cc \u06a9\u0646\u0646\u062f. \u0641\u0631\u0627\u06cc\u0646\u062f\u200c\u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0646\u0642\u0627\u0637 \u0648\u0631\u0648\u062f\u06cc \u0628\u0631\u0627\u06cc \u0627\u0642\u062f\u0627\u0645\u0627\u062a \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u06cc\u06cc\u0646 \u0634\u062f\u0647 \u0627\u0639\u0645\u0627\u0644 \u0634\u0648\u0646\u062f\u060c \u0628\u0647 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u062a\u0648\u0627\u0646\u0627\u06cc\u06cc \u0641\u0631\u0627\u0647\u0645 \u0622\u0648\u0631\u062f\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f\u06cc \u0647\u062f\u0641\u200c\u062f\u0627\u0631 \u0631\u0627 \u0628\u062f\u0648\u0646 \u0628\u0647 \u062e\u0637\u0631 \u0627\u0646\u062f\u0627\u062e\u062a\u0646 \u0627\u0645\u0646\u06cc\u062a \u0645\u06cc\u200c\u062f\u0647\u0646\u062f.<\/strong> \u0645\u0645\u06cc\u0632\u06cc \u0628\u0647 \u0645\u062f\u06cc\u0631\u0627\u0646 \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u0648\u062f\u0647\u0646\u06af\u0627\u0645\u060c \u0631\u06cc\u0633\u06a9\u200c\u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u0628\u0627\u0644\u0642\u0648\u0647 \u0631\u0627 \u062a\u0634\u062e\u06cc\u0635 \u062f\u0647\u0646\u062f. \u0627\u06cc\u0646 \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627 \u0648 \u0631\u0648\u0634\u200c\u0647\u0627 \u062f\u0631 \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u0628\u0647 \u0628\u0627\u0644\u0627 \u0628\u0631\u062f\u0646 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u062f\u0631 \u0627\u0645\u0646\u06cc\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0648 \u0631\u0633\u0627\u0646\u062f\u0646 \u0622\u0646 \u0628\u0647 \u0633\u0637\u062d\u06cc \u062a\u0627\u0632\u0647 \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f.<\/p>\n

\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640\u0640<\/p>\n

\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u0627\u0648\u0644<\/a><\/p>\n

\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u062f\u0648\u0645<\/a><\/p>\n

\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u0633\u0648\u0645<\/a><\/p>\n

\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u0686\u0647\u0627\u0631\u0645 (\u067e\u0627\u06cc\u0627\u0646\u06cc)<\/a><\/p>\n","protected":false},"author":1001543,"featured_media":15627,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[2974],"manual_kb_tag":[7092,7106,3991,7093,7107,3993,7094,7108,3997,7095,7109,3999,7096,7111,4001,7097,7113,4006,7098,7151,4008,7099,7152,7089,7100,7153,7090,7101,3984,7154,7091,7104,3989,7155],"class_list":{"0":"post-15622","1":"manual_kb","2":"type-manual_kb","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"manualknowledgebasecat-services","8":"manual_kb_tag----sql-server-2016","9":"manual_kb_tag---sql-server","10":"manual_kb_tag--sql-server-2016","12":"manual_kb_tag--always-encrypted","13":"manual_kb_tag-sql-server-2016-","14":"manual_kb_tag---sql-server-2016","15":"manual_kb_tag---always-encrypted","24":"manual_kb_tag----always-encrypted","27":"manual_kb_tag-just-enough-administration-","30":"manual_kb_tag-jea-","33":"manual_kb_tag--just-enough-administration","35":"manual_kb_tag-7101","39":"manual_kb_tag--ddm--sql-2016","41":"manual_kb_tag--jea"},"yoast_head":"\n\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 - \u0642\u0633\u0645\u062a \u0633\u0648\u0645<\/title>\n<meta name=\"description\" content=\"\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 SQL Server 2016 \u0686\u06cc\u0633\u062a\u061f \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u0627\u0645\u0646\u06cc\u062a \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u062d\u062b \u0644\u0627\u06af\u06cc\u0646 \u06a9\u0631\u062f\u0646 \u0645\u062f\u06cc\u0631\u0627\u0646 DB \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u0634\u0648\u062f \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0628\u0627 AD \u0635\u0648\u0631\u062a \u06af\u06cc\u0631\u062f\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 - \u0642\u0633\u0645\u062a \u0633\u0648\u0645\" \/>\n<meta property=\"og:description\" content=\"\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 SQL Server 2016 \u0686\u06cc\u0633\u062a\u061f \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u0627\u0645\u0646\u06cc\u062a \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u062d\u062b \u0644\u0627\u06af\u06cc\u0646 \u06a9\u0631\u062f\u0646 \u0645\u062f\u06cc\u0631\u0627\u0646 DB \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u0634\u0648\u062f \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0628\u0627 AD \u0635\u0648\u0631\u062a \u06af\u06cc\u0631\u062f\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0627\u0645\u0646 \u067e\u0627\u06cc\u0647 \u0631\u06cc\u0632\u0627\u0646 \u06a9\u0627\u0631\u0646 | APK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/apkco\/\" \/>\n<meta property=\"article:modified_time\" content=\"2018-07-11T08:54:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"638\" \/>\n\t<meta property=\"og:image:height\" content=\"359\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/\"},\"author\":{\"name\":\"Bita Sabet\",\"@id\":\"https:\/\/www.apk.co.ir\/#\/schema\/person\/65ac802bcaa7a9ec2d218113a8966f44\"},\"headline\":\"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u0633\u0648\u0645\",\"datePublished\":\"2018-07-03T03:30:55+00:00\",\"dateModified\":\"2018-07-11T08:54:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/\"},\"wordCount\":70,\"publisher\":{\"@id\":\"https:\/\/www.apk.co.ir\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg\",\"inLanguage\":\"fa-IR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/\",\"url\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/\",\"name\":\"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 - \u0642\u0633\u0645\u062a \u0633\u0648\u0645\",\"isPartOf\":{\"@id\":\"https:\/\/www.apk.co.ir\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg\",\"datePublished\":\"2018-07-03T03:30:55+00:00\",\"dateModified\":\"2018-07-11T08:54:52+00:00\",\"description\":\"\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 SQL Server 2016 \u0686\u06cc\u0633\u062a\u061f \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u0627\u0645\u0646\u06cc\u062a \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u062d\u062b \u0644\u0627\u06af\u06cc\u0646 \u06a9\u0631\u062f\u0646 \u0645\u062f\u06cc\u0631\u0627\u0646 DB \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u0634\u0648\u062f \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0628\u0627 AD \u0635\u0648\u0631\u062a \u06af\u06cc\u0631\u062f\",\"breadcrumb\":{\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#primaryimage\",\"url\":\"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg\",\"contentUrl\":\"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg\",\"width\":638,\"height\":359,\"caption\":\"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u062e\u0627\u0646\u0647\",\"item\":\"https:\/\/www.apk.co.ir\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u0633\u0648\u0645\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.apk.co.ir\/#website\",\"url\":\"https:\/\/www.apk.co.ir\/\",\"name\":\"\u0627\u0645\u0646 \u067e\u0627\u06cc\u0647 \u0631\u06cc\u0632\u0627\u0646 \u06a9\u0627\u0631\u0646 | APK\",\"description\":\"\u0641\u0646\u0627\u0648\u0631\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u060c \u0627\u0645\u0646\u06cc\u062a\u060c \u0634\u0628\u06a9\u0647\u060c \u0645\u062c\u0627\u0632\u06cc \u0633\u0627\u0632\u06cc\u060c \u062f\u06cc\u062a\u0627\u0633\u0646\u062a\u0631\",\"publisher\":{\"@id\":\"https:\/\/www.apk.co.ir\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.apk.co.ir\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fa-IR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.apk.co.ir\/#organization\",\"name\":\"\u0627\u0645\u0646 \u067e\u0627\u06cc\u0647 \u0631\u06cc\u0632\u0627\u0646 \u06a9\u0627\u0631\u0646 | APK\",\"url\":\"https:\/\/www.apk.co.ir\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/www.apk.co.ir\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2016\/08\/apk-logo-black.png\",\"contentUrl\":\"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2016\/08\/apk-logo-black.png\",\"width\":800,\"height\":158,\"caption\":\"\u0627\u0645\u0646 \u067e\u0627\u06cc\u0647 \u0631\u06cc\u0632\u0627\u0646 \u06a9\u0627\u0631\u0646 | APK\"},\"image\":{\"@id\":\"https:\/\/www.apk.co.ir\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/apkco\/\",\"https:\/\/www.instagram.com\/apk.co\/\",\"https:\/\/www.linkedin.com\/company\/apkco\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.apk.co.ir\/#\/schema\/person\/65ac802bcaa7a9ec2d218113a8966f44\",\"name\":\"Bita Sabet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/www.apk.co.ir\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/021ca8180ba75921263e16fc2ba56e21?s=96&d=mm&r=r\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/021ca8180ba75921263e16fc2ba56e21?s=96&d=mm&r=r\",\"caption\":\"Bita Sabet\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 - \u0642\u0633\u0645\u062a \u0633\u0648\u0645","description":"\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 SQL Server 2016 \u0686\u06cc\u0633\u062a\u061f \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u0627\u0645\u0646\u06cc\u062a \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u062d\u062b \u0644\u0627\u06af\u06cc\u0646 \u06a9\u0631\u062f\u0646 \u0645\u062f\u06cc\u0631\u0627\u0646 DB \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u0634\u0648\u062f \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0628\u0627 AD \u0635\u0648\u0631\u062a \u06af\u06cc\u0631\u062f","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/","og_locale":"fa_IR","og_type":"article","og_title":"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 - \u0642\u0633\u0645\u062a \u0633\u0648\u0645","og_description":"\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 SQL Server 2016 \u0686\u06cc\u0633\u062a\u061f \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u0627\u0645\u0646\u06cc\u062a \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u062d\u062b \u0644\u0627\u06af\u06cc\u0646 \u06a9\u0631\u062f\u0646 \u0645\u062f\u06cc\u0631\u0627\u0646 DB \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u0634\u0648\u062f \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0628\u0627 AD \u0635\u0648\u0631\u062a \u06af\u06cc\u0631\u062f","og_url":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/","og_site_name":"\u0627\u0645\u0646 \u067e\u0627\u06cc\u0647 \u0631\u06cc\u0632\u0627\u0646 \u06a9\u0627\u0631\u0646 | APK","article_publisher":"https:\/\/www.facebook.com\/apkco\/","article_modified_time":"2018-07-11T08:54:52+00:00","og_image":[{"width":638,"height":359,"url":"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#article","isPartOf":{"@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/"},"author":{"name":"Bita Sabet","@id":"https:\/\/www.apk.co.ir\/#\/schema\/person\/65ac802bcaa7a9ec2d218113a8966f44"},"headline":"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u0633\u0648\u0645","datePublished":"2018-07-03T03:30:55+00:00","dateModified":"2018-07-11T08:54:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/"},"wordCount":70,"publisher":{"@id":"https:\/\/www.apk.co.ir\/#organization"},"image":{"@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg","inLanguage":"fa-IR"},{"@type":"WebPage","@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/","url":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/","name":"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 - \u0642\u0633\u0645\u062a \u0633\u0648\u0645","isPartOf":{"@id":"https:\/\/www.apk.co.ir\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#primaryimage"},"image":{"@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg","datePublished":"2018-07-03T03:30:55+00:00","dateModified":"2018-07-11T08:54:52+00:00","description":"\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 SQL Server 2016 \u0686\u06cc\u0633\u062a\u061f \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u0627\u0645\u0646\u06cc\u062a \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u062d\u062b \u0644\u0627\u06af\u06cc\u0646 \u06a9\u0631\u062f\u0646 \u0645\u062f\u06cc\u0631\u0627\u0646 DB \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u0634\u0648\u062f \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0628\u0627 AD \u0635\u0648\u0631\u062a \u06af\u06cc\u0631\u062f","breadcrumb":{"@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/"]}]},{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#primaryimage","url":"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg","contentUrl":"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2018\/07\/SQL2016Sec-00.jpg","width":638,"height":359,"caption":"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016"},{"@type":"BreadcrumbList","@id":"https:\/\/www.apk.co.ir\/kb\/keeping-your-data-secure-with-sql-server-2016-part3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u062e\u0627\u0646\u0647","item":"https:\/\/www.apk.co.ir\/"},{"@type":"ListItem","position":2,"name":"\u0628\u0631\u0631\u0633\u06cc \u0627\u0645\u0646\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL Server 2016 – \u0642\u0633\u0645\u062a \u0633\u0648\u0645"}]},{"@type":"WebSite","@id":"https:\/\/www.apk.co.ir\/#website","url":"https:\/\/www.apk.co.ir\/","name":"\u0627\u0645\u0646 \u067e\u0627\u06cc\u0647 \u0631\u06cc\u0632\u0627\u0646 \u06a9\u0627\u0631\u0646 | APK","description":"\u0641\u0646\u0627\u0648\u0631\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u060c \u0627\u0645\u0646\u06cc\u062a\u060c \u0634\u0628\u06a9\u0647\u060c \u0645\u062c\u0627\u0632\u06cc \u0633\u0627\u0632\u06cc\u060c \u062f\u06cc\u062a\u0627\u0633\u0646\u062a\u0631","publisher":{"@id":"https:\/\/www.apk.co.ir\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.apk.co.ir\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fa-IR"},{"@type":"Organization","@id":"https:\/\/www.apk.co.ir\/#organization","name":"\u0627\u0645\u0646 \u067e\u0627\u06cc\u0647 \u0631\u06cc\u0632\u0627\u0646 \u06a9\u0627\u0631\u0646 | APK","url":"https:\/\/www.apk.co.ir\/","logo":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/www.apk.co.ir\/#\/schema\/logo\/image\/","url":"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2016\/08\/apk-logo-black.png","contentUrl":"https:\/\/www.apk.co.ir\/wp-content\/uploads\/2016\/08\/apk-logo-black.png","width":800,"height":158,"caption":"\u0627\u0645\u0646 \u067e\u0627\u06cc\u0647 \u0631\u06cc\u0632\u0627\u0646 \u06a9\u0627\u0631\u0646 | APK"},"image":{"@id":"https:\/\/www.apk.co.ir\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/apkco\/","https:\/\/www.instagram.com\/apk.co\/","https:\/\/www.linkedin.com\/company\/apkco"]},{"@type":"Person","@id":"https:\/\/www.apk.co.ir\/#\/schema\/person\/65ac802bcaa7a9ec2d218113a8966f44","name":"Bita Sabet","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/www.apk.co.ir\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/021ca8180ba75921263e16fc2ba56e21?s=96&d=mm&r=r","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/021ca8180ba75921263e16fc2ba56e21?s=96&d=mm&r=r","caption":"Bita Sabet"}}]}},"_links":{"self":[{"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/manual_kb\/15622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/users\/1001543"}],"version-history":[{"count":0,"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/manual_kb\/15622\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/media\/15627"}],"wp:attachment":[{"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/media?parent=15622"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/manualknowledgebasecat?post=15622"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/www.apk.co.ir\/wp-json\/wp\/v2\/manual_kb_tag?post=15622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}