(Willie Favero) Are you looking for ways to help reduce your CPU overhead while in DB2 V8 compatibility mode (CM)? One easy method available to you in CM is the long-term page fix option for the DB2 buffer pools. When a page is brought into storage, DB2 will fix and release the page for I/O processi
Author: SSWUG Research
Introduction to Database Refactoring
(Scott W. Ambler) A database refactoring is a small change to a database schema which improves its design without changing, at a practical level, the semantics of the database. In other words, it is a simple database transformation which neither adds nor breaks anything. The process of database re
Control data caching in .NET with the Caching API
(Tony Patton) Caching frequently accessed or expensive data in memory boosts application performance by reducing the number of database calls to retrieve the data. ASP.NET provides two basic caching techniques: page (Page Output and Page Fragment) and programmatic caching. In my previous article, I
VSTS and testing today part 2
(George Lawton) Testing tools have long been disparate, and often far removed from development processes. Bringing better integration to test and development is one of Visual Studio Team System’s main goals. VSTS tries to make test and report correlation easier by providing a full-featured tool; yet
Working with dates and times in VB.NET
(Irina Medvinskaya) VB.NET’sDateTime structure represents an instant in time and is usually expressed as a particular date and time of the day. DateTime comes in handy whenever you need to determine the system’s date and time; it also performs various operations on date/time variables. In this artic
DB2 9: Automatic Database Configuration and Memory Tuning
IBM has been a pioneer in autonomic computing. A number of self-configuring, self-optimizing, and self-healing capabilities were introduced in the earlier DB2 releases. DB2 9 continues along this strategy of helping you derive more value from your data, while spending less time managing it. This
Improving Data Security by Using SQL Server 2005
Microsoft, like many large corporations, carefully analyzes existing database security frameworks to make sure that the security frameworks comply with recent government regulatory requirements, such as the Sarbanes-Oxley Act of 2002. These regulatory requirements specify conditions for the storage
Hold On There SYSter
(James F. Koopmann) Probably the most sacred user in all of Oracledom is the SYS user. Let’s take a quick look at how you, as a DBA, can take hold of this often misused account.
Lesson 5 XML integration with SQL Server 2005
XML has become a key technology in enterprise business solutions. SQL Server 2000 introduced XML-related functionality in the database engine through the FOR XML clause of the SELECT statement and through the OPENXML function.
Creating Forms in XML
(Jennifer Kyrnin) If you’ve been building Web pages for a while, chances are you have used, or are planning to use forms. HTML forms allow you to create dynamic pages that include information that your readers provide. They can also collect data from customers to provide services or ecommerce. But w