Archive for the ‘MCTS’ 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 (151 words, estimated 36 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 (158 words, estimated 38 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 (141 words, estimated 34 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 the XmlWriter class?

November 2nd, 2009

The XmlWriter class is an abstract class of the System.Xml namespace. It is used to create streams and write data to XML documents. It performs tasks such as writing various documents into one output stream, encoding binary data, and managing, flushing, and closing output stream.

Permanent link to this post (278 words, estimated 1:07 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 MCP, MCPD, MCPD .NET 2.0 Enterprise developer, MCPD .NET 2.0 Web Developer, MCPD .NET 2.0 Windows Developer, MCPD Enterprise Applications Developer, MCPD Web Developer, MCPD Windows Developer, MCTS, MCTS .NET 2.0, MCTS .NET Web, MCTS .NET Windows

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 (369 words, estimated 1:29 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:

How to create a custom culture?

October 25th, 2009

Take the following steps to create a custom culture as follows:

  1. Create the objects of CultureInfo, RegionInfo, and CultureAndRegionInfoBuilder classes as follows:

    Dim INculture As New CultureInfo(”en-IN”)
    Dim INregion As New RegionInfo(”en-IN”)
    Dim Demo As New CultureAndRegionInfoBuilder(”x-en-IN-sample”, _CultureAndRegionModifiers.None)

This is a preview of How to create a custom culture?. Read the full post (238 words, estimated 57 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 MCP, MCPD, MCPD .NET 2.0 Enterprise developer, MCPD .NET 2.0 Web Developer, MCPD .NET 2.0 Windows Developer, MCPD Enterprise Applications Developer, MCPD Web Developer, MCPD Windows Developer, MCTS, MCTS .NET 2.0, MCTS .NET Distributed, MCTS .NET Web, MCTS .NET Windows, MCTS Microsoft Visual Studio 2008

Tags:

Tip on dissecting a Web reference.

October 11th, 2009

Open the Web references node in the Solution Explorer, and click Show All Files, a tree of items appear under the node.

Permanent link to this post (103 words, estimated 25 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 MCP, MCPD, MCPD .NET 2.0 Enterprise developer, MCPD Enterprise Applications Developer, MCTS, MCTS .NET 2.0, MCTS .NET Distributed

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 (1332 words, estimated 5:20 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:

How to use GzipStream class to compress a file?

October 10th, 2009

The steps to use GzipStream class to compress a file are as follows:

  1. Import the following namespaces.

    Imports System.IO
    Imports System.IO.Compression
  2. Provide a file name that is to be compressed as follows:

    Dim filename As String= New String(@”C:Myapp empTestFile.txt”)

This is a preview of How to use GzipStream class to compress a file?. Read the full post (291 words, estimated 1:10 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 MCP, MCPD, MCPD .NET 2.0 Enterprise developer, MCPD .NET 2.0 Web Developer, MCPD .NET 2.0 Windows Developer, MCPD Enterprise Applications Developer, MCPD Web Developer, MCPD Windows Developer, MCTS, MCTS .NET 2.0, MCTS .NET Distributed, MCTS .NET Web, MCTS .NET Windows, MCTS Microsoft Visual Studio 2008

Tags:

How to set Option Explicit / Option Strict / Option Compare in the IDE?

October 10th, 2009

Take the following steps to set Option Strict / Option Explicit / Option Compare in the Integrated Development Environment (IDE) :

  1. Click on Tools menu > Options.

  2. Open the Projects and Solutions node.

  3. Select VB Defaults and modify the Option Explicit / Option Strict / Option Compare settings.

Permanent link to this post (204 words, 3 images, estimated 49 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 MCP, MCPD, MCPD .NET 2.0 Enterprise developer, MCPD .NET 2.0 Web Developer, MCPD .NET 2.0 Windows Developer, MCPD Enterprise Applications Developer, MCPD Web Developer, MCPD Windows Developer, MCTS, MCTS .NET 2.0, MCTS .NET Distributed, MCTS .NET Web, MCTS .NET Windows, MCTS Microsoft Visual Studio 2008

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.