(ChrisLee1) SimpleQuery is a class designed to run simple T-SQL statements against a .NET Connection. To this end, SimpleQuery contains three static methods to execute T-SQL statements and either return a count of records affected (ExecuteNonQuery), a dataset of the result set (ExecuteSelectQuery),
Other News
Are UDFs Harmful to SQL Server Performance?
(Matthew L. Wigdahl) Well, not really. But it is vitally important to understand when to use them and when to avoid them, as well as how best to construct them so as not to shoot your foot off.
LinuxWorld: Oracle president puts best foot forward with grid computing
(Jack Loftus) Before the keynote from Oracle president Charles Philips Jr. even began, the signs leading into the auditorium asked audience members, “So, Linux is in the enterprise, what’s next?” (R)
Data-2-the-Web for MySQL Speeds Web Database Creation
Building and deploying browser-based database applications became easier today with the release of Alpha Software’s Data-2-the-Web for MySQL. The new software allows MySQL developers to create web-enabled databases in less than ten percent of the time currently required to painstakingly program in l
XDTM: The XML Data Type and Mapping for Specifying Datasets
(Luc Moreau, Yong Zhao, Ian Foster, Jens Voeckler and Michael Wilde) We are concerned with the following problem: How do we allow a community of users to access and process diverse data stored in many different formats? Standard data formats and data access APIs can help but are not general solution
Asynchronous client script callbacks
(Paul Glavich) There has been a lot of interest in the web-facing community lately about a new useability feature that goes by a number of different names—XMLHTTP, AJAX, out-of-band requests, and asynchronous client script callbacks, to name a few.
Building Object-Oriented Database Interfaces in PHP: Processing Data through Data Access Objects
(Alejandro Gervasio) With websites now featuring full-blown dynamic applications that link to databases, data accessing has become a critical process. Often, an object-oriented solution is wanted to manage the data access operations. This works well — except when certain statements are hard-cod
Using the XMLHttpRequest Object and AJAX to Spy On You
(Earle Castledine) Every nerd loves the XMLHttpRequest. It supplies the functionality of which Web programmers’ dreams are made. Web applications start behaving like desktop applications. Things work as they’re “supposed to,” freeing the Mum-and-Dad end users from needing to know anything about serv
Making the Case for CASE Tools
(Steve Callan) Many DBAs find themselves working with someone else’s database design. Unless you are involved with building or designing a new application or database from scratch, when else would you have the opportunity to use a CASE tool? One of the points to take away from having read this a
DB2 Rebind Strategies
(James F. Koopmann) When I was a DB2 DBA quite a while ago our team of DBAs split responsibilities across application areas. We soon became experts in understanding the data model, the access paths chosen by DB2, and how long every statement would take to execute under normal conditions. When ch