(Troy Coleman) In order to understand why PureXML is so important to your business, you need to first understand what XML is and where the industry is going with it. If you’re a Java developer on UNIX or Windows, then you probably already know all about XML. However, XML use is relatively new on th
Other News
Experience lags adoption: Why Oracle and SQL DBAs probably want to learn MySQL
(Paul Vallee) There’s an interesting dynamic going on right now in the DBA world. MySQL’s growth and installed base, as a function of its size three or five years ago, is perhaps five if not ten times larger than it was. In 2002 when Pythian’s MySQL services launched, we took on the platform at the
SQL Performance Analyzer (SPA) Part – 2
(Virag Sharma) Case: – You want to adjust some parameters in production and you want to check how over all application going to run i.e. is SQL performance improved or it degrade ? <!–[endif]–>
Wait Handles
(Jim Mischel) With the exception of interlocked operations, the synchronization primitives we’ve discussed to this point are native to .NET, and work only within a single application domain. Monitor and ReaderWriterLock are simple and effective, and in most .NET programs make up the majority of the
Cross-browser XML and JavaScript
(Alex Netkachov) During my work on XML Serializer I ran into the problem with differences with XML support in browsers.
The Fastest Reorganization Is No Reorganization
(Peter Plevka) With the number and size of DB2 database objects continually growing and the requirements of availability getting tougher every month, it is imperative to plan the reorganization of tables and indexes. This article examines options to consider for reorganization and automation, and it
Oracle SOA Suite: further Build and Deployment Automation for Enterprise Service Bus components
(Sjoerd Michels) Some time ago I wrote an article on SOA Suite Build, Deployment and Test Automation. A section of the article was devoted to automating builds and deployments for Oracle Enterprise Service Bus (ESB) components. Not covered was deployment of Services to multiple environments as is us
Database replication lag
(Dries Buytaert) As explained in an earlier blog post, we recently started using MySQL master-slave replication on drupal.org in order to provide the scalability necessary to accommodate our growing demands. With one or more replicas of our database, we can instruct Drupal to distribute or load bala
Exposing LINQ to SQL entities through a POX service in VS 2008
(Kevin Hoffman) I recently got to dig into LINQ to SQL for a little while. I’d been spending a lot of time with Astoria and LINQ to Entities, but as we know – Astoria and the Entity Framework don’t currently work on VS 2008 Beta 2, so the only choice left when Astoria is missing is to write an .asmx
Write custom trace files in TSQL
(Tim Chapman) SQL Server 2005’s default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the default captures are not what you need. Here are instructions for how you can create your