MCTS Fix

Ace up your sleeve with MCTS

Monthly Archives: April 2010

Create a Computed Column using SQL Server Management Studio:

Take the following steps to create a computed column using SQL Server Management Studio:

  1. Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
  2. In the Connect to Server window, click the Connect button.
  3. In the Microsoft SQL Server Management Studio window, double-click the Databases folder.
  4. In the Microsoft SQL Server Management Studio window, double-click the required database. Here, the Axle database is being used.
  5. In the Microsoft SQL Server Management Studio window, double-click the Tables folder.
  6. In the Microsoft SQL Server Management Studio window, right-click the required table and click Modify.
  7. Type the name of the new column. Here, Amount is the new column.
  8. In Column Properties, expand Computed Column Specification. In the Formula box, type the formula. Here, the Price column is multiplied by the Quantity column.
  9. Go to the File menu and click Save Products to save the modifications in the Products table.
Share

Things to Practce before 70-680 test

  • Install and configure Windows 7 drivers.
  • Configure Windows Aero.
  • Configure Parental Controls.
  • Configure Windows Internet Explorer 8 and configure dynamic security for it.
  • Configure User Account Control.
  • Configure Windows Defender.
  • Configure Windows Firewall.
  • Configure networking through the Network and Sharing Center utility.
  • Configure IPv6.
  • Configure Remote Access.
  • Configure Windows Meeting Space.
  • Configure Windows Calendar.
  • Configure Windows Fax and Scan.
  • Configure Windows Sidebar.
  • Configure Windows Update.
  • Configure Data Protection.
  • Planning and configure data back up.
  • Configure BitLocker To Go.
    • Share

    Various tools used in Windows 7 Deployment:

    Oscdimg (Oscdimg.exe): Oscdimg  is a command-line tool that is used to create the .ISO file of Windows PE. The .ISO file can then be burned to a CD-ROM or a DVD-ROM.

    Note: Merely copying the .ISO file to the CD-ROM will not work. To create a bootable CD-ROM, CD-recording software must be used that unpacks the .ISO file and burns it to a CD-ROM.

    PEImg (PEImg.exe): PEImg is a command-line tool that is used to create and modify Windows PE images offline. It is also used to add new device drivers to the Windows PE images offline.

    Language Pack Setup (Lpksetup.exe): Lpksetup.exe is a command-line tool that is used to add or remove language packs after the Windows operating system is installed on a computer. Lpksetup.exe runs only on an online Windows operating system. Lpksetup.exe is available with all default Windows installations.

    Windows PE utility (Wpeutil): Wpeutil is a command-line tool that is used to run various commands in a Windows PE session. It enables a user to shutdown or restart Windows PE, enable or disable a firewall, set language settings, and initialize a network.

    Wpeinit: Wpeinit is a command-line tool that is used to initialize Windows PE each time it boots. When Windows PE starts, Winpeshl.exe executes Startnet.cmd, which launches Wpeinit.exe. Wpeinit replaces the initialization function previously supported in Factory.exe -winpe. Wpeinit saves the log messages to C:\Windows\system32\wpeinit.log.

    Drvload: The Drvload tool is used to add out-of-box drivers to a booted Windows PE image. It takes .inf files as input. The PEImg tool is used to add a driver to an offline image.

    ImageX: ImageX is a command-line tool that is used to create, modify, and apply file-based disk images for rapid deployment. It works with Windows image (.wim) files for copying to a network, or it can work with other technologies that use .wim images, such as Windows Setup, Windows Deployment Services (Windows DS), etc.

    DISM: DISM stands for Deployment Image Servicing and Management. DISM is a command-line tool used to service Windows images offline before deployment. This tool is also used to install, uninstall, configure, and update Windows features, packages, drivers, and international settings. DISM is also distributed in the Windows OEM Preinstallation Kit and the Windows Automated Installation Kit (Windows AIK). It has replaced several Windows OPK tools, including PEimg, Intlcfg, and Package Manager.

    SYSPREP: The SYSPREP tool is used to prepare an image of a hard disk of a computer running a Windows operating system, so that it can be deployed to multiple destination computers. It prepares the computer by cleaning various user and machine settings and log files.

    Share

    OEM (original equipment manufacturer)

    An original equipment manufacturer, or OEM, manufactures products or components that are purchased by a company and retailed under that purchasing company’s brand name. OEM refers to the company that originally manufactured the product.

    It is a type of contract manufacuring and a form of outsourcing.

    When referring to automotive parts, OEM designates a replacement part made by the manufacturer of the original part.

    Share

    MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications Certification

    Microsoft’s MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications certification has been designed for professionals who have a good knowledge and expertise in Microsoft .NET Framework 3.5 and Visual Studio 2008. The professionals are required to build distributed applications by using technologies such as XML Web services, .NET Remoting, and Windows enterprise services. Individuals pursuing this certification must have at least one year experience using the required technologies of this certification.

    Prerequisite for MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications Certification

    To earn this certification, the candidate must pass one prerequisite exam, i.e. the Microsoft exam 70-536 (TS: Microsoft .NET Framework, Application Development Foundation) and one required exam, i.e. the Microsoft exam 70-503 (TS: Microsoft .NET Framework 3.5 – Windows Communication Foundation Application Development). Following is the description of the two exams:

    • Prerequisite Exam: The Microsoft exam 70-536: TS: Microsoft .NET Framework, Application Development Foundation is designed specifically to measure a candidate’s knowledge of .NET development fundamentals. It is not tied to a particular version of .NET. This exam is available in English, French, German, Japanese, and Chinese (Simplified).

      The candidates acquiring this exam must have at least two to three years of experience in developing Web-based, Windows-based, or distributed applications by using the Microsoft .NET Framework with 1.0, 1.1, 2.0, or 3.5 versions. Candidates should also have a working and a sound knowledge of Microsoft Visual Studio 2005 or Visual Studio 2008.

      There can be two variations to pass this exam. If a candidate has already earned the credentials of being a .NET 2.0 developer, he does not need to learn .NET 3.5 in order to pass this exam. Conversely, if a candidate is a .NET 3.5 developer, he does not need to review .NET 2.0 in order to pass the exam.

    • Required Exam: The Microsoft exam 70-503: TS: Microsoft .NET Framework 3.5 – Windows Communication Foundation Application Development is designed specifically to measure a candidate’s knowledge of developing distributed applications by using Microsoft Visual Studio 2008 and Microsoft .NET Framework 3.5. The candidate pursuing this exam should have at least one year experience developing distributed applications by using technologies such as XML Web services, .NET Remoting, and Windows enterprise services. He should also have a sound knowledge about Visual Studio 2008 and should use the Windows Communication Foundation (WCF) technology, which includes the following path:
      • A sound knowledge about the Windows Communication Foundation (WCF) technology in the context of the .NET Framework 3.5 platform.
      • A working experience in supporting Web services specifications standards.
      • A working experience in creating service model elements.
      • A working knowledge in integrating WCF services with Windows enterprise services such as Message Queuing (MSMQ) and COM+.
      • A good experience of configuring and deploying WCF applications.

    Benefits of MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications Certification

    Some of the benefits of the MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications certification are as follows:

    • Microsoft products are most widely used today and the MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications certification proves expertise on the Microsoft products and technologies.
    • Professionals who have this certification can enhance their employment opportunities.
    • This certification is helpful for professionals who have entry-level certifications in related technologies to upgrade their credentials and get recognition from the industry.
    • MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications certified professionals get special offers and discount on Microsoft products and other selected products from Microsoft.
    • Professionals who earn this certification can have sound knowledge of Visual Studio 2008.

    Job Roles for MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications Certified Professionals

    MCTS: .NET Framework 3.5 – Windows Communication Foundation Applications Certified Professionals can become expertise in using Visual Studio 2008 and Microsoft .NET Framework 3.5 in a well-organized business environment. They can excel in some specific job areas as an expert in Windows, ASP.NET, ADO.NET, or Windows Communication Foundation application development. They can become Windows Developers, ASP.NET Developers, Enterprise Application Developers, Database Administrators, Database Developers, or Business Intelligence Developers.

    Share

    Things to practice for Microsoft exam 70-649

    The PrepKit for Microsoft exam 70-649 is designed to help individuals prepare for the actual Microsoft exam 70-649. The Microsoft Technology Specialist (TS) exam, Exam 70-649: TS: Upgrading Your MCSE on Windows Server 2003 to Windows Server 2008, Technology Specialist, exam fulfills the Microsoft Certified Technology Specialist (MCTS) on Windows Server 2008 requirements of Exams 70-640, 70-642, and 70-643. Before taking the 70-649 exam, you should practice the following:

    • Install Windows Server 2008 on two networked computers. During installation, through Setup, create a partition on the hard disks on which you should install Windows Server 2008 as a stand-alone server in a workgroup.
    • Configure IPv4 and IPv6 addressing.
    • Make a Windows 2008 domain-based network of two computers.
    • Install and configure DNS.
    • Configure RRAS, NAP, wireless access, and firewall settings.
    • Configure Terminal Services remote programs.
    • Configure Terminal Services load balancing.
    • Configure Terminal Services gateway.
    • Configure File Transfer Protocol (FTP) Server.
    • Configure SMTP service.
    • Configure IIS components and publish an IIS Web site.
    • Configure SMTP service.
    • Configure .NET trust level.
    • Configure authentication, authorization, rights, and permissions for Web services.
    • Configure certificate for Web services.
    • Use WDS for unattended installation.
    • Use Server Manager for server management.
    • Create and configure organizational units (OUs).
    • Create and configure users and computer accounts.
    • Create and configure different groups such as local, domain, etc.
    • Create and configure group policy objects (GPOs).
    • Take backup of Active Directory and restore it.
    • Use WSUS for implementing patch management strategy.
    • Configure Windows Server 2008 Hyper-V.
    Share

    Monitor the processor performance on Windows 2003 Server.

    Monitoring the processor performance can help you to speed up your system. Take following steps to monitor the processor performance on Windows 2003 Server:

    1. Run Performance from Start Menu > Programs > Administrative Tools > Performance.

    2. In the Performance console, click Console Root to expand the tree, click System Monitor, and click the Add button.

    3. In the Add Counters dialog box, select a performance object from the Performance object drop down list box, select counters from the Select counters from list option, and click the Add button. Click the Close button.

    4. Monitor the performance chart for the counters added over the period.

    Share

    Microsoft Certified Application Developer: MCAD

    The Microsoft Certified Application Developer (MCAD) certification is the mid level programming certification offered by Microsoft, leading to the MCSD. To fulfill the requirements of the certification, a total of three exams (two core exams, one elective exam) must be passed. Microsoft has declared that this certification will be focused towards the needs of developers using .NET Framework 1.0 and 1.1 versions. Developers using .NET Framework 2.0 and Microsoft Visual Studio 2005 are expected to consider undergoing Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified Professional Developer (MCPD) certification.

    Share