SQL Server Mode is a database application environment that is unique to the IBM System i platform. When SQL Server Mode is used, database connections establish a one-to-one relationship with a QSQSRVR server job. When SQL statements are executed in the client job, the corresponding QSQSRVR server jo
Other News
DB2 LUW Performance: The Most Important Cost
(Scott Hayes) In this blog post, I will describe the most important cost metric that you MUST measure, and work to improve, to become a Performance Hero in your organization. This cost metrics is "Bufferpool Logical Reads per Transaction (BPLRTX)".
Silverlight, Ajax and the Rich Internet Application
(George Lawton) In recent months Silverlight has emerged as a possible challenger both to Flash and to Ajax in the realm of Rich Internet Application development. (R)
Java Web Services, Part 3: Axis2 Data Binding
(Dennis Sosnoski) Even though XML message exchange is at the core of Web services, most Web service applications aren’t concerned with XML. Instead, these applications want to exchange business data that’s specific to the application. XML is, in this case, just a format used to represent the busines
Integrating AJAX Clients and RESTful Web Services
(Edmon Begoli) It is no coincidence that AJAX and RESTful web services gained the attention of developers in their respective stages of infancy. Both technologies emerged during times that were dominated by cumbersome enterprise technologies. They gained popularity because of the freshness, innovati
SqlCredit Part 7: Performance Impact of EncryptByCert and DecryptByCert
(Rob Garrison) The task here is to determine the performance impact of EncryptByCert and DecryptByCert. In short, the cost is high. Microsoft acknowledges this in the Remarks section of Books Online’s coverage of EncryptByCert, but it is not a well-publicized limitation: This function encrypts da
The Cost of Locks
(Jim Mischel) Locks aren’t free. There are definite costs associated with adding Monitor locks to your code. There are performance costs associated with acquiring and releasing locks as well as with other threads blocking while waiting to acquire a lock. In addition, the addition of locks complicate
Cryptographic Solutions for .NET Developers: Hashing and Encryption
(Jani Järvinen) Cryptography is an important part of many applications. Even if your application doesn’t process credit card data or military information, it is likely that your application will need to store secrets such as usernames or passwords.
Building A Class Library Using the Calitha BNF Engine
(Dina Fleet Berry) As users of search engines, we have to learn new query syntax with every new search engine or database. It would be nice to be able to search our own databases with Google-style syntax so that non-SQL programmers could search the data. This article will build a .NET class library
Quick RAID
(James F. Koopmann) Database and Storage Administrators often seem to have little in common when weighing in their requirements for storage against each other. There is, often times, very little common ground. Database Administrators are not likely to question where Storage Administrators find that