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