(Roger Jennings) In SQL Server 7.0, servers linked by OLE DB providers replace the remote server feature of earlier versions. In the past, servers used remote stored procedure calls for interserver communication. Judging from the few non-Microsoft hits returned by Web search engines on linked server
Other News
Converting from Access to SQL Server
(Eli Robillard) The document assists users migrating from Microsoft Access to Microsoft SQL Server. Though written specifically for users of GenericDB, the process may be applied to any Access database. Of particular note are the steps to convert a Random Autonumber field to one which uses Increm
Tuning the Oracle Server – Identifying Internal Contention
(Virag Saksena) The readers will learn about contention for different resources in the server – latches, locks and ST enqueues. They will learn to determine if contention for any of these resources is responsible for performance problems. They will learn to drill down to identify the sessions causi
Production to Development: Moving Databases
(David Kline) Moving a database from one system to another can be a complex job, especially if the source database requires 24-hour, 7-days-a-week availablility. Wouldn’t it be nice if you could move all of the database objects in one clean operation? No setting constraints, creating indexes, tables
Minimizing Weaknesses in TLS
(Jim Clune) Knowing how to implement transport layer security (TLS) does not guarantee secure Web services. Certificate mismanagement, man-in-the-middle attacks, and XML attacks could compromise the security of your TLS implementation unless you understand how these attacks are executed and you cons
XML-Constraints with Scheme
(Erik Meißner) In complex authoring environments the usage of XML with its richer structure is a real advantage. But there is an almost infinite number of possiblities for our structure. If we add a DTD (like in SGML) to our XML-environment we can control the almost infinite number possibilities. Th
Overview Of Oracle Enterprise Manager
Oracle Enterprise Manager is a system management tool which provides an integrated solution for managing your heterogeneous environment. It combines a graphical console, agents, common services, and tools to provide an integrated, comprehensive systems management platform for managing Oracle product
DB2 UDB Scripting with Windows Scripting Host
(Chris Fierros) In this article we will cover in detail the more popular languages available for scripting on Windows, including Jscript and VBScript, that can be used to develop and deploy DB2 UDB scripts within the Windows Scripting Host (WSH) environment. Topics covered include: –Windows
HOW TO: Perform Bulk Updates and Inserts Using OpenXML with .NET Providers in Visual C# .NET
This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SqlClient managed provider, you can also use the OLEDB or the ODBC managed provider.
Using XML Schemas and DTDs Together
(Greg Watson) This article focuses on how to validate an XML document against an XML Schema and a DTD at the same time. Additionally, the article focuses on how to transition from using DTDs exclusively to using both XML Schemas and DTDs. This type of transition is especially important for organizat