Có 160+ tài liệu thuộc chủ đề "database SQL"
tailieu.vn Xem trực tuyến Tải xuống
122 Chapter 3 • Configuring SQL Server 2008. The SQL Server Configuration Manager. MCTS SQL Server 2008 Exam 432. Logins and Users will be covered, as well as SQL Server 2008’s built-in roles.. The SQL Server Surface Area Configuration tool will be covered as well as the provisioning of the accounts used for SQL Server Services.. As we begin to...
tailieu.vn Xem trực tuyến Tải xuống
Although you are limited to the built-in server-level roles, you can create new database-level roles in addition to those available to suit more specific needs.. SQL Server logins, Windows accounts, and Windows groups can be added to server-level roles. Server-level roles are as follows:. sysadmin – Perform any activity in the server. reset passwords for SQL Server logins and GRANT,...
tailieu.vn Xem trực tuyến Tải xuống
If the user does not need to do sysadmin tasks, the user should not be added to the sysadmin group. Be familiar with the “Principle of Least Privilege” and how that applies to granting permissions to SQL Server resources.. Users can be added to a database using the SQL Server Management Studio or by syntax such as:. As demonstrated in...
tailieu.vn Xem trực tuyến Tải xuống
You need to add a new SQL Server Login and it will be mapped to a domain account and be set up to access the AdventureWorks2008 database.. in the SQL Server Management Studio, locate the security folder at the instance level.. in the “Login – New” window in the general section locate the domain account that you need to map...
tailieu.vn Xem trực tuyến Tải xuống
Transact-SQL and common language runtime (CLR), and columns, Views and columns. REFERENCES Scalar and aggregate functions (Transact – SQL and CLR), Service Broker queues, Tables and columns, Table-valued functions (Transact – SQL and CLR), and columns, Views and columns. EXECUTE Procedures (Transact – SQL and CLR), Scalar and aggregate functions (Transact – SQL and CLR), Synonyms. VIEW DEFINITION Procedures (Transact...
tailieu.vn Xem trực tuyến Tải xuống
'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\. change Data capture (cDc). New in SQL Server 2008 and only available in the Developer, Enterprise, and Evaluation additions, Change data capture (CDC) can be implemented to capture INSERT, UPDATE, and DELETE activity applied to SQL Server tables from the SQL Server transaction log. Change Data Capture (CDC). cDc functionality is new in SQL Server 2008,...
tailieu.vn Xem trực tuyến Tải xuống
You have just installed SQL Server 2008 and you are upgrading databases from SQL Server 2005. in the SQL Server Management Studio, right-click on the server that you wish to enable the DatabaseMail feature.. SQL Server job steps often need to do more than just execute Transact-SQL.. SQL Server Agent Proxies mapped to the appropriate credentials necessary can be created...
tailieu.vn Xem trực tuyến Tải xuống
Open up the SQL Server configuration Manager.. click on SQL Server Services as in Figure 4.14.. Right-click on SQL Server Agent and click Properties.. This is where you would change the Start Mode in order to enable SQL Server Agent.. Exit the SQL Server configuration Manager.. There are a few restrictions to which account types can be used by SQL...
tailieu.vn Xem trực tuyến Tải xuống
Which of the following is considered a Principal?. SQL Server. SQL Server Integration Services C. SQL Server Login. SQL Server Agent. Which of the following is a securable object in a database schema?. Which of the following fixed server-level roles enables a member to add and remove linked servers?. You have a team member who needs the ability to manage...
tailieu.vn Xem trực tuyến Tải xuống
Understanding Transparent Data Encryption. Managing Data Encryption. 170 Chapter 5 • Managing Data Encryption. Many enhancements have been made to SQL Server 2008 in area data encryption.. Transparent Data Encryption. SQL Server 2008 introduced transparent data encryption (TDE) to provide the ability to encrypt entire databases, data, and log files without the requirement of application changes and with minimal performance...
tailieu.vn Xem trực tuyến Tải xuống
The SQL Server 2008 Enterprise and Developer editions only support TDE.. The steps to enable TDE on a database consist of the following:. Creating a service master key at the database instance.. Creating a database master key and associated certificate in the master database.. Creating a database encryption key in the user database to be encrypted.. Before describing the mechanics...
tailieu.vn Xem trực tuyến Tải xuống
based-security modules to interface with SQL server to externally manage the encryption keys as well as enable encryption and decryption.. The algorithms supported by SQL Server are: WITH ALGORITHM = {AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY}. Managing SQL Server keys consists of creating, deleting, and modifying database keys, as well as backing up and restoring database keys.. To manage...
tailieu.vn Xem trực tuyến Tải xuống
It is recommended best practice to back up the keys and certificates in SQL Server. Third-Party Encryption Tools. SQL Server 2008 introduced Extensible Key Management (EKM). EKM provides an interface for third-party vendors to manage and store encryption keys outside of the database. EKM also enables third-party vendors to register their modules in SQL Server. Once registered, SQL Server can...
tailieu.vn Xem trực tuyến Tải xuống
DPAPI is the top level of the TDE encryption hierarchy and is used by SQL Server to protect the service master key (SMK) for the database instance. In TDE, the SMK is used to protect the next level of the SQL Server encryption hierarchy, specifically the database master key (DMK), and is stored in the master database. The last encryption...
tailieu.vn Xem trực tuyến Tải xuống
192 Chapter 5 • Managing Data Encryption. An asymmetric key uses the same password to encrypt and decrypt the data and a symmetric key uses a private key to encrypt and a public key to decrypt the data.. A symmetric key uses the same password to encrypt and decrypt the data and an asymmetric key uses a public key to...
tailieu.vn Xem trực tuyến Tải xuống
Although there is no performance benefit when using this RAID level, the data is fully protected since if either hard drive fails the data is still available by the use of the hard drive that has not failed. This is one of the most expensive RAID options available to you because you are paying for two hard drives and only...
tailieu.vn Xem trực tuyến Tải xuống
If you wish to configure a remote instance to monitor the log shipping then check the Use a monitor server instance check box (which is unchecked in Figure 6.3) and click the Settings button. On the Log Shipping Monitor Settings page that appears, select the Instance to Monitor Log Shipping and click OK.. For additional redundancy you can ship your...
tailieu.vn Xem trực tuyến Tải xuống
Once you get the Database Mirroring page on the screen, the first thing you must do is click the Configure Security button. On the next page you are asked to configure the Database Mirroring Endpoint as shown in Figure 6.5. Figure 6.4 Database Mirroring Menu. Figure 6.5 Database Mirroring Principle Server Endpoint Configuration. Although this is not required it is...
tailieu.vn Xem trực tuyến Tải xuống
There are two ways to manually fail over a database. You can either bring up the database mirroring properties (see Figure 6.8) and click the Fail over button, or you can use the ALTER DATABASE command to failover the database as shown here. If the mirror is completely caught up with all the transactions then the database will fail over.....
tailieu.vn Xem trực tuyến Tải xuống
In the example shown in Figure 6.12 an existing Resource Group was selected.. This Resource Group was created before the SQL Server 2008 installer was launched and this Resource Group has the disks already located in it.. Resource Group During Installation. The ability to create the cluster resource group and select the disks for the Resource Group during the SQL...