(Penny Lunt) Challenging economic conditions have led many vendors to introduce competitively priced starter editions, offering core functionality in easily deployed, prepackaged solutions. Armonk, NY-based IBM has long been a big, influential player in content management, but its market strength
Other News
Grading Grid Computing
(Michael Otey) Welcome to the latest IT buzzword: grid computing. Also known as utility computing or on-demand computing, this technology has almost as many definitions as it has monikers. At its lowest level, the goal of grid computing is similar to that of Microsoft’s Trustworthy Computing initiat
Coordinate Your DTS Tasks, Part II: Import an Indeterminate Amount of Excel Data into SQL Server
(Drew Georgopulos) Part I of this two-part series exploring DTS tasks illustrated how to chain different types of tasks together to collect the information you need to process data contained in a file location table. It’s a technique I used during a SQL Server project in which I built a solution tha
How To: Creating parent/child relationships in XML using XSL
(Kieran Kelly) In a recent FAQ I explained how to create recursive XML using a somewhat complex stored procedure. This method is not very intuitive and seems to be forcing SQL Server to do something it wasn’t meant to do. In this FAQ I am going to use the same table and data from the previous FA
Tips for Reducing SQL Server Deadlocks
Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. When this happens, SQL Server ends the deadlock by automatically choosing one and aborting the process, allowing the other process to conti
Control your SQL Server 7.0 and 2000 via E-Mail
(Muthusamy Anantha Kumar) Data Base Administrators are often exposed to a situation where they want to query a table, check on the status of a server, check an error log or run a DBCC command on a SQL Server box when they do not have access to the box directly. This often happens when they are off s
Diagnosing Performance Problems
(Cary Millsap) Suppose that one day you are driving to work and end up arriving late for an important meeting. You aren’t able to present your revolutionary idea, so your clients aren’t going to use it. You’re frustrated by your tardiness and vow to never make the same mistake again. So how do you d
DocumentBuilder: An Alternative to Hard-Coded String Concatenation
(Matt Nicholls) Whether it be SQL, HTML, XML, or even ASCII, odds are just about every application you’ve written has to generate a formatted String of some kind that represents the state of an object. Figure 1 shows a common (albeit bad) way to generate an INSERT SQL statement for a Customer object
XML Integration with ADO and Internet Explorer 5
(Gayathri Gokul) In this article, I’ll show you one of the greatest features about ADO 2.5, which allows us to access a recordset as an XML document, providing a different way to manipulate data.In this article, I’ll show you one of the greatest features about ADO 2.5, which allows us to access a re
Caching Oracle Data for ASP.NET Applications
(Narayan Veeramani) For building scalable and high-performance Web based applications, ASP.NET provides a feature called data caching. Data caching enables programmatic storing of frequently accessed data objects in memory. This feature can be extended to vastly improve performance for ASP.NET appli