Logo

Navigation
 

ASP.NET Creating Web Wizards

ASP.NET Creating Web Wizards In this tutorial you will learn about Rich Controls and Services, Creating Web Wizards, Working with the Wizard Control, Editing Wizard Steps, Adding a Completion Step, To edit the completion step, To show the user’s data and Testing Wizard Control. Rich Controls and Services ASP.NET 2.0 comes packaged with a number of goodies. A rich set of controls and services are a bonus to both the developer and the end user. Wizards, image generators and site navigation functions and counters are a few features that have been added. In this lesson we shall be looking in…
September 16, 2005 - - Comments:

ASP.NET : Dynamic Image control

ASP.NET Dynamic Image control In this tutorial you will learn how to create Dynamic Image Control, DynamicImage Control Properties and Custom Parameters. The DynamicImage control derives from the DynamicImageBase which is in turn derived from Image. This control acquires image bytes from varied sources and renders them to image capable devices using an internal normalization process. It stores the images in the System.Drawing.Image object and is cached in ASP.NET Cache with a randomly generated key. The HTML generates a < img > tag. The CachedImageService.axd URL is a built in HTTP handler which retrieves the image from the cache object…
September 16, 2005 - - Comments:

ASP.NET Advanced Site Functionality

ASP.NET Advanced Site Functionality In this tutorial you will learn advanced site functionality, Enhanced Page Framework, To create the Web.Sitemap file, Tracking Traffic with Site Counters and Going Mobile. Enhanced Page Framework The advanced functionalities offered by ASP.NET include site navigation and site counters. The built in navigation has three components: 1. Site Structure which is a programming interface that lists the hierarchical structure of the Website. The site map object exposes this interface using the components provided by the Site Map Provider. The default data store is usually a root level xml file named app.sitemap. 2. Site Navigation is…
September 16, 2005 - - Comments:

Oracle Apps 11i : Creating Journals through Oracle GL

. Oracle Apps 11i Free Training : Journal Entry This tutorial will describe the procedure of creating journals through oracle GL – Create a new batch with multiple Journal entries, Enter Journals to a Batch and to Enter Journal Lines. Create a new batch with multiple Journal entries Create a Journal batch The following are the steps for creation of a journal batch: 1. Navigate to the enter journals window. 2. Choose New Batch. 3. Enter an optional Batch name to identify the batch on general ledger and journal entry reports. You cannot have duplicate batch names in the same…
September 27, 2005 - - Comments:

Oracle Apps 11i : Suppliers

. Oracle Apps 11i Tutorials : Suppliers One must define a supplier before performing most activities in Purchasing and Payables. Optionally enter a recommended supplier on a requisition. Need a supplier to issue a RFQ. Use the same supplier for entering a quotation. Need supplier information for POs. Receive goods or services from suppliers. Return goods to supplier. Pay the supplier for the goods or services purchased. Suppliers can be set up from many different applications, but the data is stored in only in one place. Applications sharing supplier information include Purchasing, Payables, Assets, and Property manager. Enter/Update Supplier Base…
September 27, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Asset Book Positioning

.Oracle Apps 11i Tutorials : Asset Management – Asset Book Positioning Oracle Assets is a complete asset management solution that maintains property and equipment accurately to help you the best accounting and tax strategies. You can add, transfer, and retire assets. You can adjust for a single asset, group of assets, or financial information. Oracle assets adapts to various countries’ tax and accounting laws to accommodate fluctuating economies, unplanned depreciation, and other unforeseen circumstances. Oracle assets provides reports that you can use to inform the fixed asset manager of additions, transfers, retirements, or other unrecorded changes, ensuring that the asset…
October 9, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Asset Books Regions

Oracle Apps 11i Tutorials : Asset Management – Asset Books Regions In this tutorial you will learn about various Asset Books Regions like Calendar Region, Accounting Rules Region, Natural Accounts Region, Journal Categories Region and Asset Categories Regions. Calendar Region Allow Purge : Purges data from the asset book. GL Set of Books : Enter the GL set of books for creating journal entries. Prorate Calendar : Determine depreciation rate. Current Period : Oracle Assets updates the current period field each time the current period is closed and the next period is opened. Only one period can exist at the…
October 9, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Manual and Quick Additions

Oracle Apps 11i Free Training : Asset Management – Manual and Quick Additions In this tutorial you will lean about Manual and Quick Additions – Adding Assets Manually, Quick Additions, Detail Asset Additions – Using the Asset Details Window, Using the Books Window, Using the Assignments Window and Using the Source Lines Window. Manual and Quick Additions Adding Assets Manually You use Quick Additions to add assets manually. All assets added to the primary asset book are automatically converted to the reporting currencies asset books when you save transaction. Based on asset date placed in service, Oracle Assets retrieves an…
October 9, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Mass Additions

.Oracle Apps 11i : Asset Management – Mass Additions In this tutorial you will learn about Mass Additions – The Mass Addition Process, Create Mass Additions, Prepare Mass Additions, Post Mass Additions and Delete Mass Additions.   Mass Additions Mass Additions Process Step 1 Create Mass Additions : Run Mass Additions Create from Oracle Payables to copy invoice distribution lines representing potential assets into the FA_MASS_ADDITIONS interface table in Oracle Assets. Figure 1. Run the Mass Additions Create program. Step 2 Prepare Mass Additions : Use Prepare Mass Additions to enter additional data for a mass addition; add a mass…
October 9, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Asset Adjustments

Oracle Apps 11i : Asset Management – Asset Adjustments In this tutorial you will learn about Asset Adjustments – Single Asset Reclassification, Adjusting Units, Assigning Units, Adjusting Financial Information and Single Asset Transfers.   Asset Adjustments You can adjust an asset by reclassifying, changing the number of units, adjusting the financial information, or performing a mass change. Single Asset Reclassification Figure 1. Navigating to Single Asset Reclassification. Figure 2. Single Asset Reclassification. Reclassify assets to update information, correct data entry errors, or when consolidating categories. Adjusting Units a) You can change the number of units for the asset in the…
October 12, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Mass Transfers

Oracle Apps 11i : Asset Management – Mass Transfers In this tutorial you will learn about Asset Management – Mass Transfers; a) Mass Reclassifications, b) Using Mass Changes and c) Mass Asset Transfers. Mass Transfers a) Mass Reclassifications Figure 1. Navigate to Mass Reclassifications. Figure 2. Create Mass Reclassifications. Figure 3. Running Mass Reclassification.(Request # 3067276 and 3067277) You can reclassify a group of assets using the Mass Reclassifications window. In addition to reclassifying assets to a new category, when you run the Mass Reclassification process, you have the option to have assets inherit the depreciation rules of the new…
October 12, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Depreciation

Oracle Apps 11i : Asset Management – Depreciation In this tutorial you will learn about Asset Management – Depreciation ; a) Elements, b) Basic depreciation calculation, c) Calculate Annual Depreciation, d) Allocate Annual Depreciation across Periods, e) Spreading Depreciation across Expense Accounts, f) Methods, g) Run-Depreciation, h) Closing a Depreciation Period and i) Programs Depreciation a) Elements Define corporate, tax, and budget asset books. Define the corporate book first to associate it with multiple tax and budget books. Oracle Assets provides many standard depreciation methods. Set up additional methods if required. b) Basic depreciation calculation Prorate date Oracle Assets prorates…
October 13, 2005 - - Comments:

Security Features in SQL Server 2005 for the Developer

