dbawiz | DBA Wiz

The following articles were authored by dbawiz

SAVE 40% uCertify Pre-Thanksgiving Sale

By dbawiz on November 24, 2011
This entry is filed under uCertify News, Uncategorized.

Buy 2 or more Prepkits and get 40% OFF
uCertify invites the first 100 customers to begin feasting early..!! This is one feast you won’t want to miss! The best part … you won’t regret feasting! You will pass in your first attempt or your money back. No questions asked. This is one gift you won’t need to return.
‘Tis the season to be jolly! So, celebrate the savings! Treat yourself to the gift of learning!

Join the feasting! Choose from over 400 test prep software for CompTIA, Microsoft, Oracle, IBM, Cisco, CCNA, & many more. Nobody beats our breadth and depth of experience. 100% guaranteed..!!!
Buy our PrepKits and Save upto 50%! And yes, get the online and mobile versions absolutely FREE!

http://learn.ucertify.com

Simply sign up or login with your existing account and add the Prepkit of your choice and and access it from anywhere. You can add your license information from this link

http://learn.ucertify.com/myprofile.php?func=mylicense

Click here now to Save : uCertify’s Pre-Thanksgiving Sale!

Happy Shopping & Happy Learning!
Your uCertify Team

http://www.ucertify.com

WonderFALL news & savings from uCertify!!!!

By dbawiz on September 28, 2011
This entry is filed under uCertify News.

uCertify is here again with a wonderful offer Choose from over 300 test prep software for CompTIA, Microsoft, Oracle, IBM, Cisco, CCNA & many more. Nobody beats our breadth and depth of experience. Buy our PrepKits and Save upto 50%.

This offer is available for the first 100 customers only. Be one of the first to buy any of our PrepKits and get the ONLINE version absolutely FREE! Access the PrepKit from any computer, your iPhone or iPad!

You can add your license information from this link

http://www.ucertify.me/myprofile.php?func=mylicense

iPhone and iPad users signup to http://learn.ucertify.com or login with your existing account and add the Prepkit of your choice and and access it from your iPhone and iPad. You can add your license information from this link: http://learn.ucertify.com/myprofile.php?func=mylicense
So what are you waiting for…Hurry up!!!!

Automatic failover

By dbawiz on August 27, 2011
This entry is filed under SQL Server.

An automatic failover is a switching role that causes the mirror server to take over the role of the principal server and bring its copy of the database online as the principal database. It involves high-safety mode and requires the presence of the mirror server and a witness server. The database should be synchronized and the witness must be associated to the mirror server. The job of the witness is to confirm whether a given partner server is up and operating. If the connection of the mirror server to the principal server is lost but the witness server is still connected to the principal server, the mirror server will not initiate a failover.

Failover clustering

By dbawiz on August 26, 2011
This entry is filed under SQL Server.

Failover clustering is a process in which more than one server is configured to host a single instance of SQL Server 2005/2008. The database will still be available if a server in the cluster fails. The cluster of servers contains shared disk that holds the data in the database. This type of configuration is also known as virtual server.

Database Publishing Wizard

By dbawiz on August 25, 2011
This entry is filed under SQL Server.

Database Publishing Wizard uses the following modes to deploy an SQL database:
Script mode: In this mode, Wizard generates a single SQL script file that a user can run manually on the target server for recreating the database schema and contents.
Web service mode: In this mode, Wizard connects to a Web host environment service and copies the content of a source database into a target database directly.

Back to School Sale

By dbawiz on August 17, 2011
This entry is filed under Industry news.

In this new school year uCertify is offering a humongous discount of upto 50% for a limited time only. Earn more, do more, with an IT certification. Get certified – no matter if you are a fresh high school grad or in college or an IT professional. The offer is valid for first 300 customers only. Choose from over 300 test prep software for CompTIA, Microsoft, Oracle, IBM, Cisco, CCNA & many more. uCertify – the fastest way to IT certification with the right tools and the right price. It’s quite simply, the right thing to do.

Hurry! Sale runs 8/17 through 8/25 only!
Happy Shopping & Happy Learning!
Your uCertify Team

http://www.ucertify.com

Types of database schema

By dbawiz on August 2, 2011
This entry is filed under SQL Server.

There are three types of database schemas, which are as follows:
Conceptual schema: It is also called a conceptual data model. It is a map of concepts and their relationships. It is used to describe the semantics of an organization.
Logical schema: It specifies problem domain in terms of a particular data management technology without being specific to a particular database management.
Physical schema: It is a term used in relation to data management. According to the ANSI four-schema architecture, it was the view of data that involved data management technology.

Database schema

By dbawiz on August 1, 2011
This entry is filed under SQL Server.

A database schema is the structure of a database. It is described in a formal language supported by the Database Management System (DBMS). It is a collection of database objects such as tables, views, sequences, synonyms, clusters, indexes, database links, procedures, functions, and packages. In a relational database, the database schema defines tables, fields, and relationships between the fields and tables. A database schema is stored in a data dictionary.

Nested table

By dbawiz on July 30, 2011
This entry is filed under SQL Server, Uncategorized.

A nested table, within the database, is a type of column that contains a set of values. The rows of a nested table are not stored in any specific order in the database. When a nested table is retrieved from the database into a PL/SQL variable, the rows of the nested table are granted with continuous subscripts beginning from 1. A nested table has the following features:
The number of elements is not declared for a nested table.
Nested tables are used when there is no set number of index values.
Elements from an initially dense nested table can be deleted, thus making it sparse.

External table

By dbawiz on July 29, 2011
This entry is filed under SQL Server.

An external table is an efficient alternative to reading and loading flat files in a database. It can also execute queries in a flat file and it gives an impression of working with an Oracle table. It is primarily used to move data into and out of a database. It is considered as a convenient way to use SQL*Loader and Data Pump functionality. The external table does not exist in the database and can be of any format, and an access driver must be provided for the format of an external table. The disadvantage of using an external table is that the DML commands cannot be executed in an external table. An exception to this rule is the table creation DML statement. Another disadvantage is that an index cannot be created on an external table.

Older Entries »

DBA Wiz