How to Configure DNS in Windows Server 2012

In most cases, you do not need to manually configure DNS to support Active Directory, you can allow the Active Directory Installation Wizard will automatically install the DNS. However, you can use the configure a DNS Server Wizard to configure DNS, if you want to set the Active Directory Installation Wizard to install the default configuration, the DNS settings. For example, you may want that your DNS server is different from the domain controller.
If you plan to use the configure a DNS Server Wizard, the configure a DNS server, complete the following tasks before running the wizard:

• If the DNS server is not installed, install it.
• If this server is not a root DNS server, configure the network connections, you can specify one or more DNS servers in your network.

When you run the wizard or after you have completed the wizard, you will have to create authoritative Netlogon locator records to add a forward lookup zone.

You have finished configuring your DNS server by using the wizard, you must perform the following tasks:

Enable dynamic updates on the region.

Unless this is a root zone, to their parent zone adds a new forward lookup zone delegation.

Please ensure that the domain controller's server has network connectivity to this server.

Not configured DNS server running on a domain controller, you must be a member of the Administrators group of that computer.

To configure the domain controllers running the DNS server, you must be at least the Microsoft DNS container in Active Directory access control lists (ACL) are listed in the Member of the group. The team also must have the full control permission. By default, the following groups listed in the ACL:

DNS administrator

Domain administrator

Enterprise Administrator

Before you configure your DNS, verify that your DNS client settings are correct.

To verify that the DNS client settings

My network places, click with the right mouse button, and then click Properties.

Right-click the connection for which you want to configure DNS server, and then click Properties.

Click Internet Protocol (TCP/IP), and then click Properties.

In the Internet Protocol (TCP/IP) properties page, in the preferred DNS server field, type the IP address of the DNS server. In the alternate DNS server field, you can also add alternate DNS server IP addresses.

If you need to specify more than one alternate DNS server, click Advanced, click the DNS tab, and then enter the server in the DNS server addresses box.

Configure a DNS Server Wizard uses DNS client information to determine if there are any of the root DNS servers on the network. For more information about setting up DNS server's IP address, see the Windows 2000 Server Description.

In addition, you must install a DNS server build server. To install and configure the DNS server, perform the following procedure:

To install the DNS server:

In Control Panel, double-click Add/Remove Programs, and then click Add/Remove Windows components.

Click the component, and then click Next.

Click Networking Services, and then click details.

If it is not already selected, select the check box next to the domain name system (DNS), and then click OK.

Click Next. Install Windows 2000 DNS.

Click Finish

To Configure the DNS Server:

• In Control Panel, double-click Administrative Tools, and then double-click DNS.

• Click to expand the DNS server.

• Right click the server name, and then select the build server from the contextual menu. Configure a DNS Server Wizard starts and guides you through the process of setting DNS. In some cases, this involves creating a reverse lookup zone. Details about create a reverse zone, see later in this chapter, "adding a reverse lookup zone."

• Optional If you have installed Active Directory, and Active Directory-integrated zones. Information about Active Directory-integrated zones, see later in this chapter, "Active Directory integration and Multimaster replication."

Configure a DNS Server Wizard prompts you to create the appropriate forward and reverse zone has all the information you need.

Configure a DNS Server Wizard or root hints, and creates a root zone, if necessary, and the Active Directory Installation Wizard will not be exactly the same. However, it does not create a reverse lookup zone, so you have to do later. Details about create a reverse zone, see later in this chapter, "adding a reverse lookup zone."

If you are creating an Active Directory domain, you must perform some additional configuration.

MCSA SQL Server 2012 Exam Code 70-463 Course Outline

Microsoft Course 10777:

Exam 70-463

This instructor-led course describes how to implement a BI platform supports the analysis of information workers. Students will learn how to create a 2012, execute ETL and data warehousing with SQL Server SQL Server integration services, and verify and clean up data quality with SQL Server data services, and SQL Server master data services.

This course explains students preparing for the exam 70-463.

Audience Profile:

The primary audience for this course is that database professionals need to perform business intelligence developer role. They will need to focus on creating a BI solution, including the practice of implementation of data warehousing, ETL, and data cleansing. Key responsibilities will include:

• As the data warehousing implementation
• Data extraction and loading of the SSIS package in developing countries/transfer/conversion
• Enforce data integrity using master data services
• Cleaning data data quality service

At Course Completion:

Upon completion of this course, students will be able to:

• Describes data storage concepts and architecture considerations.
• Select the appropriate hardware platform for data warehousing.
• Design and implementation of data warehousing.
• Implementing data flow SSIS packages.
• Implementing data flow SSIS packages.
• Debug and troubleshoot SSIS packages.
• Implement an SSIS solution, supports incremental data warehouse loading and changing data.
• Cloud data integration with data warehouse ecosystem infrastructure.
• Implementation of data cleaning by using the Microsoft data quality services.
• The source for master data services to enforce data integrity.
• SSIS extensions and custom scripting and components.
• Deploy and configure an SSIS package.
• Describes how information workers to consume data in the data warehouse.

Course Outline:

 Introduction to Data Warehousing:

This module provides data warehousing solutions and high level taking into account critical components that must be considered when data warehousing projects in General.

• Describes data storage concepts and architecture considerations
• Considerations for data warehousing solutions
• Describes data storage concepts and architecture considerations

Data Warehouse Hardware Considerations:

This module describes, you can consider in choosing the right hardware platform for your data warehousing solution.

• Build data warehousing challenges
• Data warehouse reference architecture
• Data warehouse appliances
• Select the appropriate hardware platform for data warehousing.

Implementing Control Flow in an SSIS Package:

This module describes how to implement robust ETL process allows users to design and data warehousing solution, coordination and other automation of the data flow task operations control flow.

• Brief introduction of control flow
• Creating a dynamic package
• Use a container
• Consistency management
• Implement control flow SSIS packages.

Incorporating Data from the Cloud in a Data Warehouse:

This specific module details how to assimilate files into a files factory ecosystem.

This module describes how to integrate data into a data warehouse ecosystem.

• Cloud data sources overview
• SQL Azure Server
• Azure data market

Cloud data into a data warehouse ecosystem.

Using Master Data Services:

This module covers the primary data services, and explained in business intelligence (BI) uses it in the context of the benefits. It also describes the key configuration options, explains how to import and export data and application rules, instructions to maintain the integrity of the data and introduction of the new master data services add-in for Excel.

• The concept of master data services
• Implementing a master data services model
• Use master data services load Excel

The source for master data services to enforce data integrity.

MCSA SQL Server 2012 Exam Code 70-462 Course Outline

Microsoft Course 10775:

Exam 70-462:

This course provides students with the knowledge and skills to 2012 maintaining a Microsoft SQL Server database. The focus of this course is to teach people how to use and maintain databases and SQL Server tools related to 2012 product features. You prepare for the exam of this course 70-462).

This course for laboratory use virtual machine software. This course uses Microsoft SQL Server to a 2012 release candidate 0 (RC0). The exercises in this course, some SQL Azure is enabled.

Here are a few in this course discusses the new features of SQL Server

Discussion has centered on SQL Server (update rollup, Service Pack, patch) services

Understand the relationship between different levels of upgrade to SQL Server products are very important for those who work with him. Curriculum now includes as patches, Service Pack and cumulative update and application update for more information about each type.

SQL Server uses the automatic updates

Now that SQL Server can use Windows Update Services. Course shows how to enable automatic updates and when to use which should and should not be used.

Some databases contain

A key challenge when migrating databases between servers is managed objects (for example, logins not included in the database.) The courses are now discussing SQL Server provides options of local quarantine for 2012. In particular, discusses the authentication-related changes.

Users and passwords (including user)

This course shows how 2012 SQL Server allows a user database rather than at the level of server for authentication. This is an important first step for the databases contain.

Server user-defined functions

In earlier versions of SQL Server, database, but not at the level of server level, you can create a user-defined function. 2012 in SQL Server, server-level user-defined functions can also be defined. This explains the growing security system. Allowed the possibility to configure the permissions more granular login assigned unique permissions, all they need to do their jobs.

