Archive for the ‘MCDBA’ category

Skills required for Microsoft test 70-310.

November 1st, 2009

Microsoft has specified more than twenty objectives for the 70-310 test, which are grouped under four topics. Following are some important areas in which an individual should possess good knowledge before taking the 70-310 test:

  1. Creating and consuming Windows services, serviced components, .NET Remoting objects, and XML Web services.
  2. Implementing client-activated and server-activated objects.
  3. Creating a strong named assembly and registering a component into global assembly cache.
  4. Implementing security for Windows services, serviced components, .NET Remoting objects, and XML Web services.
  5. Accessing unmanaged code from Windows services, serviced components, .NET Remoting objects, and XML Web services.
  6. Creating and manipulating DataSets.
  7. Accessing and manipulating XML data.
  8. Transforming and filtering data.
  9. Creating unit test plans, implementing tracing, and logging test results.
  10. Debugging Windows services, serviced components, .NET Remoting objects, and XML Web services.
  11. Deploying Windows services, serviced components, .NET Remoting objects, and XML Web services.
  12. Creating setup programs for Windows services, serviced components, .NET Remoting objects, and XML Web services.
  13. Publishing XML Web services.
  14. Configuring authorization.
  15. Implementing versioning.
  16. Configuring security for Windows services, serviced components, .NET Remoting objects, and XML Web services.
Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is Remote Desktop for Administration?

October 31st, 2009

Remote Desktop for Administration is a component of Windows Server 2003 Terminal Services, which is designed for server management. It is a convenient and efficient service for remote management, as it can be used on an already busy server without noticeably affecting CPU performance. Administrators can fully administer computers running Windows Server 2003 family operating systems from computers running earlier versions of Windows by installing the Remote Desktop Connection.

Note: Remote Desktop for Administration does not require purchasing special licenses for client computers that access the server.

Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is Automated System Recovery?

October 31st, 2009

Automated System Recovery (ASR) is a feature of Windows Server 2003. It is used to perform a restore of the system state data and services in the event of a major system failure. An ASR restore includes the configuration information for devices. ASR backs up the system data and local system partition. It does not back up folders and files.

Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

Things to practice for Microsoft test 70-316.

October 31st, 2009

The 70-316 test measures an individual’s ability to develop and implement Windows-based applications using Microsoft Visual C# .NET and Microsoft Visual Studio .NET. Before taking the 70-316 test, you should practice the following:

  1. Create forms and set control properties using the Windows Forms Designer.
  2. Connect to a database using intrinsic DataGrid control. Perform sorting and filtering on the data.
  3. Step through different sections of code using Visual Studio .NET debugger.
  4. Use ADO.NET objects.
  5. Use an ActiveX control and set its properties.
  6. Use an existing COM component in a Visual Studio .NET project.
  7. Create a .NET component and install it in the global assembly cache.
  8. Create deployment projects in Visual Studio .NET.
  9. Write an application that uses Windows authentication.
  10. Use a Web service in a Windows-based application.
Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What are application roles?

October 29th, 2009

Application roles restrict users to access data through a specific application only. Database permissions can be gained only by using specific applications and a user cannot logon directly to a database.

Application security and Application roles contain no members. Users, Microsoft Windows NT groups, and roles cannot be added to application roles. The permissions of application roles can be achieved when the application role is activated for the user’s connection through a specific application. A user’s association with an application role is due to the capability of running an application that activates the role, instead of being a member of the role. It is necessary for a connection to lose default permissions applied through the login/user account or database roles for the duration of the connection, and gain the permissions associated with the application role, so that all functions of the application can be performed without any permission conflict. For example, if a user is denied access to a table the application must access, the denied access should be revoked for the user to successfully use the application. Application roles overcome any conflicts with user’s default permissions by temporarily suspending the user’s default permissions and assigning them only the permissions of the application role.

Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

Secure Internetwork Communication By Using Packet Filtering

October 29th, 2009

The Windows Server 2003 operating system is designed to work on a network. It receives traffic from other computers over the network. Based on the request made, it takes a decision to route packets to use its services, and processes the request sent by the client. Any computer, when accessible for communication, is also a security risk, if it is accessible from the Internet too. A server accessible from the Internet is open to all clients that can connect to it. An unauthorized user can attempt to access the system for many destructive purposes. The most common of them are listed below:

  • Accessing confidential data.
  • Implementing software of its own.
  • Preventing others from using the server.

The most used technique to prevent such intrusions is to use packet filtering.

Packet Filtering

Packet filtering is a method that allows or restricts the flow of specific types of packets to provide security. It analyzes the incoming and outgoing packets and lets them pass or stops them based on the IP addresses of the source and destination. Packet filtering provides a way to define precisely which type of IP traffic is allowed to cross the firewall of an intranet. IP packet filtering is important when users from private intranets connect to public networks, such as the Internet.

A server implementing the filter examines each packet as it arrives and determines whether it meets the criteria for fulfilling its request. Packets that do not meet the criteria are discarded. For example, if an administrator is configuring a server that will be used as an e-mail server, he should create a filter to allow packets that are addressed to port number 25 and port number 110. This is because e-mail servers use the Simple Mail Transfer Protocol (SMTP) and the Post Office Protocol 3 (POP3). The SMTP and POP3 protocols use ports 25 and 110 respectively for communication. If a suspected intruder tries to attack the server, the server will examine the packets sent by him and discard the packets that are not addressed to use ports 25 and 110.