Overview of SQL Server 2005 for the Developer-Security In this tutorial you will learn about Security Features in SQL Server 2005 – Authentication, Password Complexity, Password Expiration, Lockout Behavior, Endpoint-based Authentication, Authorization, Native Data Encryption, Code and Module Signing, SQL Server Agent Operations, Monitoring and Auditing   Authentication SQL server has been designed to be “secure by default”. However, it has a number of customizable features that further increase the degree of protection—Authentication, Authorization and encryption. The settings have been optimized and avoid installing non essential components and features that can expose the server and its data to attacks. It…
October 15, 2005 - - Comments:

T-SQL Enhancements in SQL Server 2005

T-SQL Enhancements in SQL Server 2005 In this tutorial you will learn about T-SQL Enhancements in SQL Server 2005 – Data Definition Language Statements, .NET framework integration, Full Text Search, Index transact SQL Statements, Security Transact SQL Enhancements, Service Broker T-SQL statements, Synonym Transact SQL Statements, Table and Index Partitioning Transact SQL Enhancements, Table Transact SQL Enhancements, Triggers and Event Notification Transact SQL Enhancements. T-SQL enhancements in SQL Server 2005 range from alternative mechanisms for transaction isolation to declarative support for hierarchical queries. The statement level recompilation also improves existing T-SQL applications that were written before 2005. The improvements to…
October 15, 2005 - - Comments:

Data Manipulation Language (DML) in SQL Server 2005

Data Manipulation Language (DML) in SQL Server 2005 In this tutorial you will learn about Data Manipulation Language (DML) – New Data Types, New Operators, The APPLY Operator, Ranking Functions, The OUTPUT Statement, Common Table Expressions(CTE), OTHER DML and T-SQL functions, TABLESAMPLE, Exception Handling, and Procedure for using Structured Exception handling. Data manipulation Language (DML) is a set of statements that help manipulate data in the database. The heart of the DML is T-SQL. A number of enhancements have been made to T-SQL in the Yukon version. In this section we shall examine some of the new statements that have…
October 15, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Retirements

Oracle Apps 11i : Asset Management – Retirements In this tutorial you will learn about Asset Management – Retirements; Types of Asset Retirement. – Full Retirement, Partial Retirement, Undo or Reinstate Retirements, Retiring Separately Across Depreciation Books, Reinstating Retired Assets – Reinstating with a PENDING status, Reinstating with a PROCESSED Status and Reversing a Reinstatement. Retirements 1. You retire an asset fully or partially when it is lost, stolen, damaged, sold, returned, or for any other reason that causes you to stop using it. 2. You retire assets by units or costs. 3. You can perform a mass retirement by…
October 16, 2005 - - Comments:

Oracle Apps 11i : Asset Management – Journal Entries

Oracle Apps 11i : Asset Management – Journal Entries In this tutorial you will learn about Journal Entries: Assets Journal Entries Flow – Oracle Assets creates journal entries for depreciation expense, asset cost, other accounts, and automatically creates general ledger transaction journal entries, if you have set up the journal entry category for that transaction type in the asset book. Journal Entries: Assets Journal Entries Flow The GL period for which you want to create journal entries must be open, The period name in the depreciation calendar assigned to the asset book must be the same as that in the…
October 16, 2005 - - Comments:

SQL Server 2005 – Service Broker

SQL Server 2005 – Service Broker Introduction The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker. The Transact SQL Data Manipulation Language is used to the send messages to a queue in the database of the sender or to another database in the SQL Server instance, or another server instance or remote server. Conceptually the process involves queues, dialogs, conversations groups and activation. In this tutorial we will briefly examines these concepts before having a practical look at what happens when messages are sent or received by the…
October 17, 2005 - - Comments:

Using Notification Services in SQL Server 2005

Using Notification Services in SQL Server 2005 In this tutorial you will learn about using notification services in SQL Server 2005, Notification Services Architecture, Building Notification Services Solutions, Using Notification Services, Subscription Management, Syntax for adding subscribers, Syntax for adding a device, Syntax for Adding the Subscriptions. Notification Services Architecture Building Notification Services Solutions This new feature of SQL Server 2005 is directed towards the delivery of event driven or scheduled notifications to users who have opted to receive such notifications. Developers find this feature extremely useful for developing and deploying applications that require notifications to be sent to users…
October 25, 2005 - - Comments:

Bug Life Cycle & Guidelines

Bug Life Cycle & Guidelines In this tutorial you will learn about Bug Life Cycle & Guidelines, Introduction, Bug Life Cycle, The different states of a bug, Description of Various Stages, Guidelines on deciding the Severity of Bug, A sample guideline for assignment of Priority Levels during the product test phase and Guidelines on writing Bug Description. Introduction: Bug can be defined as the abnormal behavior of the software. No software exists without a bug. The elimination of bugs from the software depends upon the efficiency of testing done on the software. A bug is a specific concern about the…
October 25, 2005 - - Comments:

Technical Terms Used in Testing World

Technical Terms Used in Testing World In this tutorial you will learn about technical terms used in testing world, from Audit, Acceptance Testng to Validation, Verification and Testing. Audit: An independent examination of a work product or set of work products to assess compliance with specifications, standards, contractual agreements, or other criteria. Acceptance testing: Testing conducted to determine whether or not a system satisfies its acceptance criteria and to enable the customer to determine whether or not to accept the system. Alpha Testing: Acceptance testing performed by the customer in a controlled environment at the developer’s site. The software is…
October 25, 2005 - - Comments:

Risk Analysis

Risk Analysis In this tutorial you will learn about Risk Analysis, Technical Definitions, Risk Analysis, Risk Assessment, Business Impact Analysis, Product Size Risks, Business Impact Risks, Customer-Related Risks, Process Risks, Technical Issues, Technology Risk, Development Environment Risks, Risks Associated with Staff Size and Experience. Risk Analysis is one of the important concepts in Software Product/Project Life Cycle. Risk analysis is broadly defined to include risk assessment, risk characterization, risk communication, risk management, and policy relating to risk. Risk Assessment is also called as Security risk analysis. Technical Definitions: Risk Analysis: A risk analysis involves identifying the most probable threats to…
October 26, 2005 - - Comments:

Using XML in SQL Server 2005

Using XML in SQL Server 2005 In this tutorial you will learn about using XML in SQL Server 2005 – XML enhancements in SQL Server 2005, the FOR Clause, Using XSINIL with ELEMENTS, Using elementsxinil in EXPLICIT mode and Enhancements to OpenXML function   XML enhancements in SQL Server 2005 Microsoft SQL Server 2000 introduced XML capabilities to the server in a very limited manner. Developers could export relational data as XML and shred the same back into XML. However, such data could not be stored in the database, except as large string values—the data of which could not be…
October 26, 2005 - - Comments:

XML Data Types in SQL Server 2005

XML Data Types in SQL Server 2005 In this tutorial you will learn about XML Data Types, Query and Inexes in SQL Server 2005 – XML Data type, XML Typing, Advantages of storing XML in databases, Untyped XML data, Using Typed XML, Managing XML indexes, XQuery and XQuery syntax. XML Data type As stated above the XML data type is a new introduction in SQL Server 2005. It enhances the developer’s ability to work with XML within the framework of T-SQL. This data type can be used just like any other data type, be it a typing of variables or…
October 26, 2005 - - Comments:

Native HTTP Support in SQL Server 2005

