(Roger Wolter) This paper describes user instances in SQL Server 2005 Express Edition and how you can use them to simplify adding database functionality to your Visual Studio projects.
Other News
Lightweight R/O Mapping
(Norbert Ehreke) An unwritten consensus in the IT industry is that data shared between object-oriented software and relational databases is best exchanged with object/relational (O/R) mapping frameworks where the entity relationship (ER) model follows the object-oriented model. This article prop
Handling Atom Text and Content Constructs
(Uche Ogbuji) The Atom Syndication Format (RFC 4287) came about in part for social reasons and in part for technical reasons. The social reasons came down to difficulties reconciling factions of existing web feed formats. One of the key technical reasons is that existing web feed formats were not cl
Checklist: How to maintain an effective SQL Server DR strategy
(Greg Robidoux) When most people think of disaster recovery, their initial thoughts are about recovering from a complete disaster like Hurricane Katrina. In reality, this type of disaster is rare and often hits specific areas prone to earthquakes, hurricanes, tornadoes and other types of natural phe
Work Faster with IBM Rational Performance Tester
(Allan McNaughton) Not long ago, software testers had every right to be nervous about performance testing. Frankly, most of the tools that were available deserved their fearsome reputations. Performance testing was more suitable for software developers than testers.
Large Database Features In Oracle (Sample Chapter)
(Ian Abramson) In this chapter, we will be covering topics and features available in Oracle Database 10g with which you will need to be familiar when working with large databases. These features are among the more advanced that you will encounter, but they’re necessary, as databases are growing larg
You may receive messages that state that the computer is out of memory when you run Virtual Server 2005 and SQL Server 2000 as peer applications on the same computer
When you try to turn on virtual machines in Microsoft Virtual Server 2005, you may receive messages that state that the computer is out of memory. This problem occurs when the following conditions are true:d • You are running Virtual Server 2005 and Microsoft SQL Server 2000 as peer applications
Utilizing Triggers within DB2
(Aleksey Shevchenko) I have been recently challenged with implementing an enhancement to an existing Web application and a batch process. Similar to many applications that I encounter in my everyday professional life, this application is poorly written and lacks any basic documentation and source co
Working with DB2 stored procedures in Delphi 2005
(Bob Swart) In this article, we will use the Borland Data Provider for ADO.NET, which is part of Borland’s C#Builder, Delphi 8 for .NET, Delphi 2005, and the newly released Delphi 2006. The latter two have both Win32 and .NET personalities, but in this article, I want to focus specifically on the .N
Track CPU Usage
(Jony Safi) This query monitors CPU usage by session, showing information about processes running. It can identify the whole proccess tree.
