ESQL Profiler SQL Query Analyzer

The SQL Profiler tool can be used to determine which T SQL statements are taking a long time to run. Profiler is a powerful tool, capturing a multitude of events and filtering out unwanted data. It should primarily be run on a test system during load testing. However, depending on the loads experienced in production, we might choose to run Profiler on a limited basis on production SQL Server boxes to obtain more accurate performance metrics. Profiler, displayed in Figure 15.20, captures SQL...

DDeploying NET Applications on Application Center 2000 Clusters

Application Center 2000 automatically propagates changes made to Web applications on the cluster controller to the other members of the cluster. In the traditional Windows DNA setting, any discussion of Application Center 2000 would by necessity involve most of the features and attributes of Application Center 2000 applications, which are simply collections of IIS virtual directories and associated local resources which are to be replicated across different machines. This is because the...

DXML and HTML

As shown above, XML is used to describe the content of data. Contrast this to HTML, Hypertext Markup Language, which details how to display data in a web browser. Using HTML, we can tell a browser to display data using a particular font type and size, or act as a hyperlink for site navigation. Using XML together with HTML, we can extend the value of business data by separating content from presentation. This allows a single set of data to be reused in multiple presentations and a single...

End Bulleted Listing

Take for example the common scenario of expense reimbursement. When an employee spends his own money for company purposes, he is entitle to be reimbursed for those expenses. To do so, the employee must complete an expense report indicating the amount spent and the purpose for the expenditure. An employee is able to submit his expense reports through an application. A clerk in the accounting department receives the expense report and is only allowed to approve expenses up to a certain amount....

DFunctions in Transact SQL

Transact SQL functions are built-in or user-defined code modules that let us manipulate data, perform computations and comparisons, and retrieve other system information. With SQL Server 2000 user-defined functions are also supported. Functions can be deterministic and non-deterministic. Deterministic functions return the same result with the same set of input values, regardless of when they are executed. Built-in functions that are always deterministic include ISNULL, CEILING, FLOOR, and...

ENesting a Second User Control

Now that we have built the categories user control, we can test it by adding it to our Home.aspx page. This is accomplished using the following code lt Register TagPrefix gasTIX TagName Categories src Categories.ascx gt Set the Home web form to be the start up form by right-clicking it in the Solution Explorer and choosing Set As Start Page. If you now run the application, you will see the four gasTlX event categories listed horizontally across the page. As previously mentioned, there are...

EUsingthe Data List Control

The purpose of the Categories user control is to display a list of gasTIX categories such as Music, Sports, etc. Under each category heading there will be a list of subcategories, such as Rock, Country, and Celtic under the Music category. In order to display this data, we will use a DataList control, since it allows us to easily create a table layout without having to worry about the details. We will instantiate the Category business object in order to retrieve a list of categories from the...

Begin About the Author page cAbout the Authors

Sullivan is a global .NET application development company focused on delivering Microsoft .NET solutions to middle market and Fortune 1000 companies. G. A. Sullivan was among the first in the world to become a Microsoft Gold Certified Partner for ECommerce Solutions and currently has five locations that have earned this designation. Since 1982, the company has partnered with clients to streamline business processes and implement leading-edge technologies through complete strategic,...

CSOAP and Web Services

The Simple Object Access Protocol SOAP and Web Services play a major role in the Microsoft .NET Enterprise Solutions platform. A Web Service is a piece of application code made available over the Web via standard Internet protocols such as HTTP and TCP IP. SOAP is a lightweight protocol that travels on top of HTTP. It provides the information transport layer for application communication via Web Services. Software engineers developing solutions that target the Microsoft .NET Enterprise...

DDebugging and Testing a Web Service

Testing and debugging Web Services created with Visual Studio.NET is similar to any other application. Visual Studio aids in the process by creating a test page for your web service. From the Debug menu, when you select Start, Visual Studio launches a new instance of Internet Explorer and the test page is dynamically generated. The gasTIX Participant Web Service test page is shown in Figure 14.10. Participant Web Service - Microsoft Internet Explorer Back ' 1 ' Hl ffl T Personal Bar g Search...