(Sayed Ibrahim Hashimi) In previous versions of Visual Studio, the build process was mostly a black box, and there were few things that you could do to customize your build process. With the release of Visual Studio 2005 and the Microsoft .NET Framework 2.0, your managed projects can be built using
Author: SSWUG Research
Enrich Your XML Serialization With Schema Providers In The .NET Framework
(Keith Pijanowski) Mapping classes to schemas and serializing objects to XML documents leads to interoperability. Consider the relationship that exists among classes, schemas, objects, and XML documents (as illustrated in Figure 1). Classes are constructs that describe a software system’s data in a
JavaServer Pages as Web service clients
(William Brogden) JavaServer Pages, or JSP, are an extension of Java servlet technology designed to facilitate dynamic creation of HTML pages by Web developers without writing Java code. When a JSP-capable server gets a request for a JSP page, it initiates a series of events that result in a Java se
Regular expressions in Oracle
(René Nyffenegger) With 10g, regular expressions are finally available in SQL. That is, they were already supported through the owa_pattern package.
Oracle RMAN Backup and Recovery Script Example
Oracle database backup and recovery becomes a lot easier when you use RMAN. This script is indicative of the ease and should not be considered a full script for RMAN backup management in Oracle.
Views in SQL Server 2000
(Kristofer Gafvert) A view is quite easy to define, but a lot more difficult to create, use and manage. It’s not anymore than a named SELECT statement, or a virtual table. You can select data, alter data, remove data and all other things you can do with a table (with some limitations). But there is
XML application migration from DB2 8.x to DB2 Viper, Part 2: Compare XML functionality in DB2 Viper to XML functionality in DB2 V8.x
(Hardeep Singh) XML support in DB2 UDB Version 8.x was based on DB2’s relational infrastructure. XML data was either stored intact as a character large object (CLOB) or shredded to relational tables. DB2 UDB Viper, on the other hand, has true native support for XML data. XML is now handled as a new
Enable Tivoli Storage Manager for IBM DB2 Content Manager
(Lily Goh and Allan Tham) Information defines health and wealth for a corporation. The lack of information readiness can cost dearly for some. As Steve Mills, senior vice president of IBM Software Group, once put it, “Next to people, information is a company’s greatest asset. But its value can’t be
Table Partitioning in DB2 Viper – Details Part 2
(Chris Eaton) Let’s now look at rolling in new data. Assume you have a partitioned table where each partition is a month worth of data and you want to add a new month. The first step is to create a table that will hold the new month’s worth of data CREATE TABLE FACT_NEW_MONTH LIKE FACT_TABLE
Bulk Insert from Flat File Using Transact-SQL
(M M Harinath) In a typical IT environment, it is often necessary to import flat files to SQL Server tables. Sometimes it is necessary to format flat file according to our table structure using delimiters. In this Code Snippet, I am going to discuss how to import Flat files to SQL Server.