Articles & Tutorial for MCDBA certification
All articles for MCDBA certification
Tips and How Tos for MCDBA certification
How to create a GPO?
in MCDBA
Take the following steps to create a Group Policy Object (GPO): Run Active Directory Users and Computers from Start Menu > Programs > Administrative Tools > Active Directory Users and Computers.
In the Active Directory Users and Computers console tree, right-click the...
continue reading " How to create a GPO?" »
Skills required for Microsoft test 70-228.
in MCDBA
Microsoft has specified more than thirty objectives for the 70-228 test, which are grouped under six topics. Following are the important areas in which an individual should possess good knowledge before taking the 70-228 test: Know SQL Server configuration options including guidelines regarding...
continue reading " Skills required for Microsoft test 70-228." »
Skills required for Microsoft test 70-229.
in MCDBA
Microsoft has specified more than twenty-five objectives for the 70-229 test, which are grouped under seven topics. Following are the important areas in which an individual should possess good knowledge before taking the 70-229 test: Logical and physical database designing considerations and...
continue reading " Skills required for Microsoft test 70-229." »
What is basic disk?
in MCDBA
A basic disk is a type of physical disk that can be accessed by MS-DOS and all Windows-based operating systems. A basic disk contains up to four primary partitions, or three primary partitions and an extended partition with multiple logical drives. To create partitions on a basic disk, which span...
continue reading " What is basic disk?" »
What is the Merge method?
in MCDBA
The Merge method of the DataSet class is used to incorporate the latest changes from a data source into an existing DataSet object. Following are the signatures of the Merge method:
Signature (Visual Basic .NET) Signature (Visual C# .NET) Description Overloads Public Sub...
continue reading " What is the Merge method?" »
What is virus?
in MCDBA
A virus is a malicious program. A computer virus passes from one computer to another in the same way as a biological virus passes from one person to another. Most viruses are written with a malicious intent, so that they can cause damage to programs and data in addition to spreading themselves....
continue reading " What is virus?" »
Accessing and Manipulating XML Data in Microsoft .NET Framework
in MCDBA
The Extensible Markup Language (XML) is a simple, flexible, and portable markup language. It is the preferred standard of communication developed by the World Wide Web Consortium (W3C). The XML data comprises both human-readable data and its description , and contains text-based XML files. The...
continue reading "Accessing and Manipulating XML Data in Microsoft .NET Framework" »
Clustering
in MCDBA
A cluster is a group of two or more computers (servers) connected to provide fault tolerance and load balancing. It is dedicated to run a specific application. Each server in a cluster is known as a node. The failover and failback capabilities of a cluster bring the application downtime to zero....
continue reading "Clustering" »
Data Integrity
in MCDBA
Introduction
Tables in a SQL Server 2000 database include a number of different types of properties that ensure the integrity of data in the tables. These properties include datatypes, NOT NULL definitions, DEFAULT definitions, IDENTITY properties, rules, constraints, triggers, and indexes....
continue reading "Data Integrity" »
Group Policy and Group Policy Object (GPO)
in MCDBA
What are group policies?
Group policies specify how programs, network resources, and the operating system work for users and computers in an organization. They are collections of user and computer configuration settings that are applied on the users and computers (not on groups). For better...
continue reading "Group Policy and Group Policy Object (GPO)" »
