(Greg Robidoux) As a DBA your primary responsibility is to ensure the database is online and the data is intact. In addition to making sure the database is available, you are responsible for having a safety net in place to contend with a system failure. What type of failover solution are you relying
Author: SSWUG Research
SqlDataSource With Transactions
(Anil1979) One of the best new features of the ASP.NET 2.0 will be the SqlDataSource control. However, as I found out in my experimentation what seems like a simple control has some complex behaviours to master to get it working properly.
Pros and Cons of Descriptive Foreign Keys?
(Sheeri Kritzer) So what are the pros and cons of using descriptive foreign keys, as opposed to surrogate keys?
Finding Paths, Timestamps and More with the DirectoryIterator Class in PHP
(Alejandro Gervasio) Are you interested in having at your disposal a quick reference for working with the “DirectoryIterator” class that comes with PHP 5? Then this might be the article that you’ve been waiting for! Welcome to the second tutorial of the series “A Close Look at the DirectoryIterator
Tip: How to conditionally change the color of a Chart in Crystal Reports?
(Mahesh Chand) This tip shows how to change the color of a Chart in Crystal Reports based on some conditions.
CodeSnip: How to Select Record(s) Using Checkboxes and Delete on Confirmation in GridView
(Sushila Bowalekar Patel) We come across situations where we have to select/deselect multiple records or delete them once the user gives confirmation. This can be done in various ways and using various Data Controls provided in ASP.NET. For our sample we will use the GridView control.
.NET Tip: Creating and Using Your Own Events
(Eric Smith) When I’m writing code for user controls that need to signal the host page when they’re done with some task, I define and use an event. I simply register for a custom event and run my code when the event occurs. This makes a clean interface between the user control and the page and makes
Sequence Objects and Identity Columns
(Craig Mullins) When designing DB2 databases a frequently heard request is for a column that contains sequentially generated numbers. For example, each row has a counter associated with it. When a new row is inserted, the counter should be incremented by one for the new row. This way, each new DB2 r
XForms tip: Accepting XForms data in PHP
(Nicholas Chase) In some ways, an XForms form is just like an HTML form; with the proper encoding, the server-side script receiving the data won’t even know the difference. But the strength of XForms forms is in many ways the fact that the data can be submitted directly as XML. Of course, this capab
Real-world Apache Derby, Part 1: Apache Derby and OpenOffice.org Calc
(Dave Warner) Apache Derby signals a sea change in both desktop and Web-based applications. For the first time, that elusive target for developers — complete data portability — is easily attainable. This tutorial, the first in a series, shows how you can use Derby as a data store to overcome row-l