While SQL Server often gets the blame for poor performance, more often than not, it is the application that is really causing the problem. And this is also true for ASP.NET applications that use SQL Server as its back-end database. While this website has a little coverage on how to performance tune
Other News
Retrieving XML data
Using the XML Extender , you can retrieve either an entire document or the contents of elements and attributes. When you retrieve an XML column directly, the XML Extender returns the UDT as the column type.
CAST and CONVERT
Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality.
DB2 V8 Application Development cert prep, Part 4 of 7: ODBC/CLI programming
(Roger Sanders) This tutorial introduces you to CLI/ODBC programming and walks you through the basic steps used to construct a CLI/ODBC application. It also introduces you to the process to convert one or more high-level programming language source code files containing CLI/ODBC function calls into
Building ASP.NET Web Applications
(Rob Howard) Use Visual Studio “Whidbey” to build ASP.NET Web applications. It combines simplified Web data access, rich site layout features, dynamic Web projects, and an array of additional features that enable rapid construction of dynamic Web applications. Watch this video to learn about enhance
FIX: SQL Server 2000 may not start if many users try to log in to SQL Server when SQL Server is trying to start
If many users try to log in when SQL Server 2000 is trying to start, SQL Server 2000 may not start. You may also see error messages that are similar to the following in the SQL Server error log: 2003-12-16 13:58:01.11 spid5 Clearing tempdb database. 2003-12-16 13:58:01.11 spid5 Could not creat
Microsoft Tech·Ed 2004
Don’t miss Microsoft’s most comprehensive technical event for IT professionals and developers! Tech·Ed 2004 provides a unique opportunity to participate in customized educational programs, get hands-on training from industry and Microsoft experts, and preview the newest technology. Throw in the spec
Cut Your Migration Time from Oracle to DB2 UDB for iSeries
(Jarek Miszczyk) The free href=”http://www-919.ibm.com/servers/eserver/iseries/developer/db2/oraclemtk.html”>IBM DB2 Migration Toolkit for iSeries (MTK) can significantly reduce the effort required to migrate an Oracle database solution to the iSeries and thus shorten the time to market for your app
Use Delphi 8 visual controls that bind to DB2 data tables
(Bob Swart) This article uses Delphi 8 for .NET and the data-aware controls from the Visual Component Library to bind to DB2 UDB tables.
The hidden impact of WS-Addressing on SOAP
(Doug Davis) The WS-Addressing protocol might not seem like much at first glance. But it establishes message information headers that will make new Web services message flow patterns possible — and that’s something that will have a profound impact on SOAP engines and the future of the SOAP protocol