(Scott Guthrie) This week my team released updates of the ASP.NET AJAX Control Toolkit as well as the Visual Studio Web Deployment project packager. Both of these updates are designed to work with VS 2008 and .NET 3.5.
Other News
Simplify Your Code with Reflection
(Paul D. Sheriff) Some programming issues are universal. For example, every developer must deal with the question of whether a user has changed any values on a given form, for the purpose of determining whether the data must be saved back to the database. There’s no point saving data back if it hasn
TechTip: Debugging Multi-Result Set DB2 Stored Procedures
(Michael Sansoterra) Stored procedures are great tools for easily delivering the results of one or more queries (aka result sets) to a client/server or Web application. (For a brief outline of this technique from the client side, see “Retrieve Multiple Result Sets from a Stored Procedure.”) However,
.NET Tip: Display All Fields and Properties of an Object
(Jay Miller) I’m a huge fan of the visualizers that Visual Studio provides. They provide a wealth of information in a way that does not get in the way and are an invaluable asset when debugging. There are times, however, when looking at objects during an interactive debugging session isn’t appropria
How About Some Respect for DB2 Connect?
(Robert Catterall) Poor DB2 Connect. It’s a good piece of code. It really is. It gets SQL requests from off-mainframe requesters (PCs, for example, as well as Linux, UNIX, and Windows-based application servers) to DB2 for z/OS using DB2’s Distributed Relational Database Architecture protocol (aka DR
Understanding the advantages of DB2 9 autonomic computing features
(Mohankumar Saraswatipura and Swetha Prasad) The self tuning memory manager (STMM) is a revolutionary memory tuning feature that was first introduced in IBM DB2 9. The STMM eases the task of memory configuration by automatically setting optimal values for most memory configuration parameters, includ
Replication Best Practices for Oracle 10g with ASM and EVA 8000
This whitepaper provides a comprehensive set of test-proven best practices to properly configure, deploy, and operate an Oracle 10g database using Oracle’s Automatic Storage Manager (ASM) on an HP Enterprise Virtual Array using Continuous Access as the remote copy infrastructure. Read this paper to
Saving Time by Reusing Storage
(Steve Callan) One of the basic facts or concepts that virtually all DBAs know is that truncating a table to remove data is faster than deleting the same data. But beyond that truism, there are subtle differences that when taken into account, can help improve the overall performance of a job or proc
MySQL: How do I dump all tables in a database into separate files?
(CrazyToon) There have been numerous occasions where I needed to make backups of individual tables from selected database.
Dynamic Performance Views………
(Ayyappa Yelburgi) V$DB_OBJECT_CACHE This view provides object level statistics for objects in the library cache (shared pool). This view provides more details than V$LIBRARYCACHE and is useful for finding active objects in the shared pool.