This is a comparison between an xml format native to .Net and the bcp format, as a medium for transferring medium sized data sets between two computers. Neither solution requires either computer to expose SQL Server or any of its components to the Internet. The methodology used for obtaining
Other News
Data Modeling, Breaking & Fixing First Normal Form (1NF)
(James Koopmann) It has been my observation that a lot of us lack the basic skills required to model the simplest of database objects. This article will explore some of the common mistakes and fixes to the breaking of 1NF.
Yes you can use IBM Assembler language to access DB2 data
(Craig Mullins) I need to create some extract programs to read a set of DB2 tables in our mainframe environment? I don’t have time to learn COBOL but I have 18 years of experience with MVS Assembler. Is there a way to connect the two (DB2 and Assembler)? (R)
OpenRowSource and OpenRowSet in SQL Server 2000
(Muthusamy Anantha Kumar) SQL Server Data Base Administrators are often exposed to situations in running ad-hoc queries using external data sources such as MS-Access database or Excel sheets or CSV files or text files. For such frequent requests, Database Administrators usually use “linked servers”
MS SQL Server Distributed Partitioned Views Part 2
(Don Schlichting) In this second article, the use of Distributed Partitioned Views for Insert, Update, and Delete statements will be explored.
Handling Unstructured Data Type in DB2 and Oracle
(Alexander P. Pons and Hassan Aljifri) The objective of our work is to determine which mainstream object-relational database management systems (ORDMS) provide convenient facilities for the storage and manipulation of unstructured data objects. These objects, which consist of video, audio, photograp
Vimming with SQL*Plus
(David Kalosi) The Vi tool, which is included in nearly every UNIX-like OS and runs on nearly 20 different platforms, is the easily the world’s most popular text editor, and Vim (or Vi iMproved), its enhanced, extended clone, is the one of the most popular text editors among Linux sysadmins. Given t
Understanding Buffer Pool Performance and Tuning in DB2 UDB v8.1 Multi-platform Environments
(Scott Olson and Joshua Steffan) When tuning a database environment such as DB2, the Database Administrator (DBA) often needs to look at many things on many different levels before determining a viable approach to resolving the issue at hand. Is the application SQL written properly? Are the database
Optimized Queries with SQE
(Robert Bestgen and Denise Voy Tompkin) The newly redesigned query engine in DB2 Universal Database (UDB) for iSeries is not your father’s query engine. While both the new SQL Query Engine (SQE) and the existing Classic Query Engine (CQE) can handle your queries from start to finish, the redesigned
XKMS Messages in Detail
(Rich Salz) This month we begin to implement our XKMS server. We’re going to focus on the Register operation. This is the cornerstone of the key registration service, X-KRSS; it implements the core CA function, which is issuing certificates.