Archive for the ‘MCITP’ category

« Older Entries

What are the conditions under which a function can be schema bound?

November 4th, 2009

A function can be schema bound only if the following conditions are true:

  • The function is a Transact-SQL function.
  • The user-defined functions and the views it references are also schema-bound.
  • The objects that the function references are referenced using a two-part name.

This is a preview of What are the conditions under which a function can be schema bound?. Read the full post (154 words, estimated 37 secs reading time)
Like this article? 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

No comments »

Posted in MCITP, MCITP Database Developer, MCITP Microsoft SQL Server, MCTS, MCTS Microsoft SQL Server, MCTS SQL Server 2008

Tags:

What are non-equijoins?

November 4th, 2009

Non-equijoins are used to return the result from two or more tables where exact join is not possible.

Example:

There are two tables: EMP and SALGRADE. The SALGRADE table contains the grade of employees. It also contains the minimum and maximum salaries for all grades. Suppose there arises a need to find the grade of employees based on their salaries, then a NON EQUI join can be used as follows:

This is a preview of What are non-equijoins?. Read the full post (155 words, estimated 37 secs reading time)
Like this article? 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

No comments »

Posted in MCITP, MCITP Database Developer, MCITP Microsoft SQL Server, MCTS, MCTS Microsoft SQL Server, MCTS SQL Server 2008

Tags:

What is an explicit transaction?

November 3rd, 2009

An explicit transaction is one in which a user explicitly defines the beginning and end of the transaction. They are typically defined within the stored procedures. Explicit transactions begin with the BEGIN TRANSACTION statement and end with the COMMIT TRANSACTION or the ROLLBACK TRANSACTION statement. Once a transaction is committed, SQL Server ensures that the data is written to the database even in case of server failure.

Permanent link to this post (137 words, estimated 33 secs reading time)
Like this article? 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

No comments »

Posted in MCITP, MCITP Database Developer, MCITP Microsoft SQL Server, MCTS, MCTS Microsoft SQL Server, MCTS SQL Server 2008

Tags:

What is 802.11g?

October 28th, 2009

The 802.11g standard, defined by IEEE, is an extension to the 802.11b standard of wireless network. It operates in 2.4-GHz band and brings data rates up to 54Mbps using Orthogonal Frequency-Division Multiplexing (OFDM) technology. Since the 802.11g standard is backward compatible with 802.11b, an 802.11b device can interface directly with an 802.11g access point.

Permanent link to this post (360 words, estimated 1:26 mins reading time)
Like this article? 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

No comments »

Posted in A+, A+ 2009, A+2006, CCENT, CCNA, CCNA Wireless, MCITP, MCITP Consumer Support Technician, MCITP Enterprise Administrator, MCITP Enterprise Support Technician, MCITP Microsoft Windows Client, MCITP Microsoft Windows Server, MCP, MCSA, MCSA 2000, MCSE, MCSE 2000, MCSE 2000 Security, MCSE 2003 Messaging, MCSE 2003 Security, MCSE-NT to 2003, MCTS, MCTS Windows Technology, MCTS Windows Vista, Network+

Tags:

What is the Print permission?

October 28th, 2009

Print is a basic printer permission that allows users or groups to connect to a printer, print documents, and manage their own documents in the print queue. Users having the Print permission are able to pause, resume, restart, and cancel the printing of a document.

Permanent link to this post (123 words, estimated 30 secs reading time)
Like this article? 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

No comments »

Posted in MCDST, MCITP, MCITP Consumer Support Technician, MCITP Microsoft Windows Client, MCP, MCTS Windows Vista

Tags:

Service Broker

October 11th, 2009

Service Broker is a new technology in SQL Server 2005 and provides a solution to message delivery issues that occur while transferring transactional data from one server to another. This technology provides a message-based communication platform and is part of the Database Engine. Database developers develop secure, reliable, and scalable applications with the help of Service Broker. Service Broker is used for the applications that use a single instance of SQL Server 2005 as well as for those that use multiple instances of SQL Server 2005 across the network. It provides reliable messaging between multiple instances of SQL Server 2005. It uses TCP/IP protocol to exchange messages between instances of SQL Server 2005, prevents unauthorized users from accessing the network, and encrypts messages that are sent over the network. It provides a robust asynchronous programming model. Asynchronous programming is the most popular technique in database application programming. In asynchronous programming, the Database Engine handles commands while the application continues to run. Asynchronous programming minimizes response time and enhances application throughput of database applications.

This is a preview of Service Broker. Read the full post (1344 words, estimated 5:23 mins reading time)
Like this article? 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

No comments »

Posted in MCITP, MCITP Database Developer, MCITP Microsoft SQL Server, MCTS, MCTS Microsoft SQL Server, MCTS SQL Server 2008

Tags:

What are the types of capacity planning?

September 30th, 2009

The following are the types of capacity planning:

  • Preconfiguration capacity planning: This capacity planning involves the planning and implementation of hardware resources that will be used to accomplish a given task.
This is a preview of What are the types of capacity planning?. Read the full post (134 words, estimated 32 secs reading time)
Like this article? 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

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP

Tags:

Replication

September 29th, 2009

Replication is a type of configuration used to copy data and database objects from one database instance to another. A database administrator has to configure a server for replication, and monitor it in order to detect and resolve issues regarding replication.

Requirements for replication: The following roles are required for replication configuration:

This is a preview of Replication. Read the full post (1343 words, estimated 5:22 mins reading time)
Like this article? 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

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Administrator SQL Server 2008, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP, MCTS, MCTS Microsoft SQL Server, MCTS SQL Server 2005, MCTS SQL Server 2008

Tags:

What is Schtasks.exe?

September 27th, 2009

Schtasks.exe is a command line tool that is used to create, modify, delete, query, run, and end a scheduled task on a local or remote computer. It supports the following parameters:

  • /Create: To create a new task
  • /Delete: To delete an existing task
  • /Query: To view task list

This is a preview of What is Schtasks.exe?. Read the full post (128 words, estimated 31 secs reading time)
Like this article? 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

No comments »

Posted in MCITP, MCITP Enterprise Support Technician, MCITP Microsoft Windows Client, MCP, MCTS Windows Vista

Tags:

What is a side-by-side migration?

September 26th, 2009

In a side-by-side migration, user data is migrated from the source computer to an intermediate store. Windows Vista is installed on another computer known as a destination computer and user data is transferred to this computer instead of transferring it back to the source computer. The figure below depicts side-by-side migration:

This is a preview of What is a side-by-side migration?. Read the full post (182 words, 1 image, estimated 44 secs reading time)
Like this article? 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

No comments »

Posted in MCITP, MCITP Enterprise Administrator, MCITP Enterprise Support Technician, MCITP Microsoft Windows Client, MCITP Microsoft Windows Server, MCP, MCSE, MCTS, MCTS Windows Technology, MCTS Windows Vista

Tags:

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.