Using Native HTTP Support in SQL Server 2005 In this tutorial you will learn about Using Native HTTP Support, Native HTTP Support in SQL Server 2005 and Configuring Native HTTP Support . Using Native HTTP Support SQL Server 2005 has the built in capability of delivering fully functional web services. The HTTP endpoint is more than just an extension of XML abilities. It can return row sets, scalar values, messages and errors serialized into XML automatically. The technology utilizes XML, supports sessions, and monitors SOAP connections and other database server connections. SQL Server 2005 permits user to create stored procedures…
November 1, 2005 - - Comments:

NET CLR in SQL Server 2005

Using .NET CLR in SQL Server 2005 In this tutorial we will introduce the concepts relating to CLR integration with SQL Server 2005 including how to implement managed code. New types and aggregates extend the functionality of SQL Server 2005. The Common Language Runtime enables developers write procedures, triggers and functions in any of the languages supported. SQL server CLR integration is achieved in a few steps: 1. The developer has to write the managed code as a set of class definitions. These include stored procedures, functions, triggers written as static methods of a class. User defined types and aggregates…
November 1, 2005 - - Comments:

SQL Server Management Objects

SQL Server Management Objects In this tutorial we shall learn about SQL Server Management Objects, briefly examine the different objects available for the process, Connecting to the Server, Database objects and Collections and Scripting. The Administrative programming interface of SQL Server 2005, eases the process of managing SQL Server Management objects. The developer is given a complex array of objects that are specifically designed to assist in the task. Connecting to the Server Before actually beginning the task of managing objects, the developer must connect to the server. This can be done by way of standard authentication or integrated security….
November 1, 2005 - - Comments:

Developing Client applications in SQL Server 2005

Developing Client applications in SQL Server 2005 In this tutorial you will learn about developing client applications in SQL Server 2005, The context connection, Restrictions for the context connection, ADO.NET in different SQLCLR objects, Avoiding SQL CLR +ADO.NET, System.Transactions, ADO.NET and SQLCLR. A .NET data provider is a link between an application and a data source. The link returns result sets from the data source and propagates changes to the data source. SQL Server 2005 is highly integrated with .NET Framework. Stored procedures, functions, user-defined types and user defined aggregates can be created using .NET supported programming languages. The constructs…
November 1, 2005 - - Comments:

Delegates in C#

Delegates in C# Most programmers are used to passing data in methods as input and output parameters. Imagine a scenario where you wish to pass methods around to other methods instead of data. Amazed! Read further. Consider a scenario where you need to make a ‘business decision’ in your program, to make a decision you need data. To get data you need to call a method. However the method name is not known at design time. It will only be known at run time. In this case you need to pass the unknown method as a parameter. The method that…
November 8, 2005 - - Comments:

Building Web Based N-Tier Applications using C#

Building Web Based N-Tier Applications using C# This article explores the N-tier and Distributed Application Architecture. Over the last decade, the way applications are designed has evolved and come a long way. We have stand-alone applications, server based applications, client server applications, web based applications, n-tier applications, distributed applications, Peer-to-peer apps, service-oriented Architectures, component based Development and the list goes on. This article discusses the advantages, disadvantages of n-tier applications and methods to implement web based n-tier Applications using C#, .NET Why N-Tier Applications? N-Tier Applications can easily implement the concepts of Distributed Application Design and Architecture. The N-Tier Applications…
November 8, 2005 - - Comments:

Inheritance in C#

Inheritance in C# This article discusses Inheritance concepts in the context of C# Before we understand Inheritance in C# it is important to understand the key players involved, viz Objects, Classes and Structs Classes and Structs are ‘blue-prints’ or templates from which we instantiate (create) objects Example a car may be created based on its blue print Car is the object and blue print is the class (or template) What are types? An object can be of the following types – Class or Struct There are many differences between the two ‘types’ The main difference between the two is the…
November 11, 2005 - - Comments:

Test Cases, Test Scenarios Interview Questions

Test Cases, Test Director and Test Scenarios Interview Questions This article provides Software Testing Interview Questions covering Test Cases, Test Scenarious and Test Director questions. For more Interview Questions / Answers related to testing, click on links provided at the end of each question set… Test Cases 1. How will you prepare test cases? 2. Write the testcases on ATM Transactions? 3. What is meant by Hot Keys? 4. How is test case written? 5. How can we write a good test case? 6. How will you check that your test cases covered all the requirements 7. For a triangle…
November 14, 2005 - - Comments:

Regular Expressions and C#, .NET

Regular Expressions and C#, .NET This Article explores the concept of Regular Expressions in the context of C#, .NET support for Regular Expressions, Meta-characters and their Description, Character Escapes, Substitutions, Character Classes, Regular Expression Options and Atomic Zero-Width Assertions. What are regular expressions? Regular expressions are Patterns that can be used to match strings. You can call it a formula for matching strings that follow some pattern. Regular expression(s) can be considered as a Language, which is designed to manipulate text. You can then ask questions such as “Does the given string match the pattern?”, or “Does the given string…
November 14, 2005 - - Comments:

Regular Expressions in C# – Quantifiers and Delegates

Regular Expressions in C# – Quantifiers and Delegates In this tutorial you will learn about Quantifiers, Grouping constructs, Backreferences, Backreference Constructs, Alternation Constructs, Miscellaneous Constructs, System.Text.RegularExpressions Namespace, Delegates in the namespace System.Text.RegularExpressions and Typical Examples of Regular Expressions. Quantifiers Quantifiers add optional quantity data to a regular expression. A quantifier expression applies to the character, group, or character class that immediately precedes it. Quantifier Description * Specifies zero or more matches; for example, \w* or (abc)* + Specifies one or more matches; for example, \w+ or (abc)+ ? Specifies zero or one matches; for example, \w? or (abc)? {n} Specifies…
November 14, 2005 - - Comments:

.NET Remoting

.NET Remoting Remoting enables software components to interact across application domains. The components interacting with each other can be in different processes and systems. This enables us to create n-tier Distributed applications. For more details on N-tier Applications see the article on n-tier Applications in this series. In this article we try to explain .NET Remoting in a clear and concise manner The .NET Remoting Architecture: Here is a simplified illustration of the .NET Remoting Architecture. The Key Players are: ………..– Client Object ………..– Server (Remote) Object ………..– Proxy Object ………..– Formatter ………..– Channel Client Object is the object or…
November 15, 2005 - - Comments:

. NET Type Safety

. NET Type Safety   This Article discusses “What is Type Safety?” in the context of .NET, What is Type Safety? How does Type Safety affect us? Why is Type Safety Important? Writing Type-Safe Code. How is Type Safety ensured? What is Verifiable Type Safe Code? Verification process, How to determine if the code is type safe? What if the Code is not verifiably type safe? and What can happen if the Code is not verifiably type safe?   What is Type Safety? Type safe means preventing programs from accessing memory outside the bounds of an object’s public properties A…
November 15, 2005 - - Comments:

SQL Server 2005 Administrative Tools

SQL Server 2005 Administrative Tools Using SQL Sever Management Studio A Database Administrator typically grapples with tasks relating to accessing, configuring and administrating the components of the SQL Server. To assist the Administrator in this task, SQL Server 2005 provides a graphical user interface called the SQL Server Management Studio. The SQL Server Management Studio combines graphical user interface with a rich script editor, so that administrators can script and administrate from a single window. The SQL Server Management studio harnesses the power of the Enterprise manager and Query Analyzer of the earlier versions and also provides a single window…
November 19, 2005 - - Comments:

