(Scott Mitchell) Software engineering involves a number of important stages that occur before the application is deployed, such as requirements analysis, design, coding, and testing. The software engineering process, however, does not end once an application has been deployed and is being used. Rega
Other News
db2pd to monitor locks
(Chris Eaton) Here is a very fast and very low overhead way to look at lock wait situations in DB2 using the db2pd tool. You can of course find locking information from the snapshot monitors or from the administrative views I described previously. But for those that like something very light weight
Aligning Your BI Environment with SOX Internal Controls
(Brandon Lucado) Is your financial reporting application compliant with Sarbanes-Oxley (SOX) Section 404? The answer to this question will depend on what controls your company has established internally. SOX Section 404 mandates companies to implement a control framework for their financial reportin
Linking SQL Express 2005 Tables to MS Access 2007
(Jayaram Krishnaswamy) This tutorial shows you how to link tables on your SQL 2005 Express server to an MS Access 2007 database. Some of the salient features of the MS Access 2007 program were discussed in an earlier tutorial including a detailed description of the “Ribbon.” Reading the earlier arti
Tutorial: Specializing DITA Conditional Attributes
(Eliot Kimber) A new feature in DITA 1.1 is the ability to specialize from the base= and props= attributes. For conditional processing, this lets you add your own attributes rather than using otherprops=, which can be clearer to authors and implementors. [NOTE: at the time of writing the DITA Open T
Processing with C#, Oracle transactions and Oracle exceptions
(Dimitar Madjarov) The main purpose of this article is to show one different way of cooperation between Oracle and C# in process of developing different Oracle database application with Microsoft Dot.Net technology and C#. In this article I will try to show you a new approach of programming and taki
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part I
(William Pearson) In this article, we extend the meaning of “samples,” as well as the type of “Administrator,” a bit further. We use an installation file recently made available by Microsoft that allows us to implement an exciting new report pack with minimal effort. Because we will be running the i
Rich Ajax slide shows with DHTML and XML
(Jack Herrington) Learn to create an Asynchronous JavaScript and XML (Ajax) client-side slide show that’s animated using "Ken Burns Effects." Here, you discover how to build XML data sources for Ajax, request XML data from the client, and then dynamically create and animate HTML elements with that X
Use Ajaxterm for remote administration tasks
(Vincent Danen) Remote administration usually requires access to a terminal on a remote system, but if you don’t want to permit direct ssh access, there aren’t a lot of other options. And with constant port-knocking and brute-force attempts on ssh services these days, some people would prefer not to
Tempdb changes in SQL Server 2005
(Serdar Yegulalp) The total number of changes to SQL Server in its 2005 edition could fill a book, and in fact has filled several such books. The most significant changes are not feature changes; They’re changes in internal behavior that aren’t always immediately visible to a user or administrator.