Ports and Protocols

Some of the important applications and the port numbers they use are summarized in the table below:

Application Protocol Port Number
File Transfer Protocol (Control) TCP 21
Telnet TCP 23
Simple Mail Transfer Protocol TCP 25
Domain Name Service TCP/UDP 53
Dynamic Host Configuration Protocol (Server) UDP 67
Dynamic Host Configuration Protocol (Client) UDP 68
World Wide Web HTTP TCP 80
Post Office Protocol 3 TCP 110
Simple Network Management Protocol UDP 161

Note: The listed port numbers in the above table are also called well-known ports. The complete and updated list of well-known port numbers is available at http://www.iana.org/assignments/port-numbers.

Packet filtering is mostly configured on routers or firewalls that connect a private network to the public network such as the Internet. However, it can be configured inside the network to protect a server with confidential information from being accessed by other users on the network.

Packet Filtering Criteria

Administrators can configure packet filtering inclusively or exclusively:

  • Start with a network connection that is completely blocked and use filters to specify that the traffic can pass through.
  • Start with a completely open connection and specify the types of traffic to be blocked.

The criteria used for packet filtering are as follows:

  • Port Numbers: This is the most common type of packet filtering criteria. Port numbers can be used to block or allow packets using certain ports.
  • Protocol Identifiers: Protocol identifiers can be used to filter packets based on an entire protocol. Administrators can use this filter to block packets that are intended to use certain protocols. For example, an administrator can block all UDP and ICMP traffic. This prevents attackers from using applications that are based on these protocols.
  • IP Address: IP address filtering is used by administrators to limit network access to specific computers. IP address filtering is useful for protecting a part of a private network from users on another part of the network. It should be noted that IP address filtering is not considered to be a very secure method for securing a network. Intruders can get into the network using a technique called spoofing.
  • Hardware addresses: Filtering can be done through hardware addresses. Each network interface adapter at the factory is coded with the media access control (MAC) address known as hardware address. It works in the same way as IP address filtering. However, it is more difficult to spoof a hardware address than an IP address.

Packet Filtering in Windows Server 2003

Windows Server 2003 uses two packet filtering options:

  • TCP/IP Packet Filtering: In Windows Server 2003, take the following steps to implement TCP/IP filtering:
    1. Run Network Connections from Start Menu > Settings > Network Connections.
    2. In the Network Connections folder, right-click the Local Area Connection icon, and click Properties.
    3. In the Local Area Connection Properties dialog box, select Internet Protocol (TCP/IP), and click the Properties button.
    4. In the Internet Protocol (TCP/IP) Properties dialog box, click the Advanced button.
    5. In the Advanced TCP/IP Settings dialog box, click the Options tab. On the Options tab page, select TCP/IP filtering, and click the Properties button.
    6. In the TCP/IP Filtering dialog box, click the Enable TCP/IP Filtering (All adapters) check box. Click the appropriate Permit Only radio button to specify the port, and click the Add button.
    7. In the Add Filter dialog box, specify the port number in the TCP Port section, and click the OK button.
    8. In the TCP/IP Filtering dialog box, click the OK button.
  • Routing and Remote Access Service Packet Filtering: This option is more capable than TCP/IP packet filtering. However, administrators can use this type of filtering only when a server running Windows Server 2003 is configured as a router. By using this filter, you can use many criteria that TCP/IP filtering does not have. Some of the important capabilities of this type of filtering are as follows:
    • It can create filters based on the IP addresses, protocols, and port numbers of a packet’s source or destination.
    • It can create inclusive or exclusive filters.
    • It can create filters for ICMP messages, specified by the message type and code values.
    • It can create multiple filters of the same type.

Although packet filters can prevent a network from unauthorized intrusion, this technique cannot be used for safe and secure communications.

Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is Trace.axd?

October 27th, 2009

Trace.axd is an Http Handler that can be used to view the trace details for an application. This file resides in the application’s root directory. A request to this file through a browser displays the trace log of the last n requests in time-order, where n is an integer determined by the value set by requestLimit=”[n]” in the application’s configuration file.

Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is the SystemProcessor Queue Length counter?

September 30th, 2009

The SystemProcessor Queue Length counter displays the number of threads ready in the processor queue but not currently able to use the processor. The Processor: %Processor Time counter should be measured with a counter. If its value is two, it indicates a CPU bottleneck. This results in slow performance of the server. To eliminate the performance problem, several steps can be used such as reducing the number of processors, using = multiple processors, updating the processors, or installing new and updated CPUs.

Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is the function of the FROM clause?

September 24th, 2009

The FROM clause of the SQL SELECT statement is used to specify the table names that will be joined together to extract the data values. For example:

SELECT <attributes>
FROM <tables>
WHERE <condition>

Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is the ExecuteNonQuery method?

September 21st, 2009

The ExecuteNonQuery method of the SqlCommand class is used to execute commands that change a database. These commands include the Transact-SQL INSERT, UPDATE, DELETE, and SET statements. The method acts directly on a database connection and does not require a data set. It returns an integer that indicates the number of rows affected by the execution of a command. This method can also be used to perform catalog operations, such as querying the structure of a database or creating database objects.

Like this post? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark
uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.