SQL Server 2005 – Registered Servers

SQL Server 2005 – Registered Servers Registered servers can be viewed in the Registered servers window. Servers can be created and registered, renamed or removed in the SQL Server Management Studio. Information on frequently accessed servers will be stored in the Management Studio on Registration. To Register a server Right click a node in the Registered Server’s Tree and click Update Local Server Registration. This updates the local server registration. If a new server has to be created and registered 1. Click Database Engine in the Registered Servers tool bar 2. Right click Microsoft SQL Servers and point to New…
November 19, 2005 - - Comments:

SQL Server 2005 – Server Groups

SQL Server 2005 – Server Groups In this tutorial you will learn about Server Groups. As stated earlier, servers can be grouped together. Each group can be assigned a name. The name of the server group can also be changed by right clicking on the group name, pointing to edit and selecting Server Group properties. The name can be changed in the dialog box that opens. 1. Server Groups can be created by right clicking the server type in the Registered servers toolbar. 2. Right click on a server or a server group and point to New and Click Server…
November 19, 2005 - - Comments:

C# Language Basics

This article provides an overview of the C# Language. The various elements and building blocks of the C# language are explained. Background What is C# all about? C# was developed at Microsoft. It is an object-oriented programming language and provides excellent features such as strong type checking, array bounds checking and automatic garbage collection. We will explore these and several other features in this article. C# has features that make it an excellent choice for developing robust distributed n-tier Enterprise applications, web applications, windows applications and embedded systems. It is used for building applications ranging from the very large that…
November 23, 2005 - - Comments:

SQL Server 2005 – Management studio interface Summary Page

SQL Server 2005 – Management studio interface Summary Page The summary page appears as the largest window on the Management studio interface. This window presents information about the item selected in the object window. The summary page can be configured to start as soon as SQL Server Management Studio starts or later. When the list mode is selected the summary page shows information about the higher nodes. When lower nodes are double clicked the information with reference to the clicked item is displayed. Clicking on F7 invokes the summary page. The summary page can be displayed at startup by clicking on…
November 23, 2005 - - Comments:

SQL Server 2005 Architecture Overview

In this tutorial you will learn about SQL Server 2005 Architecture, What’s New in SQL Server 2005—Enhancements for Data Base Administrators. indexing capabilities, peer to peer model of replication, Table and index partitioning, snapshot isolation, Replication monitor tool, security model, Encryption capabilities, Secure computing, A new application framework, SQL Server Express Manager (XM), Business Intelligence in SQL Server 2005, Integration services, Analysis Services, Data mining, Reporting services, Windows Server System Common Engineering Roadmap. The innumerable data challenges faced by modern day organizations have leveraged the need for faster and more data driven decisions. The drive is to increase productivity, flexibility…
November 23, 2005 - - Comments:

SQL server 2005 Editions

SQL server 2005 Editions The SQL Server 2005 family includes a number of editions—Express, Workgroup, Standard and Enterprise . Each of these editions comes with a range of features. These include high availability, Scalability to high business Intelligence tools—all aimed at empowering the organization and catering to mission critical information streaming down the levels in accordance with the security and authentication policies defined. The low cost mainstream database gives value and functionality and is a dramatic step forward in reducing application downtime. The following table indicates the scalability and performance parameters of the different editions. Scalability and Performance    …
November 23, 2005 - - Comments:

SQL Server 2005 Installation

SQL Server 2005 Installation An interactive set up program helps the setup of SQL Server 2005. The steps have been designed to help the Administrator select the requisite options along the way. The setup screen automatically starts up as soon as the CD/DVD is inserted into the drive. If it does not, the user can start the setup process by browsing the contents of the CD/DVD and double clicking the setup.exe.   The first screen to be displayed is the end user license agreement(EULA). The user is expected to read through the license agreement and accept the license before he…
November 23, 2005 - - Comments:

.NET and J2EE – A Comparsion Study

.NET and J2EE – A Comparsion Study This tutorial compares .NET and J2EE, discussing various features of both the technolgoies and summarising when and where these technologies are suitable to use for entriprise application.   Competitive or Complementary? Introduction With the introduction of .NET technology Microsoft was focused to enjoy monopoly in market of development of enterprise applications. But later on J2EE even though being an open source technology fought back and made sure that most of enterprise applications are developed over the top of J2EE framework. In this article we are not going to take side of any of…
November 26, 2005 - - Comments:

Future of Java Technology

Future of Java Technology When Java was developed initially as OAK even its developers were not sure in which direction the technology will grow. And actually Java has taken an unexpected turn around as a development technology. It started its journey with embedded applications but people found it somewhat slow when compare to C++. Java made foray into web in the form of applets and ruled the world for sometime. But then came enterprise era with crusade of .NET and J2EE. In this article let us examine possible directions where there are chances Java will grow as development technology. The…
November 26, 2005 - - Comments:

Is Ejb really significant in enterprise applications?

Is Ejb really significant in enterprise applications? Ejb was introduced to Java technology to attain some features inherent in enterprise applications. Those features include instance pooling, inbuilt security, declarative transactions, container managed persistence, relationship of business objects and caching etc. Now that many people have built their applications using Ejb, let us go back and analyze if Ejb as a technology is really significant in developing enterprise applications. We are going to analyze both pros and cons of Ejb based on experience of people who have used Ejb. Not Always Some experts strongly believe that Ejb is not really that…
November 26, 2005 - - Comments:

Java for Stand-Alone Applications

Java For Stand-Alone Applications Java programming language was primarily developed to deal with embedded applications. But with the introduction of Swing and other user interface utilities to Java, it made its mark in desktop applications too. Now the trend is to use Java technology in developing large web and enterprise applications. Java is more focused on web then desktop applications. But, in this article, we are going to discuss how useful Java is as a development technology for stand alone desktop application development in present scenario. Java is Suitable for Desktop Applications There are several applications built on Java technology….
November 26, 2005 - - Comments:

Software Architecture & Design Patterns

Software Architecture & Design Patterns This article reviews some of the architecture Design patterns for Enterprise Applications built using the .NET Platform. Application Architecture: Software Applications come in all shapes and sizes. Based on their design and architecture enterprise applications can be classified into various categories such as: * Distributed Applications * Web Applications * Web Services * Smart Client Applications This article reviews some of the architecture Design patterns for Enterprise Applications built using the .NET Platform. Simply put Application architecture is: – Set of significant decisions about how a software system is organized – Selection of the elements…
November 26, 2005 - - Comments:

Creational Design Patterns

Creational Design Patterns Creational Design is one of the Design Patterns used with .NET. In this tutorial you will learn about Creational Design Patterns, Factory Method, Abstract Factory, Builder, Prototype and Singleton. Creational Patterns : * Factory Method * Abstract Factory * Builder * Prototype * Singleton Category : Creational Pattern Pattern : Factory Design Brief Description : This being a ‘creational design pattern’ it focuses on how the objects are created. In the Factory design pattern – the client uses a specialized object solely to create other objects. In the diagram, you would observe that the object (“product”) creation…
November 26, 2005 - - Comments:

Structural and Behavioral Design Patterns

Structural and Behavioral Design Patterns In this tutorial you will learn about Structural Patterns – Adapter, Bridge, Composite and Proxy. You will also learn about Behavioral Patterns – Iterator and Observer.Category : Structural Pattern Design Pattern : Adapter Brief Description : Highlights of the Adapter Design Pattern are: – This is a Structural Design Pattern and focuses on how the objects interact – relationships/interfaces between entities and objects – The key players are Generic Object with its interface Client specific Object with client specific interface Adapter Object that adapts the generic interface to the client specific interface llustration :  …
November 26, 2005 - - Comments:

