(Sonu Chauhan) Part I will brief you on How to Design Reports in VS.NET. And Part II will describe how to upload your reports on the Server and what code to write in the Application to invoke those reports.
Other News
Semantic interoperability with universal data element framework
(Neelima Vobugari) In today’s IT applications, typically a data element representing the same concept is named differently in different applications. In application integration scenarios, these interacting applications need interfaces or appropriate adaptors between them. These interfaces or ada
Advanced Query Writing, concluded
(Andrew Oppel) From Chapter 1, you should recall that a view is a stored database query that provides a database user with a customized subset of the data from one or more tables in the database. Note that Microsoft Access uses the term query instead of view. The inherent beauty of views is that, on
Perform the Impossible: Update a Multi-Table View using INSTEAD OF Triggers
(Michael Sansoterra) Sometimes using SQL to perform simultaneous inserts, updates and deletes against related tables can be a chore. It would be convenient if programmers could simply treat related tables as a single table for the purpose of modifying data.
Database Migration – It’s More than Running exp and imp
(Steve Callan) The new server using Red Hat is up and running, Oracle RDBMS software has been installed, a new instance is running with all of the new features you can possibly imagine (at long last, run_fast=true is available), and “all” that’s left to do is migrate the source database (or schema)
Take your .NET application for a spin with ACT before rollout
(Tony Patton) The time has finally arrived. The coding is finished and everything has been tested as thoroughly as possible, so the next step is rollout, right? Well, you may want to take a step back and evaluate the application’s performance under expected conditions before the unveiling.
Monitoring and Tuning SQL Server with Profiler
(Baya Pavliashvili) SQL Server comes with several excellent tools for monitoring and tuning application performance. Profiler is perhaps the most powerful of these tools; it allows you to spy on and analyze the impact of SQL statements sent to your server.
Improving Database Performance with Partitioning
(Robin Schumacher) A few years ago, I wrote an article entitled “The Foundation of Excellent Performance” (still available at http://www.tdan.com/i016fe03.htm) where I argued against the notion that SQL code was the number one contributor to performance in a database-driven system. Instead, I stated
Oracle Can’t Stifle Open-Source Databases
(Charles Garry) Opinion: The open-source database community is too resilient and diffuse for even Oracle to subvert, despite the sinister conspiracy theories swirling around the recent buyouts of Innobase and Sleepycat Software.
XmlGridControl Editing XML Data in the PropertyGrid
(Michael Coyle) I’ve been using the XSD.exe for quite a while to generate classes from XML Schema Definition (XSD) files. These classes are uniquely suited for serializing/deserializing XML data into an object model that a programmer can use to manipulate data. When paired with a middleware prod