This step-by-step article describes how to move a database diagram that was created in SQL Server Enterprise Manager. Database diagrams are contained in the dtproperties system table of the database.
Other News
SQL procedure tracing
(Serge Rielau) This article describes an API that allows for transparent tracing of SQL procedures as well as explicit tracing of non-SQL procedures in DB2 Universal Database (UDB) V8.2 for LUW. An example SQL interface to this API is provided, as well.
Wrestling HTML
(Uche Ogbuji) Lately I’ve seen HTML parsing problems everywhere. One project needed a web crawler with specialized features provided through Python code that processed arbitrary HTML. There have also been several threads on mailing lists I frequent (including XML-SIG) featuring discussions of mechan
Investigating Reporting
(Scot J. Reagin) If you’re like many IT professionals, designing and managing reports isn’t likely to make your list of “top 10 ways I’d like to spend my day.” The continuous maintenance and modification tasks inherent in reporting can be a significant strain on already stretched resources, and y
Save Your Password
(Dinesh Asanka) How often have we seen password is saved in plain text? After doing all kinds of security arrangements still we keep the password in plain text. This short article will discuss about how to keep the passwords in somewhat secure way. (R)
IBM DB2 and SQL Server: Video Comparisons
Microsoft partner Extreme Logic offers a series of demos and presentations highlighting the integration between SQL Server 2000 and IBM DB2, with a focus on how SQL Server 2000 can add value to an existing IBM DB2 environment, be it on the mainframe, AS/400, UNIX, or Microsoft Windows operating syst
Getting the Most Out of XML with XPath
(Jack D. Herrington) WML has now taken over the representation and storage of structured data in a textual format. No longer do we even have a need for new text formats because XML and its related standards do such a good job, and are so ubiquitous, that new standards are no longer needed. Understan
Undocumented Quick-and-Dirty Sample Applications
(Steve Muench) As part of helping customers be successful with JDeveloper and ADF I’m often creating little example applications to illustrate a point. My goal is to document them and put them together with an OTN “HowTo” paper to accompany them, but I don’t always have the time to do the documentat
Creating a Tree View of XML Data in Visual Studio .NET
(John Mueller) XML provides a convenient means for storing data, no matter what form the data takes. It relies on a hierarchical structure to store the data, unlike the tables used in a relational database. Consequently, XML has advantages and disadvantages versus the relational model you’re probabl
Working with XML Processing Instructions in C#
(Michelle Beall) Firstly, what is an XML processing instruction? A processing instruction (PI) is a tag that encodes specific application information which begins with < and ends with >. An XML document can contain multiple processing instructions for different applications. There are tw