New Features In Java 5.0 – From Managers Point of View

New Features In Java 5.0 – From Managers Point of View The much awaited Java 5 has been launched in recent past by Sun. People who are in IT or related to IT industry were interested about its consequences on many factors. People who are developing applications using Java as a developing technology were more interested in new language features and other technological enhancements. But others for whom it is important to manage such process from higher level were more interested in things that are going to change with Java 5. In this article we are going to discuss enhancements…
November 26, 2005 - - Comments:

New Features in Java 5 – From Programmers Point of View

New Features in Java 5 – From Programmer’s Point of View With emergence of Java 5, a set of new features is included in Java technology. Many programmers working on Java technology were excited before its release about its new features. In this article, new features of Java 5 are summarized which are important from programmer’s point of view. Language Features Get Rid of ClassCastException With Generics It is very common experience among programmers to face ClassCastException at run time while integrating different parts (modules) of application which are interacting with each other in form of collections where collections are…
November 26, 2005 - - Comments:

Planning to Install SQL Server 2005

Planning to Install SQL Server 2005 Different organizations have different application needs and hence installation requirements also vary. The different editions of Microsoft SQL Server cater to the varied needs and accommodate the performance, runtime and price requirements of organizations and individuals. The components that are installed on the server also will depend on the needs defined by the entity. Selecting an edition of SQL Server 2005 to Install SQL Server 2005 is available in a number of editions. However, organizations with mission critical information and large databases often select among three editions of the MS SQL Server 2005—the Enterprise…
November 29, 2005 - - Comments:

Installing a Second Copy of SQL Server 2005

Installing a Second Copy of SQL Server 2005 Multiple instances of SQL Server are supported by SQL Server 2005. Previous versions of SQL Servers can also be upgraded to SQL Server 2005. In this section we shall see how to install a second copy of SQL Server 2005. A little later in this tutorial we shall examine how existing versions of SQL Server can be upgraded. If a version of SQL Server already exists on the computer, the second copy will be installed as a named instance. Insert the DVD into the drive and the Installation wizard will guide you…
November 29, 2005 - - Comments:

SQL Server 2005 Installation – Maintenance Plan Using Wizard

SQL Server 2005 Installation – Maintenance Plan Using Wizard Maintenance plans can be created using the Maintenance Plan Wizard or using the design surface. The Wizard is useful if the DBA wants to create a basic maintenance plan. If he intends to create enhanced work flow then, it is advisable to use the design surface. Maintenance Plans are displayed only to users connected using the Windows Authentication.   Invoking The Maintenance Plan Wizard from Add/Remove Programs. One method of accessing the Maintenance Plan Wizard is by navigating to the Add/Remove programs panel of the Operating system. Each option of SQL…
November 29, 2005 - - Comments:

SQL Server 2005 Installation – Maintenance Plan Without Using Wizard

SQL Server 2005 Installation – Maintenance Plan Without Using Wizard Earlier you learnt about Maintenance Plan Using Wizard, In this tutorial you will learn about Maintenance Plan Without Using Wizard. You will also learn how to change the tasks in the Maintenance Plan Wizard.   Creating a Maintenance Plan without using the Wizard. 1. In Object Explorer, expand a server, and then expand Management. 2. Right-click Maintenance Plans and select New Maintenance Plan. 3. In the New Maintenance Plan dialog box, type a name for the plan. 4. The Toolbox opens, and the [Design] surface opens. 5. On the Design…
December 2, 2005 - - Comments:

Performance Tuning of Java Applications

Performance Tuning of Java Applications Ever since the first version of Java Technology hit the streets, performance has been an important issue for Java developers. Java has improved dramatically and continually but, performance tuning is very essential to get the best results, especially when we think of J2EE applications. Introduction: Java Performance Tuning (abbreviated as JPT), 2nd edition provides a comprehensive guide to eliminate all the types of performance problems. By considering real-life examples JPT shows how to get rid off all the types of performances problems. For example JPT shows tricks such as how to minimize object creation and…
December 2, 2005 - - Comments:

Keep it Simple And Secure with Java

Keep it Simple And Secure with Java This article goes into details of how Java as a development technology can help developers to keep their applications simple and secure. Simple mean all way – it should be simple to code, modify, maintain, fix and deliver. Also we are going to cover security aspects of Java technology. Simple to Develop So let us first analyze how can we make it simple to develop applications, integrate them, modify them, maintain them and deliver them with ease. Some people have misunderstanding that Java is very complicated technology for developing application. But they forget…
December 2, 2005 - - Comments:

Software Cost Estimation

Software Cost Estimation This article aims to study the process of Software Cost Estimation and its impact on the Software Development Process. We also highlight the various challenges involved in Software Cost Estimation and common solutions to navigate through these challenges. Background: Software Cost Estimation is widely considered to be a weak link in software project management. It requires a significant amount of effort to perform it correctly. Errors in Software Cost Estimation can be attributed to a variety of factors. Various studies in the last decade indicated that 3 out of 4 Software projects are not finished on time…
December 2, 2005 - - Comments:

Software Project Planning

Software Project Planning This article explores the various aspects of Software Project Planning and Scheduling. Project planning is an aspect of Project Management, which comprises of various processes. The aim of theses processes is to ensure that various Project tasks are well coordinated and they meet the various project objectives including timely completion of the project. What is Project Planning? Project Planning is an aspect of Project Management that focuses a lot on Project Integration. The project plan reflects the current status of all project activities and is used to monitor and control the project. The Project Planning tasks ensure…
December 4, 2005 - - Comments:

Software Quality Management

Software Quality Management This article gives an overview of Software Quality Management and various processes that are a part of Software Quality Management. Software Quality is a highly overused term and it may mean different things to different people. You will learn What is Software Quality Management?, What does it take to Manage Software Quality?, Quality Planning, Quality Assurance, Quality Control, Importance of Documentation and What is Defect Tracking? The definition of the ISO 8204 for quality: “Totality of characteristics of an entity that bears on its ability to satisfy stated and implied needs.” This means that the Software product…
December 5, 2005 - - Comments:

Syllabus for Certified Software Tester

Syllabus for Certified Software Tester In this tutorial you will learn about Syllabus for Certified Software Tester, Skill Categories, Test Principles and Concepts, Tester’s Role in Software Development and Acquisition, Test Management, Build the Test Environment, Risk Analysis, Test Planning Process, Test Design, Performing Tests, Defect Tracking and Correction, Acceptance Testing, Status of Testing, Test Reporting. The Certified Software Test Exam concentrates more on the following areas: Knowledge on the Test Environment. Ability to plan tests. Ability to execute tests, design test cases, use test tools, etc. Ability to develop testing status reports. Skill Categories: The basic categories to be…
December 5, 2005 - - Comments:

Metrics Used In Testing

Metrics Used In Testing In this tutorial you will learn about metrics used in testing, The Product Quality Measures – 1. Customer satisfaction index, 2. Delivered defect quantities, 3. Responsiveness (turnaround time) to users, 4. Product volatility, 5. Defect ratios, 6. Defect removal efficiency, 7. Complexity of delivered product, 8. Test coverage, 9. Cost of defects, 10. Costs of quality activities, 11. Re-work, 12. Reliability and Metrics for Evaluating Application System Testing. The Product Quality Measures: 1. Customer satisfaction index This index is surveyed before product delivery and after product delivery (and on-going on a periodic basis, using standard questionnaires).The…
December 5, 2005 - - Comments:

