(ecavanaugh) Let’s take a look at some of the new features for working with XML Schemas in the latest release of XMLSpy.
Other News
To REBIND or Not to REBIND: Why Is That Even a
(Craig S. Mullins) One of the most important contributors to the on-going efficiency and health of your DB2 environment is proper management of DB2 access path changes. A thorough REBIND management process is a requirement for healthy DB2 applications.
DB2 Temporal Tables – Capturing a Snapshot of Your Business
(Dave Beulke) DB2 offers application designers new functionality for their data warehousing requirements. The new DB2 10 Temporal Tables provide a way to have a snapshot in time of the status of customers, orders or any other type of business situation.
Primary Key and Index
(Hemant K Chitale) The default expectation is that defining a Primary Key constraint creates a Unique Index on the exactly the same columns (i.e. in the same order as well) as specified in the constraint.
Easily Setup Fluent Nhibernate With Oracle
(Muhammad Bilal Ashraf) Nowadays it is preferred to use ORM instead of old data access approaches. However, setting up an ORM like Fluent NHibernate with Oracle takes some time.
Oracle Flashback Version Query-pseudocolumns designed to investigate when changes occur
(James Koopmann) I think everyone can attest to the fact that using Oracle’s Flashback Query functionality is advantageous to finding out what data looked like at a particular point in time.
My Biggest C# Programming Mistake
(Patrick Steele) In early 2009, the company I work for was offered the job of rewriting an old Web site that used ASP.NET WebForms. The site integrated with a SQL Server database as well as a SharePoint installation. The people in charge of maintaining the site told us it was populated with old code
Creating a Mono CMS with MySQL and ASP.Net
This is a tutorial on how to develop your own Mono CMS using MySQL database in ASP.NET 3.5. To make this tutorial series easy to understand, it is recommended that you have some background in the use of MySQL database in Mono.
Generating Surrogate Keys Using an Identity Column in SQL Server
(Gregory A. Larsen) In my last article I talked about the difference between surrogate keys and natural keys. In that article I discussed how surrogate keys are made up keys, meaning they do not appear naturally in the data.
Concurrency Series: My application was running fine yesterday but why is it blocking today?
(Sunil Agarwal) Have you ever encountered a situation where a query was running fine yesterday but today it is running a lot slower? I am sure most of us have seen a situation like that which can be quite frustrating.