By J. D. Meier – Using SQL and ADO to provide data for your Web application can seem daunting, but these ten tips can noticeably improve your results.
Author: SSWUG Research
Keep your SQL Server database free from design flaws with SSW SQL Auditor.
Maintaining quality code across a large team is difficult. Even when standards are in place developers can make mistakes that will slip through QA. SSW SQL Auditor, built in VB .NET, allows a developer to set SQL Server design rules and then check the database for code or design elements that ignore
SQL Server Quantitative Performance Analysis
by Joe Chang – SQL Server employs a set of formulas to assess the cost of an execution plan for a query based on the type of operations involved, and the number of rows and pages involved. By examining the SQL Server execution plan cost formulas, we can understand why a specific execution plan is ch
Interpreting Wait Events to Boost System Performance
By Roger Schrag – People seem to have an insatiable appetite for speed. No matter how fast an application runs, users always seem to want it to run faster. Since everybody looks to the database administrator when system performance or scalability is in question, it’s no wonder DBAs are always lookin
RELAX NG’s Compact Syntax
by Michael Fitzgerald – Working with XML Schema is like driving a limousine. It’s true that it has some nice appointments (datatypes come to mind), but the wheelbase is a bit on the long side, making it difficult to turn corners easily, and I am inclined to let somebody else do the driving for me. U
C++ XML Toolkit
The C++ XML Toolkit is a C++ class library providing a rich set of features that facilitate the integration of XML into your applications.At its heart, the C++ XML Toolkit contains a high-performance validating XML parser with an event-based SAX 2.0 interface. It is supplied as an extension
Web services: Ready, set, wait
By Larry Dignan – Web services may someday emerge as a standard piece of every big company’s technology arsenal, but for now, they won’t do much to revive tech spending.
The IETF, Best Practices and XML Schemas
by Leigh Dodds – In this week’s XML-Deviant column, I examine an XML best practice guide under development by the IETF, as well as the XML Schema language debate which it has reignited.
Conduct Web Services With BizTalk
Microsoft’s general manager for e-business servers and BizTalk Server’s lead product manager talked with XML & Web Services Magazine about orchestrating business processes for Web services and BizTalk Server’s strategy in that arena.
New bugs swarm Windows
By Robert Lemos – The software giant dubbed “critical” a buffer overflow in its remote access service (RAS) software, which is a native service in Windows NT 4.0, Windows 2000 and Windows XP. The security hole could allow an attacker to run any code, the advisory stated. Another release detai