The application of level data in place upgrade

In earlier versions of SQL Server, covering all data within a database you are migrating to the new data-tier application updates. 2012 in SQL Server that you no longer need, this course shows how to update the application's data layer more fast and consume fewer system resources.

Audience Profile:

The primary audience for this course is a personal management and maintenance of SQL Server databases. Database of those individuals to perform maintenance and management as their primary responsibility for regional or local databases in their main work played a key role in the work environment.

Hearing the minor courses of study is an individual, they developed applications to provide content from the SQL Server database.

At Course Completion:

At the end of this course, students will be able to:

• Planning and installation of SQL Server.
• It describes the system databases, and they are related to the physical structure of the database and the configuration options most commonly used.
• Explain the concept of models of recovery and SQL Server transaction log and apply different strategies of SQL Server backup available.
• Create a SQL Server backup.
• Restore the SQL Server database.
• With the help of the wizard to import and export, and explains how the SSIS.
• Security model for SQL Server, connections and users.
• Working with a fixed server role, the server user-defined functions, database and database fixed roles defined by the user.
• Work and granting permissions with permissions.
• SQL Server audit.
• SQL Server Agent jobs and resumes.
• Achieve security, he has the credentials of the SQL Server Agent proxy.
• Configure notifications and alerts from database mail.
• To create a database maintenance plan.
• Use of probes eventos-SQL and SQL Trace stored procedures.

DMV introduction and configuration of data collection.

With a central Government and several queries SQL Server, virtualization of servers, applications of layer data.

To troubleshoot a SQL Server database.

Course Outline:

This module throughout the current SQL Server platform and its primary tool. It includes versions, versions, the fundamentals of network audiences and the concept of services and service accounts.

• SQL Server platform brief
• Using SQL Server tools
• Configure the SQL Server service

At the end of this module, students will be able to:

• Describes the SQL Server platform.
• Use the SQL Server tools.
• Configure the SQL Server service.

Preparing Systems for SQL Server 2012:

About SQL Server I/O requirements installation planning includes 32-bit and 64-bit, memory pre-installation checks use the SQLIOSim configuration options and I/O subsystems and the SQLIO this module.

• An overview of SQL Server architecture
• Planning Server resource requirements
• Preinstalling SQL Server tests

After completing this module, students will be able to:

• Describes SQL Server architecture.
• Server resource requirements of the plan.
• Preinstalling SQL Server stress test.

Installing and Configuring SQL Server 2012:

This module details the installation and configuration of SQL Server.

• Preparing to install SQL Server
• Installing SQL Server
• Upgrade and automate the installation

After completing this module, students will be able to:

• Preparing to install SQL Server.
• To install SQL Server.
• Upgrade and automate the installation of SQL Server.

Working with Databases:

This module describes how to store data in a database, and how to create a database, and how to move between servers within a database or server.

• An overview of the SQL Server database
• Using gears and gear set
• Move database files

After completing this module, students will be able to:

• Describe the role and structure of the SQL Server database.
• Working with gears and gear set.
• To move the database files between the server and the server.

Backup of SQL Server 2012 Databases:

This module describes SQL Server backup, and the backup type.

• Backing up databases and transaction logs
• Management of database backup
• Using the backup option

After completing this module, students will be able to:

• Backing up the database and transaction log.
• Managing backups of a database.
• Work with more advanced backup options.

Importing and Exporting Data:

This module covers using the import/export wizard, and explains how they are to SSIS. Besides introducing BCP.

• Moving data from SQL Server
• Importing and exporting form data
• Bulk inserting data

After completing this module, students will be able to:

• To transfer data to and from SQL Server.
• Importing and exporting table data.
• Bulk inserting data, bulk insert process optimization.

Authorizing Users to Access Resources:

This module has been assigned rights and privileges.

• User object access permissions.
• To run user code.
• Outline level setting permissions

After completing the module, students will be able to:

• Authorized access to the user object.
• Authorized user identification.
• Configuring permissions on schema level.