J2EE Overview

J2EE Overview J2EE is a technology that aims to simplify the design and implementation of enterprise applications. In this tutorial you will learn what J2EE is, its benefits, J2EE main components, Evolution of Enterprise Application Frameworks, Why use J2EE, J2EE Platform Architecture, J2EE APIs and Technologies and J2EE Reference Implementation. Before continuing our J2EE discussion lets define what an enterprise application is. Enterprise application is an application which probably has legacy existing applications and databases that you want to continue using them while adding or migrating to a new set of applications that exploit Internet, e-commerce and other new technologies….
December 6, 2005 - - Comments:

Servlet Basics

Servlet Basics Servlets are Java programs running on a web server that produce results viewed remotely on a web server. Servlets has the same purpose that CGI or PHP had in the past. We shall describe how Servlets works with some examples. You will also learn about Servlet Request and Response Model, Servlet Life Cycle, Servlet Scope Objects and Error Handling. Servlet Request and Response Model Note that although there are two types of servlets (GenericServlet and HttpServlet), we will discuss here only HttpServlet since GenericServlet can be used for advanced needs. The important thing here is that you should…
December 6, 2005 - - Comments:

SQL Server 2005 – Unattended Installations

SQL Server 2005 – Unattended Installations In this tutorial you will learn about SQL Server 2005 – Unattended Installations, How to perform a silent installation of SQL Server, To Create .iss file, Basic Header Information for Our Script Files, Checking for the Parameters within the Script, Sample of the Combination of the .iss File within the Batch File, To set the security modes use the following code. Unattended installation is an installation of SQL Server that is done entirely using a script embedded in an .ini file. This file can be created using any text editor. This file is composed…
December 7, 2005 - - Comments:

SQL Server 2005 – Upgrading from earlier versions of SQL Server

SQL Server 2005 – Upgrading from earlier versions of SQL Server In this tutorial you will learn about SQL Server 2005 – Upgrading from earlier versions of SQL Server. SQL Server 2005 permits the upgrading from version 7.0, 2000 (with service pack 3) and 2003. SQL Server 6.5 will have to be upgraded to SQL Server 7.0 with service pack 7.0 and then to SQL Server 2005. The process of upgrading to these various versions requires a lot of careful planning. Data, Data Transformation Services packages, agent jobs, replication setup, failover clustering setup, Analysis Services objects, Full text search objects,…
December 7, 2005 - - Comments:

SQL Server 2005 – Testing Troubleshooting

SQL Server 2005 – Testing Troubleshooting In this tutorial you will learn about Testing and Troubleshooting, SQL server services: Distributed Transaction Coordinator, Registry settings, SQL server settings, Configuring SQL server internal settings, Configuring Network Protocols. Testing and Troubleshooting Components of SQL Server may fail individually or individual components may fail when the SQL Server is run. This may be due to installation problems or other errors. A best practice that is followed is to enable the Error and usage Report settings at the time of installation. In SQL server 2005 the Usage data collection and Error Reporting features are enabled…
December 12, 2005 - - Comments:

SQL Server Monitoring Tools – Server Profiler

SQL Server Monitoring Tools – Server Profiler In this tutorial you will learn about SQL Server Profiler, To start SQL Server Profiler in SQL Server Management Studio, To start SQL Server Profiler in Database Engine Tuning Advisor, Security, Space Requirements, To change the TEMP environment variable in Windows operating systems, Using SQL Server Profiler and Analysis Services, Replay for Queries, Discovers and commands SQL Server Profiler SQL Server Profiler is a graphical tool that helps in the monitoring of an instance of SQL Server Database Engine or Analysis Services. The data about each event can be captured to a file…
December 12, 2005 - - Comments:

SQL Server 2005 – Using DDL Triggers

SQL Server 2005 – Using DDL Triggers In this tutorial you will learn about DDL Triggers vs DML Triggers, Syntax for creating a DDL Trigger, Designing a DDL Trigger, The EVENTDATA() Function, Implementing a Database-Scoped DDL Trigger, Implementing a Server-Scoped DDL Trigger, Event Notifications vs. DDL Triggers and General Trigger Considerations. DDL triggers fire stored procedures in response to DDL Statements which begin with CREATE, ALTER and DROP. The DDL triggers require that the DDL statements that trigger them are run and these triggers cannot be used as INSTEAD OF triggers. The DDL events that fire the DDL triggers have…
December 12, 2005 - - Comments:

Servlets Advanced

Servlets Advanced After describing some basic programming of servlets, we will describe some advanced topics of servlets in this tutorial, viz., Session Tracking, Servlet Filters, Servlet Life Cycle Events, Including, forwarding and redirecting, Servlet Chaining and Applet Servlet Communication. Session Tracking HTTP is a stateless protocol which means that each request done using HTTP is independent from each other. This is a restriction in HTTP since some applications like e-commerce sites require to hold state information. One of the traditional examples of state is a shopping cart. In this tutorial, we will learn how to hold states between HTTP requests…
December 12, 2005 - - Comments:

SQL Server 2005 – Using Event Notifications

SQL Server 2005 – Using Event Notifications In this tutorial you will learn about SQL Server 2005 – Using Event Notifications, Creating Event Notifications, Creating an Event Notification, Creating the Target Service, Creating /Dropping / modifying the Event Notification and Using Metadata Views. DDL statements or SQL Trace events execute Event Notifications. The information is sent to a Service Broker Service. These event notifications help in logging and reviewing changes occurring in databases. They perform action in response to an event in an asynchronous manner. They can be said to offer a programming alternative to DDL triggers and SQL Trace….
December 13, 2005 - - Comments:

Oracle Reports 6i

Oracle Reports 6i In this tutorial you will learn about Introduction to Oracle Reports Builder, Report file storage formats, Oracle Reports Builder Tools, Report Wizard, Triggers in Reports, Types of Triggers and Case Study – Creating a Tabular report. Introduction to Oracle Reports Builder Oracle Reports Builder is a powerful enterprise reporting tool used to build reports that dynamically retrieve data from the database, format, display and print quality reports. Reports can be stored in File or Database (Report Builder Tables). Report file storage formats .rdf Report • Binary File Full report definition (includes source code and comments) • Modifiable…
December 13, 2005 - - Comments:

Using SQL Sever Management Studio – Part 1

Using SQL Sever Management Studio – Part 1 In the tutorial you will learn about Using SQL Sever Management Studio, The features of the Management Studio, Starting SQL Server Management Studio, The Object Explorer and also Default. Optional connection settings. A Database Administrator typically grapples with tasks relating to accessing, configuring and administrating the components of the SQL Server. To assist the Administrator in this task, SQL Server 2005 provides a graphical user interface called the SQL Server Management Studio. The SQL Server Management Studio combines graphical user interface with a rich script editor, so that administrators can script and…
December 15, 2005 - - Comments:

Using SQL Sever Management Studio – Part 2

Using SQL Sever Management Studio – Part 2 In this tutorial you will learn further more about Using SQL Sever Management Studio, Registered Servers, To Register a server, Server Groups, The Summary Page, The Database Engine Administration, The tasks of a Database Administrator Registered Servers Registered servers can be viewed in the Registered servers window. Servers can be created and registered, renamed or removed in the SQL Server Management Studio. Information on frequently accessed servers will be stored in the Management Studio on Registration. To Register a server Right click a node in the Registered Server’s Tree and click Update…
December 15, 2005 - - Comments:

