« Home « Chủ đề SQL căn bản

Chủ đề : SQL căn bản


Có 140+ tài liệu thuộc chủ đề "SQL căn bản"

The Best Damn Windows Server 2003 Book Period- P13

tailieu.vn

A system configured with the Default security template or not configured with any security modifications will send LAN Manager and NTLM responses. Security settings deter- mine which authentication protocol is used for network logons.The security settings determine the authentication protocol used by clients, the level of security negotiated, and the level of authentica- tion accepted by servers. Figure 4.2 shows...

The Best Damn Windows Server 2003 Book Period- P14

tailieu.vn

connect internally to your server.This system reduces WAN bandwidth requirements while also increasing security by minimizing the number of clients connecting outside of your network. SUS is the server component responsible for downloading the updates from Microsoft’s servers. Also, the SUS component provides centralized control of updates.The second component to the system is the Automatic Updates client software.. In this...

The Best Damn Windows Server 2003 Book Period- P15

tailieu.vn

If possible, you should have at least two instances of each type of hardware used in your environment.This hardware should be configured with the same software and settings that typical clients with this type of system would have.You should have a server configured as a test SUS server for the network and you should have a sufficient number of servers...

The Best Damn Windows Server 2003 Book Period- P16

tailieu.vn

By default, the top section displays the volume list view and the bottom section displays the graphical view.You can change the view by clicking the View menu bar, choosing Top or Bottom, and selecting the view that you want.. In Figure 5.5, the top section is using the default volume list view.This view uses text in a table to show...

The Best Damn Windows Server 2003 Book Period- P17

tailieu.vn

On the Select Partition Type window (Figure 5.19), select Logical drive.. Click Next to continue.You will now be prompted to specify the partition size as shown in Figure 5.20.. Figure 5.18 Using the New Partition Wizard to Create a Logical Partition. Figure 5.19 Choosing to Create an Extended Partition. Figure 5.20 Specifying a Partition Size. Select a drive letter or...

The Best Damn Windows Server 2003 Book Period- P18

tailieu.vn

You want the ability to dynamically extend the space used on a volume.. Right-click the unallocated space on the disk on which you want to create a simple volume.. Click New Volume on the context menu.This will start the New Volume Wizard, shown in Figure 5.42.. Click Next to continue.. On the Select Volume Type window (Figure 5.43), select Simple.....

The Best Damn Windows Server 2003 Book Period- P19

tailieu.vn

RAID-5 volumes can be created using three to 32 disks.The parity information can be used to regenerate the missing data should one disk fail. If you lose more than one disk, however, all your data will be lost.. However, RAID-5 volumes offer more efficient disk utilization than mirrored volumes.You lose the storage space equivalent to one disk in the RAID-5...

The Best Damn Windows Server 2003 Book Period- P20

tailieu.vn

Disk quotas are set at the volume level only.You cannot create different quotas for individual folders within a volume. If you need to set different quotas for the same users on different folders, you can put those folders on separate volumes or purchase third-party software that allows for more gran- ular setting of quotas. If a disk has three vol-...

The Best Damn Windows Server 2003 Book Period- P21

tailieu.vn

When you lose one drive (with most RAID levels), you no longer have any fault tolerance.You need to be able to replace failed hardware as quickly as possible. Understanding and Using Remote Storage. Windows Server 2003’s Remote Storage provides fast access to data stored on disks and archival capabilities for data that isn’t frequently used, and best of all, it...

The Best Damn Windows Server 2003 Book Period- P22

tailieu.vn

The file copy schedule tells Remote Storage when to copy files from the managed volume to the library.This is set during the initial setup, but it can be changed after the fact.You should always try to copy files into storage during low periods of activity (preferably during non-business hours).You can manually copy files into storage without waiting until the scheduled...

The Best Damn Windows Server 2003 Book Period- P23

tailieu.vn

Troubleshooting Remote Storage. Remember when you are troubleshooting Remote Storage that you are writing data to backup media.This is going to be slower than writing to disks.This is not to say that your performance should be terrible. 301_BD_W2k3_05.qxd PM Page 186. Remote Storage will not install.. Remote Storage is not finding a valid media type.. Files can no longer be...

The Best Damn Windows Server 2003 Book Period- P24

tailieu.vn

Server Cluster Deployment Options. When you use either the single quorum device model or MNS model, there are a variety of ways that you can configure your clustered applications to act during a failover operation.The choices vary with the number of nodes in your server cluster, and each has advantages and disadvantages.. In a server cluster with several nodes and...

The Best Damn Windows Server 2003 Book Period- P25

tailieu.vn

Microsoft’s position since it first began publishing cluster technology is that the hardware compo- nents used in a server cluster and the entire server cluster configuration itself must be listed on the Hardware Compatibility List (HCL) in order to receive support. Windows Server 2003-compatible hardware is listed in the Windows Server Catalog, but the concept and support requirements remain the...

The Best Damn Windows Server 2003 Book Period- P26

tailieu.vn

and make that group a member of the appropriate local groups on the nodes. Use NTFS permissions to ensure that only members of the Administrators group and the cluster service account can access the quorum disk. When a cluster is created or a node is added to a cluster using the Wizard, a file containing critical information about the cluster...

The Best Damn Windows Server 2003 Book Period- P27

tailieu.vn

When a request is sent to the cluster IP address, all hosts in the cluster receive the request.The NLB driver passes the incoming traffic through the defined port rules. All hosts in an NLB cluster must have the same number and specific port rules. In addition, each port rule contains a filtering mode for that rule.The filtering mode defines how...

The Best Damn Windows Server 2003 Book Period- P28

tailieu.vn

Consider tightening the security of the operating system. Place a secured PC in front of the NLB cluster and behind a firewall. Use this PC to run NLB Manager and administer the cluster.. The remote-control feature of NLB is a known security risk.You should avoid using this feature. It is also advisable to place the cluster behind a firewall and...

The Best Damn Windows Server 2003 Book Period- P29

tailieu.vn

One of the downsides of multiple processors is the management of interrupts.The first CPU in a multiprocessor system (processor 0) controls I/O. Processor affinity can be used to reduce some of the overhead associated with multiple CPUs and is controlled pri- marily via the Task Manager utility.. The disk is the permanent storage location of the operating system, applications, and...

The Best Damn Windows Server 2003 Book Period- P30

tailieu.vn

It varies depending on the system, role, and environment.There are several general counters and specific thresholds for these counters that you can use to monitor performance.You should examine these counters as ratios over a period of regular intervals, rather than as the average of specific instances.This will provide a more realistic picture of the actual activity occurring on your system....

The Best Damn Windows Server 2003 Book Period- P31

tailieu.vn

The Save Log File As… selection brings up a Save AS dialog box, as shown in Figure 7.29, which allows you to choose the name, location, and format of the archive.. You can save events in a binary .evt, comma-delimited, or tab-delimited text file.You can use the .evt format to retain the log file in a compact format, which you...

The Best Damn Windows Server 2003 Book Period- P32

tailieu.vn

Advanced Mode. Advanced Mode is accessed by clicking the Advanced Mode link in the opening Backup or Restore Wizard window (see Figure 7.38). Advanced Mode gives you direct access to the ASR Wizard, customization options, and reporting and media management functions. If you click Advanced Mode, you are presented with the window shown in Figure 7.39.. Using Advanced Mode, you...