(Bipin Joshi) Transactions are commonly used to update data as a batch. If any one operation from the batch is failed the entire batch of operations must be cancelled. Thus either all operations in the batch succeed or all of them are cancelled. ADO.NET 1.x provided SqlTransaction class that in conj
Other News
Functions
(Jonathan Lewis) The following question appeared on the Oracle Forums recently: The use of functions – a function with other selects (eg. calculate availability of a part) – is slowing down our system when we do a select over our product file. Is there some kind of rule when functions should b
WebSphere message queuing features for high availability on i5/OS
(David Peraza) Learn how the WebSphere message queuing (WMQ) features together with the IBM i5/OS clustering capabilities can provide a highly available environment for WMQ persistent messages. See how WMQ cluster and i5/OS cluster capabilities can be combined to provide a more complete high availab
A T-SQL Regular Expression Library for SQL Server 2005
(Steve Abraham) With the advent of CLR integration into SQL Server 2005, it has become incredibly easy to extend the power of the T-SQL programming language. Two of the areas that can be improved upon by way of CLR integration are string matching and string manipulation.
Handling NULLS in SQL statements
(James Koopmann) For some reason the ability to handle NULLS in SQL statements can confuse some. This article takes a look at how to think of NULLs.
DLinq (Linq to SQL) Performance (Part 1)
(Rico Mariani) I love Linq. Really. That might scare you because it has all these wacky new constructs and as a performance guy you’d think that I’d be all about getting rid of abstractions and just getting to the metal. But don’t be scared, I haven’t lost my mind. Linq is great because, even th
NULL – The database’s black hole
(Hugo Kornelis) I once read a scientific article on black holes that started of on the observation that, since a hole is the absence of anything and black is invisible in space, a black hole is in fact an invisible nothing – so what the heck are we talking about? Well, almost the same can be said ab
FIX: Error message when you import data from a flat file in a SQL Server 2005 Integration Services (SSIS) package: ‘There is a partial row at the end of the file’
When you import data from a flat file in a Microsoft SQL Server 2005 Integration Services (SSIS) package, you may receive the following error message: Warning: 0x8020200F at Data Flow Task, Flat File Source [1]: There is a partial row at the end of the file.
QA Strategy and Tactics in a BI Project, Part 5
(Arup Duttaroy) Part 4 of the series discussed lifecycle test stages. Part 5 discusses the strategic and tactical aspects of data quality assurance as applicable to a data warehousing cum business intelligence project.
Mini-Tip #12: Anchored Declarations – %TYPE and %ROWTYPE
(Lewis Cunningham) When you declare a variable, you must give it a data type and a size.