February 2006 Entries
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...
ASP.NET 2.0 Free Training : Web Pages and Layout In this tutorial you will learn how to Enable Users to Edit Pages and Change Layout, To create a user control that enables changing page layout, To enable users to change the layout and To test layout changes. Enabling Users to Edit Pages and Change Layout As stated earlier in this tutorial, Web parts facilitates the editing of Layout by users. Users can drag and drop controls by dragging them from one zone to another and the characteristics of controls...
SQL Server 2005 - Server Groups In this tutorial you will learn about Server Groups. As stated earlier, servers can be grouped together. Each group can be assigned a name. The name of the server group can also be changed by right clicking on the group name, pointing to edit and selecting Server Group properties. The name can be changed in the dialog box that opens. 1. Server Groups can be created by right clicking the server type in the Registered servers toolbar. 2. Right click on a server or a...
ASP.NET 2.0 Tutorials : Using Web Parts and Controls in Web Pages In this tutorial you will learn how To create a page for containing Web Parts controls, To create content for the main zone and To create a user control. In the preceding section we examined the concepts of Web Parts and the features of the controls that have been provided by ASP.NET 2.0 for rapidly creating web portals that are elegant and well laid out. We also theoretically appreciated the immense potential of allowing users to...
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...
ASP.NET 2.0 Tutorials : Adding Web Parts at Run Time In this tutorial you will learn how to add Web Parts at run time and To test the Web Parts catalog. To allow users to add Web Parts at run time 1. Open the Start.aspx page, and switch to Design view. 2. From the WebParts tab of the Toolbox, drag a CatalogZone control into the right column of the table, beneath the EditorZone control. 3. Both controls can be in the same table cell because they will not be displayed at the same time. 4. In the Properties...
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...
ASP.NET 2.0 Training : Working with Web Parts In this tutorial you will learn about Understanding Web Parts, Building pages with Web Parts, Web Part Display Modes, Advantages of using WebParts, To create a new Web site using WebParts, The Web.config File and Adding the WebPartManager Control. Understanding Web Parts Websites and portals show a large amount of content and content personalization has assumed importance over the years. Users accessing content rich websites experience a desire to see...
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...
ASP.NET 2.0 Free Tutorials : Creating Nested Master Pages In this tutorial you will learn how master pages can be nested within one main master page, build and example nested master page with the help of sample code. In the preceding sections we had seen how to create simple master and content pages. We also examined how we can reference members of a master page from content pages and how to use different masters with a single content page. In this section we shall see how master pages can be nested...
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...
ASP.NET 2.0 Free Training : Changing Master Pages Dynamically In this tutorial you will learn how to make a copy of the master page, To add buttons for selecting an alternate master page, To write code to dynamically select the master page and test the dynamic master pages. Changing Master Pages Dynamically Dynamically changing master pages is possible. The code can be used to set the master for the content. This may especially be useful when users want to select from several different layouts to...
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...
ASP.NET 2.0 Training : Working With Master Pages In this Tutorial you will learn how to work with Master Pages, create a file system on website, create a Master Page, create layout table for the Master Page, To add static content to the master page and add a content placeholder. Creating a Simple Master Page As pointed out in the preceding section “Working with Master Pages”, Master pages can be simple or complex. We shall start by creating a simple master page and then go on to understanding the...
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...