(Kayalvizhi Ganesan and Scott Walkty) Configure DB2 automatic maintenance operations from either the command line or programmatically, using new stored procedures introduced in IBM DB2 9.5 for Linux, UNIX, and Windows. This article discusses different configuration options and provides examples.
Other News
SQL Injections and Stored Procedures
(Rob Williams) In doing numerous reviews of stored procedures, we see many customers with SQL injection issues. SQL injection is one of the most basic and common security issues in database applications.
A Larger Integer
(Jim Mischel) The .NET Framework has support for integers and unsigned integers up to 64 bits long. On a 64 bit processor, which has a native 64 bit type, operations on these long integers are very fast. Even on a 32 bit processor, the operations are normally pretty quick because the processor instr
.NET Tip: Filling Lists with Enums
(Jay Miller) Many times, my code has an enumeration defined; it parallels the items that need to be displayed in a list. Keeping the list and enumeration in sync if items are added can be a challenge. To alleviate that problem, I’ll show you a function that you can use to populate a list from the en
The Real Value of Service Oriented Architecture (SOA)
(Payton Byrd) Service Oriented Architecture is often used as both a adjective and a noun, but I really believe it is only one of those. Why and why should you care? I’ll tell you!
How To Design, Build, and Deploy Custom Web Parts
(Devin Rader) As portals gain in popularity, both as consumer-focused information portals and corporate collaboration tools, developers are increasingly being told to integrate customized portal features. In this article, I’ll take a look at the solutions Microsoft offers for creating Web portals an
Completing the Introduction to Transact-SQL
(Barzan “Tony” Antal) In the first half of this series we learned the basics of Transact-SQL. In case you missed it, I strongly suggest you check it out before moving on with this segment. The programming concepts demonstrated there stand for a foundation on which we are going to build today.
SQL Server 2008 Spatial – Performance of database calls follow up
(Simon Sabin) I recently blogged about the performance of passing spatial data to the database.
SQL Server clustered index design for performance
(Matthew Schroeder) Clustered indexes in SQL Server are a critical consideration in the overall architecture of the database. They are often overlooked, misunderstood or, if the database is small, considered unimportant. (R)
Oracle: Is OUTER JOIN Better Than NOT EXISTS?
(Grégory Guillou) I’ve been told that using NOT EXISTS in (Oracle) SQL is a bad idea, and that a way to overcome this problem was to collect the non-matching rows with an OUTER JOIN. So I decided to check if it is true.
