(Jim Ferguson) The ADO.NET DataTable object contains a lot of useful information that you might not be aware of. For each row in the DataTable you can determine the row’s state (is it original, new, deleted, modified etc.) and you can have access to the “before” values of modified rows as well as th
Other News
How Do I: Work with Master Pages Declaratively and Programmatically in ASP.NET
In this video Chris Pels will show several aspects of defining and using master pages in an ASP.NET web site. First, see how to create master pages declaratively using the ASP.NET master page model and learn what information is best suited to a master page compared to an individual content page. Nex
.NET Debugging Demos Lab 4: High CPU hang
(Tess Fernandez) So we finished the first round of performance issues, crashes and memory leaks. This time we are going to dive in to a high CPU situation and I know that this is giving it away a little but before you go through the lab you might want to have a look at my GC Pop Quiz to familiarize
Web service development and deployment with Informix Dynamic Server and IBM Data Studio
(Shweta Sinha, Prasanna Alur Mathada and Amitava Chakraborty) IBM Data Studio brings Informix Dynamic Server (IDS) developers the latest in Web services technology. Learn how this new set of tools makes it easy to design, develop, deploy, and manage your IDS applications. Get started with Web servic
HOWTO: Namespace use with XMLQuery
(Marco Gralike) Just a small post here as a reminder how it can be applied: the use of namespaces in conjunction with the XMLQuery operator. A question came up on the OTN XMLDB Forum based on XMLQuery. After building a correct example XML file I needed the namespace reference within XMLQuery and it
Resiliency Features
(Arup Nanda) How do you know if your database is humming along smoothly? Well, one way is to check “everything”—a rather time-consuming and error-prone process. In some shops dedicated DBAs perform the same task over and over to assess and report the health of the database, but most can’t afford to
Using MySQL as a filesystem
(Ben Martin) With MySQLfs you can store a filesystem inside a MySQL relational database. MySQLfs breaks up the byte content of files that you store in its filesystem into tuples in the database, which allows you to store large files in the filesystem without requiring the database to support extreme
Designing SQL Server non-clustered indexes for query optimization
(Matthew Schroeder) Non-clustered indexes are bookmarks that allow SQL Server to find shortcuts to the data you’re searching for. Non-clustered indexes are important because they allow you to focus queries on a specific subset of the data instead of scanning the entire table. We’ll address this crit
Oracle BI EE 10.1.3.3/2 – Scoping of Dashboard Prompts and Presentation Variables – Reducing Scope for a specific Report
(Venkatakrishnan J) Today we shall see an example of how to go about reducing the scope of Dashboard prompts to only specific reports. As you would already know, Dashboard Prompts have 2 types of scoping. One is Page and the other is Dashboard.
Functions That Are Not Often Used: SIGN
(Denis Gobo) SIGN is one of those functions which you almost never see used in code.