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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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,… Read More

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… Read More

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… Read More

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… Read More

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,… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

.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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

. 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… Read More

.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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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:… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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,… Read More

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… Read More

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… Read More

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… Read More

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… Read More

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… Read More

Displaying Master-Detail Data on Separate Pages in ASP.NET

Displaying Master-Detail Data on Separate Pages In this tutorial you will learn how to display Master-Detail Data on Separate Pages, create the details page, test the pages and Allow Editing, Deleting, and Inserting Using a DetailsView DataBound control. A variation of the GridView and DetailsView control is the display on separate pages. Each record has an hyperlink which enables them to navigate to a second page where they can view the detail records in a DetailsView control 1. Add a new page to the Web site and name it MasterCourses.aspx.… Read More

ASP.NET Displaying Master-Detail Data on the Same Page

ASP.NET : Displaying Master-Detail Data on the Same Page In this tutorial you will learn how to display Master-Detail Data on the same page, To display the master records, To configure a query to display related records and To test the page Data from related tables can be displayed on one page. The master table data is displayed in a grid and users can select individual rows. When they select a row, one or more details of records are displayed I a scrollable control elsewhere on the page. We shall… Read More

SQL Server Architecture and Components

Business Intelligence Development Studio This solution oriented interface is intended for creating Business intelligence services, integrating projects involving Analysis Services, Reporting services and Data Transformation Services. It is similar to SQL Server Management Studio and provides integration with Visual SourceSafe. SQL Server Integration Services This is a revamped version of the SQL Server 2000 based Data Transformation Services. The improvements have been made in the performance, usability and manageability aspects of the tool. It contains a Business Intelligence Workbench and SQL server Workbench which enables extracting data for the data… Read More

ASP.NET DataBound Controls – Details View

ASP.NET : DataBound Controls – Details View In this tutorial you will learn DetailView DataBound Control, To create a file system Web site, Connecting to SQL Server, Use a Drop-Down List as the Master and To test the drop-down list. The DetailsView is a control that is complementary to the GridView control. It has been introduced in ASP.NET 2.0 to provide an ability to work with a single record or row from an associated data source. The default view of this control is vertical with each column of the record… Read More

ASP.NET Using a Grid to Display Detail Information

ASP.NET Using a Grid to Display Detail Information In this tutorial you will learn how to use a GridView Control to display the details of the item selected in the DropDown list and test the page. We shall now use a GridView to display the details of the item selected in the DropDown list. 1. Switch to or open the Default.aspx page (or the page you have been working with), and switch to Design view. 2. From the Data group of the Toolbox, drag a GridView control onto the page.… Read More

ASP.NET Adding Sorting and Paging in GridView

Adding Sorting and Paging in GridView In this tutorial you will learn adding sorting and paging in a GridView Control, Implement Two Column Sorting, Create Code for Custom Sorting, Editing the GridView control data, Deleting Displayed Records, Inserting Records and Using Templates. Adding Sorting and Paging Sorting and paging can be added to the GridView control without writing any code. 1. In Design view, right-click the GridView control, and then click Show Smart Tag. 2. On the GridView Tasks menu, select the Enable Sorting box. 3. The column headings in… Read More

ASP.NET GridView Filtering

ASP.NET GridView Filtering In this tutorial you will learn how to add a filter to a Grid View Control, To modify the query with a parameterized filter, the WHERE Clause, Parameter properties, Parameter Value Editor and To test filtering. Adding Filtering If the developer wants to display only selected data in a page, the query for the SqlDataSource control will have to be modified. The first step in this process is to add a Textbox control where the users can enter the filter condition. The filter condition then becomes the… Read More

ASP.NET GridView Control

ASP.NET GridView Control In this tutorial you will learn about GridView Control, features of the GridView control, GridView supported field types and Creating a GridView control on a Page. The GridView control is the official successor to the DataGrid control of yesteryears. It is no longer listed in the toolbox, even though it is supported by ASP.NET 2.0. All new projects would automatically use the GridView control. Though both these controls have a similar look and feel they are implemented differently as already explained in the earlier section of this… Read More

SQL Server 2005 Management Studio

SQL Server Management Studio SQL Server Architecture and Components What strikes the developer is the absence of the SQL Enterprise Manager in the interface. The SQL Server Management Studio offers functionality enhancements and a new look and feel to the application. It has been implemented using Winforms and .NET framework and is completely different from the Microsoft management console and looks more like the Visual studio Interactive development Environment(IDE). The design allows administration and programming features through the same interface focusing upon consistency of experience. A significant improvement is the… Read More

Overview of SQL Server 2005 for the Database Developer

SQL Server 2005 Developer tools The driving force behind Micorsoft SQL Servr 2005 is the process of integration. With MSSQL 2005 the database developer experiences a paradigm shift. He can now locate his code with refrence to its functionality, he can access data in its native formats or build complex systems that are server driven. The integration with the .NET framework gives him the power of the class library and modern programming languages to implement functionalities within the server. The common language runtime(CLR) helps code procedures, functions and triggers in… Read More

ASP.NET Data Bound Controls

ASP.NET Data Bound Controls In this tutorial you will learn about Data Bound Controls – The Hierarchy of Data Bound Controls, Simple Data Bound Controls, Composite DataBound Controls and Hierarchical Data Bound Controls. The Hierarchy of Data Bound Controls Data Bound controls are controls that are bound to data sources. Traditionally the DataGrid is the principal data bound control in ASP.NET 1.x. Though DataGrid is still supported, ASP.NET 2.0 introduces three new controls—GridView, FormView and DetailsView. Unlike in ASP.NET 1.x, all controls descend from the BaseDataBoundControl class. It has two… Read More

ASP.NET SqlDataSource Control

SqlDataSource Control In this tutorial you will learn about The Data Source Wizard – SqlDataSource Control, the process of setting up the data source. The Data Source Wizard DataSource controls enable programmers to declaratively connect data sources to the user interface. The logic for retrieving the data from the source is inbuilt into the control. For instance when a DropDownList is added to the form the developer is prompted to connect to the DataSource. On Clicking ‘connect to DataSource’, the wizard is started to guide the user through the process… Read More

ASP.NET Data Source Object Model

ASP.NET Data Source Object Model In this tutorial you will learn about Data Source Object Model in ASP.NET 2.0, the Rationale of DataSource components, Data Source Control Internals, Tabular DataSource Controls, Hierarchical Data Source Controls, The SqlDataSource Control: Usage and Data Source Parameters. The Rationale of DataSource components The ASP.NET 2.0 data source model provides support for a declarative model of data binding. The data source components return and accept data from familiar streams such as SQL, XML, DataSet and from custom formats too. The schema is very approachable, time… Read More

Forms Authentication in ASP.NET

ASP.NET Forms Authentication In this tutorial you will learn about Forms Authentication in ASP.NET 2.0 – Forms Authentication class, Cookie Domain, Forms Cookies, The Login Control, Signin, Signout, Authenticate, Redirect, Login Status, Login Name and Login View Controls. Forms authentication has been made easier with a supply of readymade tools for repetitive tasks. ASP.NET 2.0 encapsulates all the best practices and provides built in solutions to virtually all the tasks relating to user databases, roles cached in cookies, controls for capturing user name and passwords, and administration tools for managing… Read More