(Nicholas Chase) XML seems like a natural format for passing Ajax data. However, to work with XML in JavaScript using the Document Object Model (DOM) is not always the best way to handle this kind of data. This has given rise to other choices, such as JSON, which provide a more object-like feel for
Other News
Reporting MySQL Internals with Information Schema plug-ins
(Roland Bouman) Last week, I described how to use the MySQL plug-in API to write a minimal ‘Hello world!’ information schema plug-in. The main purpose of that plug-in is to illustrate the bare essence of the MySQL information schema plug-in interface.
Measuring Disk I/O
(James Koopmann) Do you know how your disk subsystem is actually performing? This article looks at extracting various I/O statistics so that you can monitor and determine just how well your disks are doing.
Materialized View Replication
(HP Fuchs) This post is for my friend Gerry, who – as a newby to Oracle – has to support a replicated environment. Gerry is my successor at Kanton Luzern. Management didn’t look for a new DBA because they said it’s hopeless to find somebody. Instead they decided to give somebody inhouse the opportun
ALTER INDEX COALESCE: 10g Improvements (Jump They Say)
(Richard Foote) I thought it might be worth mentioning some interesting changes in the manner in which the ALTER INDEX … COALESCE command works since Oracle 10g.
Date and Time Data Types in SQL Server
(Mike Chapple) With the introduction of SQL Server 2008, Microsoft answered the pleas of many database professionals by introducing revamped date and time . These new data types allow designers to easily work with time zones, dates without times (and vice versa) and dates in ancient history and far
Finding dependencies in SQL Server 2005
(Tim Chapman) Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don’t want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used.
What are the Bulk Import Optimizations?
(Sunil Agarwal) Bulk import provides an optimized insert path that minimizes this overhead with following optimizations:
Creating delays in processes to mimic user input or delay process steps
Sometimes when running processes there may be the need to create delays before the next step runs. This could be for processes that are run externally and therefore you have no control over when that process finishes, the need to mimic a delay in user response if you are doing testing or maybe you
How Do You Grow Your SQL Server Position?
Tomorrow’s the Day! Tomorrow we kick off the three-day virtual SQL Server conference, direct to your computer. We have a huge number of people registered already and we’re ready to go with more content than you can find anywhere else online, period. We’ve even opened up our webcast archives – you can watch past webcasts on-demand during the conference. From […]