Using the SQL Management Objects

Using the SQL Management Objects In this tutorial you will learn about Using the SQL Management Objects, Unsupported namespaces, Programming SQL Server Management objects, Setting Default Initialization Fields, Definitions, Capture mode, Linked servers and SMO methods and properties. SQL Server Management objects (SMO) exposes the functionality of SQL Server database and replication management. SMO can be used to automate repetitive tasks or commonly performed administrative tasks. The SQL SMO is implemented as a .NET assembly and the model extends and replaces the SQL Server Distributed Management object (DMO) of the earlier versions. A number of enhancements have been made such…
December 15, 2005 - - Comments:

SQL Server 2005 – Using the Sqlcmd Utility

SQL Server 2005 – Using the Sqlcmd Utility In this tutorial you will learn about SQL Server 2005 – Using the Sqlcmd Utility, Running the sqlcmd utility, Sqlcmd rules – Quoted Strings, Code Page Conversion Rules and Interactive sqlcmd Example. The interactive execution of T-SQL statements and scripts is enabled by the Win32 Command prompt utility called sqlcmd utility. This utility can be used to build scripts to be run by sqlcmd users or to interactively enter T-SQL statements into the utility in a manner that is similar to working with the command prompt window. Users can submit a sqlcmd…
December 18, 2005 - - Comments:

SQL Server 2005 Configuration Manager

SQL Server Configuration Manager In this tutorial you will learn about SQL Server Configuration Manager, Manage Server & Client Network Protocols, To start the default instance of SQL Server, To start an instance of SQL Server with startup options, To stop the default instance of SQL Server, To connect to another computer with SQL Server Configuration Manager, To connect to another computer with Windows Computer Management, To stop the default instance of SQL Server using net commands, To set an instance of SQL Server to start automatically and To start or Start the SQL Server Agent service SQL Server Computer…
December 18, 2005 - - Comments:

SQL Server 2005 – Populating the Database

SQL Server 2005 – Populating the Database In this tutorial you will learn how to populate the database in SQL Server 2005. One method of populating the tables in a database is to right click on a table and select ‘Open Table’ and entering the data in the visual mode that is displayed. Another method is to use the INSERT statement to add rows to a table. The syntax would be as under: INSERT [INTO] table_or_view [(column_list)] data_values   The SELECT subquery in the INSERT statement can also be used to add values to a table or views. The use…
December 18, 2005 - - Comments:

SQL Server 2005 – Database Backup

SQL Server 2005 – Database Backup In this tutorial you will learn how to take database backup in SQL Server 2005. The database created above can be backed up at periodic intervals using the Backup Database dialog box in SQL Server Management Studio. The file gets stored in the .abf format. To display the Backup database dialog box right click a database in the Object Explorer and select Tasks > backup. The following dialog box appears The Database is the name of the currently selected Analysis Services database. They type of recovery will have to be specified. A timestamp for…
December 20, 2005 - - Comments:

Maintain indexes in a SQL Server 2005 database

Maintain indexes in a SQL Server 2005 database In this tutorial you will learn about maintaining Indexes in a SQL Server 2005 database – Dealing with Fragmented indexes, Reorganizing an Index, Rebuilding an Index, Disabling Non-clustered Indexes to Reduce Disk Space During Rebuild Operations, Rebuilding Large Indexes, Setting Index Options, Page Splits and Performance Considerations, Max Degree of Parallelism, Online Index Operations, Partition Index Operations, Statistical Information, Asynchronous Statistics Updates, Disabling Automatic Statistics, Statistics after Upgrading a Database to SQL Server 2005, Bulk copy options and Index operation logging. The DBA has to ensure optimal performance of the database. One…
December 20, 2005 - - Comments:

SQL Server 2005 – Defining Indexes

SQL Server 2005 – Defining Indexes In this tutorial you will learn about Defining Indexes in SQL Server 2005 – clustered and non clustered indexex, The Query Optimizer, to create an index, To create a unique index, To create a clustered index, To create full-text indexes, To change index properties, To rename an index, to delete an index, To specify a fill factor for an index, To create an XML index and To delete XML Indexes. When data volumes increase, organizations are faced with problems relating to data retrieval and posting. They feel the need for a mechanism that will…
December 20, 2005 - - Comments:

SQL Server 2005 – Tuning a Database

SQL Server 2005 – Tuning a Database In this tutorial you will learn about Database Tuning Advisor overview, Database Engine Tuning Advisor Features, Improved Workload Parsing, Enhanced Scalability, Integrated Tuning, Multiple Database Tuning, Offload of Tuning Overhead to Test Server, Drop-Only Tuningm, XML Support, User-specified Configuration and "What-if" Analysis Support, Analysis Reports, Tuning Sessions, Database Engine Tuning Advisor Tuning Capabilities and Tuning SQL Server 2000 and 2005 databases with DTA. Database Tuning Advisor overview In SQL Server 2005 the Database Tuning Advisor has been introduced in place of the Index tuning wizards of the earlier SQL Server versions. It contains…
December 24, 2005 - - Comments:

SQL Server 2005 – Using the Database Tuning Advisor

SQL Server 2005 – Using the Database Tuning Advisor In this tutorial you will learn about Using the Database Tuning Advisor in SQL Server 2005, Using the DTA, Open the Database Engine Tuning Advisor GUI, Set the tool options, Hide and unhide the Session Monitor, Tune a workload Transact-SQL script file, View tuning recommendations, Starting the dta command prompt utility and viewing Help and Tuning a simple workload with the DTA command prompt utility. Using the DTA The first condition to launching the Database Tuning Advisor graphical user interface is that the user must be a member of the sysadmin…
December 24, 2005 - - Comments:

Managing SQL Server 2005 Security

Managing SQL Server 2005 Security In this tutorial you will learn about Managing SQL Server 2005 Security. Microsoft has consciously invested in the creation of a precise and flexible security model of the database platform with security features that include surface area reduction, data encryption, native encryption, authentication and granular permissions and user and schema separations. This is part of the Trustworthy Computing initiative. SQL Server 2005 Security Overview The Trustworthy Computing initiative provides a framework for secure computing. Confidentiality, integrity and availability of data and systems are the cornerstones of the software life cycle. The Trustworthy computing initiative insists…
December 24, 2005 - - Comments:

SQL Server 2005 – Managing Permissions

SQL Server 2005 – Managing Permissions In this tutorial you will learn about Managing Permissions in SQL Server 2005. Authorization features determine the level of access rights once the user’s logon process is successfully completed. A significant aspect of SQL Server 2005 authorization mode is the user-schema separation. The schema forms the namespace boundaries and no two objects residing in the schema can have the same name. The objects also have four distinct parts—ServerName, DatabaseName, SchemaName and ObjectName. Secondly all objects within the schema have the same owner. The schema can be owned by a database roles and Windows groups….
December 26, 2005 - - Comments:

SQL Server 2005 – Managing Certificates

SQL Server 2005 – Managing Certificates In this tutorial you will learn about Managing Certificates in SQL Server 2005, SQL Server 2005 makes significant improvements in two areas—Native encryption and certificates. Encryption is a mechanism that is intended to protect data using a specially designed algorithm for converting content into a format different from the original. Reversal of the process requires an appropriate decryption key and algorithm that converts the data back into its original content. The key and the algorithm required for encryption and decryption may be identical or different. The process may be symmetrical or asymmetrical. The complexity…
December 26, 2005 - - Comments:

