Learn everything you ever wanted to about Microsoft SQL Server 2000 Profiler and SQL Trace Architecture. This Support WebCast will talk about using stored procedures to trace, Replay facility, Index Tuning Wizard, scenarios, known issues, and will provide handy tips and tricks. Tuesday, November 14,
Author: SSWUG Research
SOAP::Lite v.41 released
Paul Kulchenko has released version 0.41 of his popular Perl SOAP library, SOAP::Lite, fixing bugs and adding new features including proxy authorization and tracing.
Representing the XML Schema as a DTD
The following is an example of representing the XML schema with a DTD. The representation is not exact, however; and there are a number of problems:
Beyond ASP: XML and XSL-based Solutions Simplify Your Data Presentation Layer
The combination of XML and XSL can provide a powerful alternative to ASP development. This article presents arguments for building even small-scale Internet applications on the XML model. An example written with traditional ASP programming is compared to the same example written with XML and XSL in
Controlling the Display of System Objects in SQL Server Enterprise Manager
By default, SQL Server Enterprise Manager displays all of the system databases, tables, and other database objects in its console tree and details pane. If you don't want to see these system objects, you can turn off their display by editing your server's registration properties.
TSQL, SQL, database design, data warehousing, replication, and OLAP
One of the projects I began years ago was to design a course that would teach TSQL, SQL, database design, data warehousing, replication, and OLAP. This section is the fruits of that labor. One of the greatest benefits you get from instructor led training is the instructor. Since I obviously can&#
What's New in the Microsoft XML Parser Version 3.0 Release
The Microsoft® XML Parser (MSXML) 3.0 Release is the long-awaited production release of MSXML 3.0. This release represents a huge step beyond the MSXML 2.5 Release that shipped with Microsoft Windows® 2000. This release provides:
XML Bridge for SAP
IBM's alphaWorks has released XML Bridge for SAP, software to provide XML integration between SAP R/3 systems on the one side and arbitrary SAP R/3 or non-SAP systems on the other side. The software is aimed at those who want to provide loose coupling between SAP R/3 and outside systems, want
XML Schemas and the DOM
When you use XML Schema, the XML DOM provides a property on each element and attribute to quickly access its definition in the schema. The definition property on the XMLDOMNode object returns the corresponding ElementType or AttributeType from the schema document. Recall that because an XML schema d
Use the Index Tuning Wizard in SQL Server
One of the handy tools included in SQL Server 7.0 is its Index Tuning Wizard. You can use this wizard to analyze both your existing database as well as sample queries–and then make recommendations as to any indexes you should create to speed up those queries.