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