By Michael Otey – The way you use binary large objects (BLOBs) in ADO.NET is completely different from the way you use BLOBs in ADO. These examples will help you see how to incorporate BLOB data into your ADO.NET applications. (R, $)
Author: SSWUG Research
How to use the new diagnostic system function fn_get_sql() and the 3 new columns of sysprocesses?
By Vyas Kondreddi – This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of thes
Limiting result sets with FETCH FIRST and OPTIMIZE FOR
by Alexander Kuznetsov – Check out this and other tips at SearchDatabase.com.(R)
Oracle toots RFID horn
By Rob Westervelt – Oracle Corp. is planning a broad upgrade to its supply chain management tools within its CRM suite and is hyping the introduction of radio frequency identification (RFID) technology.
XSL stylesheets and processor-specific features
by Benoît Marchal – This tip illustrates how to write stylesheets that take advantage of processor-specific features while remaining portable.
XML Made Easy with XMLBeans
by Laurence Moroney – A new XML parser from BEA makes it easy to handle instance documents in Java, using regular bean-like syntax.
Browser-based Editing Tools Simplify XML Data Collection
This week, Ektron announced version 4.0 of Ektron eWebEditPro+XML and eWebEditPro. These browser-based editing tools streamline content management and deliver new functionality for data collection, publishing, and reuse.
Visual Studio Tools for Office System Includes SQL Server
Marie Huwe, general manager of Microsoft’s Developer Division, announced that Visual Studio Tools for the Microsoft Office System is now available. The Microsoft Office System lets developers create solutions that integrate information stored on different platforms and systems.
T-SQL Programming Part 1 – Defining Variables, and IF…ELSE logic
By Gregory A. Larsen – This is the first of a series of articles discussing various aspects of T-SQL programming. Whether you are building a stored procedure or writing a small Query Analyzer script you will need to know the basics of T-SQL programming. This first article will discuss defining varia
Become a .NET Connection Pool Lifeguard
In this article from SQL Server Magazine, William Vaughn describes some performance issues with managing connection pools and shows you how to manage your pools to prevent overflow.