(Akshinthala Kishor Kumar) Business enterprises are investing millions of dollars to implement and deliver business initiatives such as ERP, SCM, CRM, data warehousing and business intelligence that rely on consistent, accurate and reliable data. So need of the day for IT organization in such enterp
Other News
Inline Schemas
(Stan Kitsis) Inline schemas are XML schema definitions included inside XML instance documents. Like external schema documents, inline schemas can be used to validate that the instance matches the schema constraints. By default, System.xml disables processing of inline schemas; to enable them, set t
New Product Introduction Process with InfoPath and SharePoint
(Scot Hillier) In the manufacturing vertical, companies follow a well-defined process to bring new products to market. This process typically involves an ideation phase where new product ideas are conceived and then fleshed out into prototypes. In this article, I’ll use an InfoPath form and Windows
Top 10 Must-Have Features in O/R Mapping Tools
(Iqbal Khan) O/R mapping tools are becoming more popular each day and people are realizing the productivity gain they provide to developers. Yet, many people don’t know enough about O/R mapping to consider using these tools and many others are weary of using any code generators (including O/R mappin
Extend Your Code’s Global Reach With New Features In The .NET Framework 2.0
(Michael Kaplan and Cathy Wissink) Extensibility is crucial to international users today. Users want the option to customize the data as appropriate for their needs. What if the built-in support for a particular language or culture is not adequate or appropriate, or the cultural data is missing enti
FIX: The data for the values may be missing in the XML instance documents if you use a proxy for a Web service that was created by importing schema
Consider the following scenario. You use a proxy for a Web service that was created by importing schema. The schema contains values for attributes that are fixed and required in Microsoft Windows Server 2003 Service Pack 1 (SP1). When you use the proxy, the data for the values may be missing in the
How indexes help the query optimizer with statistics
(Kent Milligan) Using the SQL performance monitor of operation navigator, I have scanned for the recommended index. In the index list, one was on QSYS2/SYSTABLES view on the QSYS/QADBXREF table. I have created the recommended index, but unfortunately it looks like the system does not use it and the
Generating Excel(XML Spreadsheet) in C#
(dekajp) Recently I was working on a web based report in ASP.NET , the report needs to be generated in MS Excel format , the data was too much, to give you an idea I need to generate more than 300 Worksheet and File size was more than 5MB. I tried the Office PIA’s but I was not happy with […]
Why InnoDB matters so much to MySQL (really)
(Dave Rosenberg) I don’t think the open source industry fully appreciates the importance of Oracle’s purchase last week of Innobase and what that means for MySQL.
View Running SQL
(Jignesh Prajapati) This script provides information on active SQL.