(Linchi Shea) People often rely on rules of thumb to tell whether there is a problem. DBAs are no exception. For instance, we are told that if the I/O latency (i.e. Avg. Disk sec/Read or Avg. Disk sec/Write) is greater 20 milliseconds, it’s bad. In addition, if the current disk queue length is signi
Other News
Bulk Uploader in ASP.NET 2.0
(Munir Shaikh) In my previous article I had made use of to upload file, in asp.net we have new server side control called as “FileUpload control”
Mastering Ajax, Part 10: Using JSON for data transfer
(Brett McLaughlin) Plain text and XML are both data formats that you can use for sending and receiving information in your asynchronous applications. This installment of Mastering Ajax looks at another useful data format, JavaScript Object Notation (JSON), and how it makes moving data and objects ar
Creating cross tab queries and pivot tables in SQL
(Keith Fletcher) Sometimes, you just absolutely have to generate a cross tab in SQL. It won’t do to have the reporting system do it, nor is it feasible to build that functionality into the application. For example: –You may be using a reporting solution that doesn’t provide this functionality.
Two options for scaling out your SQL Server system
(Tim Chapman) Last week, I examined the differences between scaling up and scaling out your SQL Server environment.
Don’t reference auto increment ids outside of mysql.
(Eric Bergen) It’s a common practice to use MySQL’s auto increment feature for things like product ids or invoice numbers. While it always works when the system is first setup it can cause major headaches over time. The problems usually fall into one of three categories, dual master, test/staging se
DB2 Top Tips: A ‘Hat Trick’ – Three Tips for Busy DBAs
(Damon Anderson) Need a matrix of tables and the plans and packages that use them? How about a technique to avoid mass deletes and inserts? Or, how about a REXX program that retrieves all of your subsystem parameter values and puts them into a data set in a nicely formatted list? If so, read on for
Improve XPath Efficiency with VTD-XML
(Jimmy Zhang) For the past several years, XPath has been steadily gaining popularity as an effective tool when developing XML applications. XPath was originally viewed as an adjunct element for the W3C’s XSLT and XPointer specifications, but developers found its simplicity appealing. With XPath, ins
Exporting to Excel from any ADF Table
(Lucas Jellema) No matter how fancy the application you develop, no matter how sophisticated the user interfaces: end users will always clamor for Excel. All data eventually will end up in some Excel Spreadsheet it seems. And grudgingly or not, we will of course oblige them. Depending on how difficu
The Answers (and the Questions) in the Hunt for Data Quality
(Robert Heidenreich) Do you know the answers to the seven key questions concerning data quality? Let’s face it, data integrity is a monumental problem for business-to-business marketers – a problem that is often ignored. Without good data, however, your organization can’t make decisions about to