(Muthusamy Anantha Kumar) The SQL Mail problems, that we faced in SQL Server 7.0 and 2000, are no more. SQL Server 2005 supports and uses SMTP email now and there is no longer a need to MAPI client to send email. In SQL Server 2005, the mail feature is called Database Mail. In this article, I am goi
Author: SSWUG Research
Exploring .NET’s Isolated Storage
(Peter Aitken) No, isolated storage does not mean renting a Pod and putting it out in the woods somewhere! Rather it is the .Net framework’s answer to a question that has long vexed developers: where to keep application configuration information.
Creating Context-Sensitive Help on a Web Page
(Scott Mitchell) When building report screens for a web application, there are often certain snippets of the report whose meaning may not be crystal clear to all users. Reports may be chalk full of acronyms or abbreviations that be like a second language to the report’s primary users, but gobbledygo
Rethinking IT Measurement to Find the Source of Performance Problems in Distributed Applications
(Mazda Marvasti) Thinking about IT measurement must change whenever the focus is finding the source of a problem in an IT Service built on a distributed IT infrastructure. It’s important to make the shift, because preventing a negative impact on business of difficult-to-diagnose performance and avai
Multi-stage XSLT scripts
(Rick Jelliffe) One of the old secrets of text processing used to be using multiple stages: a pipeline so that each stage did something clear and comprehensible. The programming language OmniMark actually built this notion in, first by having a three stage processor (text, SGML, ESIS) then by genera
XLINQ Part 2: Using Standard Query Operators
(Thiru Thangarathinam) In Part 1 of this article series, you looked at XLinq’s ability to create, modify, and delete XML data. Building on that background, this installment focuses on XLinq’s query features, by first delving into the standard query operators supplied with LINQ and then providing exa
Enhancing MySQL Query Efficiency
(Paul Dubois) There are a number of things you can do in general to optimize your queries and make them more efficient. This article discusses several of these.
Bringing SOA Value Patterns to Life
Businesses of today are being forced to respond faster to competitive and customer challenges and are looking to IT to be a differentiator providing flexibility and speed as they address complex business forces. Forced to deliver more, faster, IT managers are looking at technology foundations that p
Killing an Oracle DBMS_JOB
(James Koopmann) Take control of Oracle’s queue with a step by step approach to getting rid of those pesky DBMS_JOBs.
FIX: You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000
When you try to perform a read of a large binary large object (BLOB) column in Microsoft SQL Server 2000, you may experience one of the following problems: • You receive an access violation error message. • The client application connection that performs the read unexpectedly ends.