(Elliotte Rusty Harold) 2006 was a steady and productive, if not especially exciting, year for XML. There weren’t any game-changing products or standards, just slow, incremental improvements to existing technology. Increasingly, XML faded into the infrastructure, usually meriting about as much conce

(David) I really like DB2s ability to quickly restore a backed up database into a new database with a different name in a different location. Just like in SQL Server and easier to do then Oracle.

(Ty Anderson) Starting a business isn’t easy. First you have to think of a great idea that the market needs. Next you should probably build a business plan of a certain depth. And although there are several other steps of the accounting and legal nature, you must summon up the courage to leave the s

(Tony Patton) During a recent meeting, a client demanded his application be Web 2.0 enabled; it was clear he had been reading many of the articles out there about Web 2.0. I responded by explaining the evolution of the Web and its technology, and the fact that the Web 2.0 is only a concept. In the e

(Xaprb) I sometimes see advice to do SQL date operations with the + and – operators on platforms where they are overloaded for date types. I try to avoid that, because it can give unexpected results. I prefer to explicitly use the built-in date/time functions. I’ll show you an example where the oper

(Arthur Fuller) Everything about your SQL Server database is stored in its system tables. I doubt that you spend a lot of time inspecting the system tables since you are too busy with your user tables. However, you may need to do something unusual once in a while, such as list all the triggers in yo

(Robert Brunner) Previously, the articles in this series have demonstrated a number of database concepts by using the ij tool to connect and interact with an Apache Derby database. Although it may not have been obvious at the time, you were using a Java application that used the JDBC application pro

(Greg Robidoux) There is one task I hope you never face: May you never have to recreate data at different points in time in order to unfold a suspicious act or uncover lost or stolen data. Most databases store data at a core data level, which reveals only the most recent state of the data to the end

When histogram is not available (for example when we building an index on a view) we can’t use the same methods as described in previous post (For statistics gathering, it is possible only for ‘real’ object. We are building index on view, so index does not exist at this point and we are not able to

(Dan Wahlin) Debugging is a key skill that every developer has to learn to become productive. However, how do you debug ASP.NET AJAX applications and client-side JavaScript? In this video tutorial I walk through a few required steps to enable debugging and show how to use tools such as Script Explor