(pgalbraith) I know most articles are more about DBA issues, however, being a MySQL DBA means that you have several hats that you can where– data architect, application developer, MySQL source developer, and often good old fashioned DBA. I recently had an interesting problem with a particular projec
Other News
What is XSL Transform
(Darla Ferrara) Definition: The ‘transform’ element serves as the root for XSLT documents and is interchangeable with the element ‘stylesheet.’ When you link the XML page to the formatting file, use the ‘stylesheet’ not ‘transform.’
Parallel Processing and Distributed Storage
Parallel Processing and Distributed Storage James points out something I’d like to touch on regarding Parallel Processing and Centralized Data. For this discussion, let consider the following concept that Centralized data doesn’t necessarily mean only a single copy of the data in a single location. Centralized data could mean a single authoritative perspective on data, capable of interacting with that […]
Upgrading SharePoint 2007 to SharePoint 2010: First Steps
(Scott Murray) Your Boss tells you that the budget has been freed up and new capital for upgrades will be available next year. Thus we will be purchasing SQL 2008R2 and SharePoint 2010. He wants you to determine an upgrade plan and any initial tips on performing the upgrade. He wants you to conf
Batch Inserting using Spring JDBC (JdbcTemplate)
(Pas Apicella) In this small example we use the classic JdbcTemplate to complete batch processing with the Oracle JDBC driver. Although we could simply use SimpleJdbcTemplate and write less code this one just seems more natural to me. The code is assuming insertion of new records here.
Anticipating SQL Elapsed Times
(Craig Shallahamer) Many of my postings can be considered quite theoretical. But in this posting I’m going to make a clear application of quantitatively modeling response time and understanding why Oracle systems behave as Operations Research queuing theory state (which was the topic of my previous
Twelve Good Reasons to Use Data Virtualization
(Robert Eve) An IDC research study found that, in 2010, the universe of information exceeded one zettabyte, or one trillion gigabytes, for the first time in history, and is expected to grow another nine fold over the next five years.
Apparently ColdFusion Cannot Handle Chunked Multi-Part Form Data
(Ben Nadel) Last week, I was exploring the use of the Java’s java.net.HttpURLConnection class as a means to stream file data in a form POST without having to buffer the entire file in memory prior to transfer. This worked fine when the entire post consisted of the file data; but, would the same appr
How to Move Data from One Table to Another
(Susan Ibach) I recently saw a post on Stack Overflow asking how do you copy specific table data from one database to another in SQL Server. It struck me I should share the solution to this with others because it is such a handy trick. Often I set up test data and want to quickly copy it to another
HTML5 for ASP.NET Developers
(Peter Vogel) Microsoft’s announcement that HTML5 and JavaScript would be first-class tools for creating ‘Windows 8’ applications created consternation among some .NET developers. Would their investments in XAML and Silverlight be wasted? Would they be forced to work with HTML/JavaScript instead of