March 2006 Entries
ASP.NET 2.0 Free Tutorials : 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...
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...
ASP.NET 2.0 Training : 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...
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,...
Forms Authentication in ASP.NET 2.0 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...
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...
ASP.NET 2.0 Training : ASP.NET Security In this tutorial you will learn about ASP.NET 2.0 Security, The Security Architecture of ASP.NET 2.0, The security infrastructure and subsystem relationships of the ASP.NET and the sequence of events that occur when a authentication is sought. When we talk of ‘security’ we are basically acknowledging that there is a possibility of ‘vulnerability’. The developer and the Administrator need to focus on various threats and mitigation techniques and security concepts...
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...
ASP.NET 2.0 : Setting Application-Level Caching In this tutorial you will learn how to set application-level caching in ASP.NET 2.0. To Configure and Use Parameter-Level Caching and also the steps involved to cache based on parameters. Setting Application-Level Caching To configure application-level caching 1. In Solution Explorer, select the node representing your Web site. 2. Right-click, and then click Add New Item. 3. In the Add Item dialog box, click Web Configuration File, and then click Add....
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...
ASP.NET 2.0 Tutorials : Configuring Page-Level Caching In this tutorial you will learn how to configure Page-Level Caching. Page directive and Duration attribute. Configuring Page-Level Caching 1. In Visual Web Developer, switch to Design view. 2. Drag a Label control to your page, leaving the default name of Label1. 3. Switch to Design view. 4. Double-click the surface. 5. A stubbed out method will be created for you named Page_Load. 6. Add the following highlighted code to the method: void Page_Load(Object...
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...
ASP.NET 2.0 Free Tutorials : State Management And Caching in ASP.NET 2.0 In this tutorial you will learn about Cache Dependency, SqlCache Dependency, New methods added to the CacheDependency Class and The process of writing the cache dependency file. The performance of any web application is incumbent upon the amount of server side processing that is required. Web servers must handle individual requests or multiple requests, give quick response time and reduce the load on intermediate and backend...
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...
ASP.NET 2.0 Training : Customizing the Session State Mechanism In this tutorial you will learn about Extending the Session State Mechanism, The Default Session State Mechanism and its customization, Customizing the Session State Module and Writing a custom session state module Extending the Session State Mechanism The stateless HTTP protocol treats each page request independently and the server is unaware of the variable values of the earlier request. The session state is a dictionary based API that...
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...
ASP.NET 2.0 Free Tutorials : State Management in ASP.NET 2.0 In this tutorial you will learn about new features included in ASP.NET 2.0 for State Management. The Control State, differences in handling View State and Control State, Implementing the control state. Initialization and loading of a controls private state. Web pages are constantly constructed and destroyed with round trips to the server. However, state maintenance is an essential aspect of deploying web pages on a stateless protocol such...
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...
ASP.NET 2.0 Tutorials : New features in Data Access In this tutorial you will learn about new features in Data Access, Data binding, The XPathBinder, XPathBinder.Eval, Connection Strings, The factory class, Batch operations, Asynchronous Commands, SQL Bulk Copy, ColumnMappings, Enhancements to SQL Server 2005, ADO.NET Class Enhancements, DataTableReader, Serializing a DataTable, The XMLSerializer, RemotingFormat and Managing Views of Data. ASP.NET 2.0 performs a kind of magic. It pushes ADO.NET objects...
SQL Server 2005 Architecture Overview Overview of SQL Server 2005 Architecture 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...
ASP.NET 2.0 Free Training : Personalization: User Profiles and Themes In this tutorial you will learn about Personalization - User Profiles and Themes, Inbuilt providers in ASP.NET 2.0 and also Create and execute a Shopping cart application with Personalization features. Surfers would love to see on the website the content which is customized to their needs. ASP.NET offers a personalization feature which enables users to do just that. Personalization is a storage system that manages all the data...