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.
Other News
OASIS and RosettaNet Set Standards Alliance
By Michael Singer – The two groups look to streamline Web services development by working closely together on specs as ebXML and the Universal Business Language (UBL).
Visualizing XSLT in SVG
by Chimezie Ogbuji – There are a number of visual tools employed by XML editors and viewers which make verbose XML documents easier to browse and manipulate. XML Spy is, for example, such a tool. This article will introduce how SVG can be used to create a visual representation of an XSLT stylesheet.
Solve Problems, Not Symptoms
By Brian Moran – All too often, people shortsightedly focus on managing the physical symptoms of their performance problems. You should always begin by trying to identify the root causes of the performance problem.
Is Microsoft to Blame for SQL Slammer?
(Peter Galli and Anne Chen) Microsoft Corp. and its customers need to take joint responsibility for security issues such as the SQL Slammer worm, which brought down systems all across the world earlier this year, several large enterprises said here at the TechEd conference on Monday.
Code Futures Launch FireStorm(TM) DAO Code Generator for Java
Code Futures has announced the initial release of FireStorm, an innovative code generation product for Java and J2EE developers.
Altering Oracle’s SQL*Plus Help Facility
Everyone needs a little help now and then. James Koopmann finds new ways to provide information to users of SQL*Plus through the Help Facility.
Script to grant permissions
By Parthasarathy Mandayam – Here’s a simple script that can be customized to quickly grant permissions to various users on all tables or stored procedures. Using this script I was able to reduce the time taken to grant permissions during installation from 30 minutes to 1 second! It is much faster th
XML-Based ASP.NET Page Templates
Templates provide an excellent way to maintain a consistent look and feel across a Website. However, version 1 of ASP.NET doesn’t natively support the concept of templates. This isn’t a major stumbling block since the .NET platform provides a robust object-oriented environment that can be leverage
IBM’s Bigger, Better DB2 Database
By Kimberly Hill – Enterprises have suffered much in their quest for the elusive “single view of the customer.” Combining all sources of customer information into a single repository has proven painful in some instances and disastrous in others.