Có 60+ tài liệu thuộc chủ đề "thiết kế CSDL quan hệ"
tailieu.vn Xem trực tuyến Tải xuống
Keep in mind that when a login is assigned to certain fixed server roles, they have implied permissions that cascade to the database level. For example, if a login is assigned to the sysadmin role, that login can perform any activity on the server, and it can also perform any action on any database on that server. Similarly, if a...
tailieu.vn Xem trực tuyến Tải xuống
If you select Deny Server Access, a command to deny access to SQL Server is issued immediately after the login is created (for example, DENY CONNECT SQL TO [DBSVRXP\Chris. This option can be useful for staging new logins and waiting until all the appropriate security has been applied prior to allowing the login to access your SQL Server instance. After...
tailieu.vn Xem trực tuyến Tải xuống
ptg FIGURE 11.10 Server-level permissions.. FIGURE 11.11 The Add Objects window.. All Objects of the Types option at the server level. You can see that the available objects are all scoped at the server level.. Figure 11.13 shows the Login Properties window with the endpoints securables populated. The TSQL Named Pipes securable is selected, which allows you to specify the...
tailieu.vn Xem trực tuyến Tải xuống
SQL Server 2008 continues the trend of providing more security and more flexible security to the SQL Server database environment. Several new enhancements have been added to SQL Server 2008 that add to the slew of security changes added to SQL Server 2005. The granularity of the permissions and the other security-related features covered in this chapter allow you to...
tailieu.vn Xem trực tuyến Tải xuống
As our first example, let’s keep things simple and look at how to encrypt a column using a passphrase. To do so, let’s look at the Sales.CreditCard table, which currently stores card numbers in cleartext:. select top 5 * from Sales.CreditCard go. Credit card numbers really should not be stored in their cleartext form in the database, so to fix...
tailieu.vn Xem trực tuyến Tải xuống
An example of backing up the master key is shown in the following SQL statement:. CHAPTER 12 Data Encryption. ptg Transparent Data Encryption 355. After creating the master key, you are able to create the TDE certificate from a backup of the certificate from the original SQL Server instance, as shown in the following example:. After the certificate is restored...
tailieu.vn Xem trực tuyến Tải xuống
Identity Access Management Components. One of the key areas identified in the security big picture (as you can see looking back at Figure 13.3) is identity management. It is key in the sense that well-managed identities are essential to well-managed security. Figure 13.4 shows a common “identity universe” for a company that has both internal- and external-facing applications. In other...
tailieu.vn Xem trực tuyến Tải xuống
ALTER SERVER AUDIT NEW_SQL_Server_Audit WITH (STATE = ON);. ALTER SERVER AUDIT NEW_SQL_Server_Audit WITH (STATE = OFF);. In other words, a user-defined variable is concate- nated with a partially defined SQL statement and then subsequently executed as part of the application. The hacker adds a terminating character to the first part of the input and then follows it up with his...
tailieu.vn Xem trực tuyến Tải xuống
ptg terms of server overhead because every transaction is captured and retained in the transac-. tion log so that they can be recovered in the event of a failure.. A common problem in SQL Server environments involves a database that is set to full recovery but whose transaction log is never backed up. In this scenario, the transaction log can...
tailieu.vn Xem trực tuyến Tải xuống
ptg 394 CHAPTER 14 Database Backup and Restore. FIGURE 14.4 Backing up the transaction log in SSMS.. Creating Transaction Log Backups with SSMS. Figure 14.4 shows the Back Up Database window with Transaction Log selected as the backup type. A device must be selected to write the backup to, and some additional options on the Options page that relate to...
tailieu.vn Xem trực tuyến Tải xuống
Restore a transaction log.. The following sections delve further into the restore options listed here. They focus on the means for accomplishing these restores and some of the common restore scenarios you might encounter.. The RESTORE command is similar to the BACKUP command in that it can be used to restore a database, part of a database, or a transaction...
tailieu.vn Xem trực tuyến Tải xuống
The number of scenarios is directly related to the types of backups taken and frequency of those backups.. The following sections describe a number of restore scenarios to give you a taste of the types of restores you may encounter. You can restore a database backup to a different database. These types of restores are common in development environ- ments...
tailieu.vn Xem trực tuyến Tải xuống
The frequency of changes to the data and method by which it is changed . Because SQL Server allows dynamic backups, users can still access the database during backups. After you establish your backup window, you can determine your backup method and schedule. For example, if it takes 4 hours for a full backup to complete, and the database is...
tailieu.vn Xem trực tuyến Tải xuống
ptg If the test fails, click Troubleshoot, and SMSS opens the “Troubleshooting Database Mail”. If the mail is sent by SQL Server and successfully received in your client software’s inbox, you can proceed to the next section to learn how to use the sp_send_dbmail stored proce- dure to send email from T-SQL. Otherwise, look for more troubleshooting help in the....
tailieu.vn Xem trực tuyến Tải xuống
DESCRIPTION: Error: 50000 Severity: 10 State: 1 This is an alert FIGURE 15.3 Creating a SQL Server event alert with a Database Mail notification.. exec msdb.dbo.sysmail_help_principalprofile_sp. FROM msdb.dbo.sysmail_account a JOIN msdb.dbo.sysmail_server s ON a.account_id = s.account_id JOIN msdb.dbo.sysmail_servertype st ON st.servertype = s.servertype. exec msdb.dbo.sysmail_help_configure_sp. SELECT mailitem_id, subject, sent_status FROM msdb.dbo.sysmail_allitems. sent 4 SQL Server Job System: ‘Database Mail Test...
tailieu.vn Xem trực tuyến Tải xuống
The SQL Server Agent can send email notifications. It utilizes an Extended Messaging Application Programming Interface (Extended MAPI) interface to send email and requires that you install an email application (such as Outlook) that supports Extended MAPI communication on the computer that is running SQL Server.. Database Mail, which is now the recommended mail solution for the SQL Server Agent,...
tailieu.vn Xem trực tuyến Tải xuống
For example, you might have a job step that tests for the existence of a file during a given period of the day. The job can be scheduled to start at a time of day when the file is expected. For example, if you want to check for the file for 2 hours, you can set Retry Attempts to 24...
tailieu.vn Xem trực tuyến Tải xuống
ptg 474 CHAPTER 16 SQL Server Scheduling and Notification. You can further define an alert response by using the Options page of an alert’s Properties window (see Figure 16.19).. You can include an alert’s error text in the operator notification message on this page.. You can also define additional notifica- tion text that is included when the message is sent....
tailieu.vn Xem trực tuyến Tải xuống
Some of the “core” cmdlets are typically used to do various tasks such as creating items like files and/or folders.. Snap-in—PowerShell functionality can be extended with the use of snap-ins. Aliases—Theseare shorter names that can be used for cmdlets. As mentioned earlier, PowerShell is built on the .NET Framework. A lot of the features within SQL Server (core engine, agent,...
tailieu.vn Xem trực tuyến Tải xuống
PS>add-content c:\temp\parameter.ps1 “`$args.count”. PS>add-content c:\temp\parameter.ps1 “`$args[0]”. PS>c:\temp\parameter.ps1 1 2 3 3. 1 PS>. In the preceding example, a two-line script is created, and then it is invoked while passing some arguments to it. $args.count displays the number of arguments passed to the script, whereas $args[0] displays the value of the first argument only.. The example is extended to show how...