(Chris Smith) Those folks at Centerfield Technology certainly are on their toes. An opportunity arises in their field (which is databases), and they’re on it. This week the company introduced a new service: installing, configuring, and verifying the functionality of DB2 Web Query for System i.
Other News
Essential guide to the Ruby driver for DB2
(Antonio Cangiano) This guide is a basic tutorial that’ll quickly get you started with the ibm_db Ruby driver. You’ll be querying DB2 from Ruby in no time, but please bear in mind that this document is not meant to be thorough (use the API reference for this purpose). Also, this is a guide for the I
CodeSnip: Practical Use of ‘for update of’ in Oracle Cursor
(Deepankar Sarangi) In this article, the author examines the usage and application of the “for update of” cursor using Oracle 9i. He examines the concept with the help of a sample scenario. Initially, he provides the complete code listing followed by a detailed explanation. He finishes the discussio
Updates & Discipline
(Martin Farach-Colton) So far, I’ve analyzed point and range queries. Now it’s time to talk about insertions and deletions. We’ll call the combination updates. Updates come in two flavors, and today we’ll cover both.
Make changes to SQL Server stored procedures with batch editing
(Serdar Yegulalp) The database system that I maintain makes extensive use of stored procedures. Most of the common tasks performed with the database are handled exclusively by 2000 and 2005 stored procedures through SQL Server stored procedures. It’s often possible to make global changes to the way
New Data Types in SQL Server 2008 Part 3
(Dinesh Asanka) This is the third article of the new data types in SQL Server 2008 series. We have already discussed the new date time data types in the first article and HierarchyID in second article. In this article, we are going to discuss spatial data types.
Storing Images and BLOB files in SQL Server Part 2
(Don Schlichting) This article will focus on using the SQL Server Binary data type to store small image files. In Part 1 of this series, the definition of binary and BLOBs (Binary Large Objects) was discussed, as well as when to store them in SQL Server. A few reasons to store images or binary data
Bitmap Indexes With Many Distinct Column Values (Wots…uh the deal)
(Richard Foote) In the seemingly never ending list of 8 things one may not have known about indexes, Number 3 stated: “Bitmap Indexes can be extremely useful and beneficial even if the column contains thousands of distinct values”.
SQL Server Name Resolution Troubleshooting
(Tim Cullen) A colleague recently said, “With all the legacy systems, modern systems, and ‘spokes in the wheel’ in this environment, we should celebrate whenever we actually get data to the client.” No doubt there are many pieces to the puzzle that comprises data delivery to internal and external cl
Sandboxes, Production and Virtualization for SQL Server
Featured Article(s) Re-throwing exceptions is expensive Microsoft states, "Catching exceptions and rethrowing them is expensive, and makes it harder to debug and identify the exact source code that was responsible for the exception. Do not catch exceptions unless you specifically want to record and log the exception details, or can retry a failed operation. If you do not do anything […]