SQL Server 2005 – Disaster Recovery

SQL Server 2005 – Disaster Recovery In this tutorial you will learn about Disaster Recovery in SQL Server 2005, Recovery Models, Managing Backup Media, Running a Base-Functionality Script and Ensuring Disaster Readiness. Disaster Recovery in SQL Server 2005 Most enterprises have mission critical data which is the very backbone of the business. The loss of such data would be disastrous to the business and may even result in closure. In such circumstances it is not surprising that organizations are very concerned about Disaster Recovery procedures. SQL Server 2005 provisions for just such a scenario by helping the DBA create a…
December 26, 2005 - - Comments:

SQL Server 2005 – Using Database Snapshots

SQL Server 2005 – Using Database Snapshots In this tutorial you will learn about Using Database Snapshots in SQL Server 2005, Effect of the Update Pattern on Database Snapshot Growth, Metadata About Database Snapshots, Limitations on the Source Database, Limitations on Database Snapshots, Database Snapshots with Offline Filegroups and Best Practices for Creating Database Snapshots. Snapshots are read only static views of the database. This is a new feature introduced into SQL Server 2005 Enterprise edition to enable DBAs report on the database or revert to the source database if required so that data loss is confined to the point…
December 26, 2005 - - Comments:

Effective Software Testing

Effective Software Testing In this tutorial you will learn about Effective Software Testing? How do we measure ‘Effectiveness’ of Software Testing? Steps to Effective Software Testing, Coverage and Test Planning and Process. A 1994 study in US revealed that only about “9% of software projects were successful” A large number of projects upon completion do not have all the promised features or they do not meet all the requirements that were defined when the project was kicked off. It is an understatement to say that – An increasing number of businesses depend on the software for their day-to-day businesses. Billions…
January 1, 2006 - - Comments:

SQL Server 2005 – Backing up a Database

SQL Server 2005 – Backing up a Database In this tutorial you will learn about Backing up a Database in SQL Server 2005 – Backup and Restore operations, Restoring System Databases, Media Reliability, Using Checksums during backup and Restore and Backup Media mirroring. Backup and Restore operations. A backup is a copy of the data that is maintained for the purpose of restoration at a later date if a requirement arises due system failure. Failures can occur due to media problems, user errors, hardware failures or natural disasters. Backup of data are also useful for copying data from one server…
January 1, 2006 - - Comments:

SQL Server 2005 – Introduction to Data Availability

SQL Server 2005 – Introduction to Data Availability In this tutorial you will learn about Data Availability in SQL Server 2005 – Failover clustering, Database mirroring, Log shipping, Replication, Introduction to Database Mirroring and advantages of mirroring. SQL Server 2005 introduces several high availability solutions to improve the availability of servers and databases. These solutions mask the effect of hardware or software failure and maintain the availability of applications so that users perceive a minimum of downtime. The options for creating high availability for a server or a database include: Failover clustering The failover cluster is a combination of one…
January 1, 2006 - - Comments:

Unit Testing: Why? What? & How?

Unit Testing: Why? What? & How? In this tutorial you will learn about unit testing, various levels of testing, various types of testing based upon the intent of testing, How does Unit Testing fit into the Software Development Life Cycle? Unit Testing Tasks and Steps, What is a Unit Test Plan? What is a Test Case? and Test Case Sample, Steps to Effective Unit Testing. There are various levels of testing: Unit Testing Integration Testing System Testing There are various types of testing based upon the intent of testing such as: Acceptance Testing Performance Testing Load Testing Regression Testing Based…
January 8, 2006 - - Comments:

SQL Server 2005 – Mirror Server

SQL Server 2005 – Mirror Server In this tutorial you will learn about Mirror Server in SQL Server 2005 – Preparing the Principal and Mirror Server, Establishing a Mirroring Session, Establishing a Witness Server, Executing Transactions, Simulating Principal Server Failure, Restarting the Failed Server, Terminating the Mirror Session and Configuring Database Mirroring. Preparing the Principal and Mirror Server Database mirroring is easy to set up and can be made self monitoring for automatic failover in the event of the principal server being unavailable. The first step is to configure the relationship between the principal server and the mirror server. This…
January 11, 2006 - - Comments:

SQL Server 2005 Replication Enhancements

SQL Server 2005 Replication Enhancements In this tutorial you will learn about Overview of Replication Enhancements, User Interface Enhancements, Merge replication concurrency Enhancements, Programming changes, The Replication Monitor, Performance and Scalability Features, Pre-computed partitions, Updates to unique keys, Transactional parallelism, Download and upload only articles, Reduced contention and Managing replication. Overview of Replication Enhancements The most striking aspects of the enhancements made to SQL Server 2005 replication services are that configuration wizards have been made simpler and shorter and performance and scalability have been improved. User Interface Enhancements The first of these is the wizard enhancements. These have been redesigned…
January 11, 2006 - - Comments:

SQL Server 2005 – Configuring Replication

SQL Server 2005 – Configuring Replication In this tutorial you will learn about SQL Server 2005 – Configuring Replication – New Types of Replication, Peer to Peer Transactional Replication, HTTP Replication, Configuring Replication Configuring Replication Using RMO, Referencing the RMO and SMO libraries and Creating a Subscription Using RMO. New Types of Replication New types of replications have been introduced in SQL Server 2005. The first of these is the Heterogeneous Replication which allows the publication of data from heterogeneous subscribers such as Oracle, DB2 using relevant ODBC drive and OLE DB provider. In SQL Server 2005 allows configuration of…
January 11, 2006 - - Comments:

Integration Testing: Why? What? & How?

Integration Testing: Why? What? & How? Introduction: As we covered in various articles in the Testing series there are various levels of testing: Unit Testing, Integration Testing, System Testing Each level of testing builds on the previous level. “Unit testing” focuses on testing a unit of the code. “Integration testing” is the next level of testing. This ‘level of testing’ focuses on testing the integration of “units of code” or components. How does Integration Testing fit into the Software Development Life Cycle? Even if a software component is successfully unit tested, in an enterprise n-tier distributed application it is of…
January 22, 2006 - - Comments:

What is Regression Testing?

What is Regression Testing? Introduction: This article attempts to take a close look at the process and techniques in Regression Testing. What is Regression Testing? If a piece of Software is modified for any reason testing needs to be done to ensure that it works as specified and that it has not negatively impacted any functionality that it offered previously. This is known as Regression Testing. Regression Testing attempts to verify: – That the application works as specified even after the changes/additions/modification were made to it – The original functionality continues to work as specified even after changes/additions/modification to the…
January 22, 2006 - - Comments:

System Testing: Why? What? & How?

System Testing: Why? What? & How? Introduction: ‘Unit testing’ focuses on testing each unit of the code. ‘Integration testing’ focuses on testing the integration of “units of code” or components. Each level of testing builds on the previous level. ‘System Testing’ is the next level of testing. It focuses on testing the system as a whole. This article attempts to take a close look at the System Testing Process and analyze: Why System Testing is done? What are the necessary steps to perform System Testing? How to make it successful? How does System Testing fit into the Software Development Life…
January 22, 2006 - - Comments:

Exforsys e-Newsletter

ebook
 
© 2024. All Rights Reserved.IT Training and Consulting