(Scott Hayes) The Catalog Cache is like a special memory bufferpool dedicated to catalog objects; it stores information about tables, indexes, views, and other objects to speed up the BIND process for dynamic and static SQL. It CAN be changed online dynamically, but it DOES NOT participate in DB2 9
Other News
Distribute Your Sites Content With RSS 2.0 Using ASP.NET/VB.NET/MS SQL 2005
(AdamNThompson) This is an easy way to distribute your sites content using RSS 2.0. The code pulls the items from a MS SQL database and dynmaicly creates the XML using the XmlTextWriter Object. You can filter the resuling items by create date with your T-SQL, or use the time to live.
SQL Access Advisor
(Arup Nanda) Oracle Database 10g offers an avalanche of helpers—or “advisors”—which help you decide the best course of action. One example is SQL Tuning Advisor, which provides recommendations on query tuning, lengthening the overall optimization process a bit in the process.
.NET Tip: Type Casting and Comparison Using ‘as’ and ‘is’
(Jay Miller) You are probably used to using C-style casts. Look at an example starting with C-style casts and see how using “as” and “is” can help your code. A common situation I run into is working with controls in an ASP.NET DataGrid.
Importing a TextFile into a Database using a Dataset
(Mark Dryden) This question comes up a bit on the forums (twice today already) where the user wants to import data from one Datasource (such as a TextFile) into a database (SQL Server / Access / Whatever). Now in the case of SQL Server my natural reaction would be to suggest DTS for SQL 2000 or chec
Serve SQL Data in XML Format
(Ivan Pepelnjak) If you’re developing AJAX applications, you might decide to use XML as the encoding method to transport application data between the web server and the browser—not surprisingly, as XML is the technology that contributed the X in AJAX. Quite often, the data you have to serve to the c
Adding a Setup Wizard to VB.NET applications
(Irina Medvinskaya) Visual Studio .NET simplifies the process of installing your applications by providing an easy way to add a Setup Wizard to your applications. In this tip, I will create a simple VB.NET Windows application and add a Setup Wizard to it in order to allow the Windows application to
Build a resilient SOA infrastructure, Part 1: Why blocking application server threads can lead to a brittle SOA
(Snehal Antani and Robert G. Alderman) Resiliency —defined as the continued availability and performance of a service despite negative changes in its environment—is vital in a Service-Oriented Architecture (SOA). An SOA infrastructure must ensure that a service is highly available regardless of unpr
Top Ten Things to do before installing MySQL
(George J. Trujillo Jr.) I think it is very important that DBAs (especially new ones) do sufficient planning, physical design, risk analysis and backup/recovery planning before installing MySQL. MySQL is an easy database to install and configure on a wide range of platforms.
Inserting and Deleting Data with Parameters in ASP.NET
(Michael Youssef) In the first part of this article we saw how to display data, retrieved from a database table, on a web page. We also saw how to perform update operations, using the T-SQL UPDATE statement along with the SqlCommand and SqlParameter objects, if the user has changed the data on the w