(Jørgen Løland) A short while after I fixed the legacy bug that prevented temporary MyISAM tables from using the dynamic record format, I got an email from Davi Arnaut @ Twitter. It turned out that Twitter needed to fix the very same problem, but for the case when INFORMATION_SCHEMA temporary tables
Other News
Business process optimization, Part 1: Planning for sustained agility and business outcomes
(Ali Arsanjani, Kerrie Holley, Jean Pommier, Claus Torp Jensen, Samuel Antoun and Julian Petriuc) This article explores commonly held concepts behind business performance and agility, and illustrates at a practical level how to extend these into new and innovative ways of measuring, achieving and su
Troubleshooting SQL Server 2008 Installation on Windows Server 2008 R2
(Sadequl Hussain) When installing SQL Server 2008 on a Windows Server 2008 R2 system, you may get the following message: “You must use the Role Management Tool to install or configure Microsoft .NET Framework 3.5 SP1”. Following that, another error message pops up: “Microsoft .NET 3.5 installation h
SQL*Plus Variable defined by default
(Vishal Gupta) Earlier i used to maintain different sql script files for one function for every database version. As some of the older release dont have some of columns available in new release’s view/tables. I started updating my scripts to maintain a single script using Tanel Poder’s snapper scri
Deprecated: Such a cool word yet a word so misunderstood
(Willie Favero) I wanted to talk about the DSNZPARM keys deprecated in DB2 10. And yes I do realize that I listed them out in a previous post. However, this time I wanted to discuss why it’s important today, maybe even before migrating to DB2 10, to plan on how their eventual departure from DB2 ma
A Better Understanding Of MVC (Model-View-Controller) Thanks To Steven Neiland
(Ben Nadel) In my web applications development, I use and love ColdFusion components! However, my use of them is definitely sub-optimal. My approach makes use of a two-tier model consisting of what might loosely be thought of as a Controller and a Gateway layer.
A scheduler GUI for SQL Server Agent
(Alberto Venditti) Imagine you have some predefined SQL Server jobs and you want to give your users the ability to schedule them as they wish.
Moving Tags in DOM Using jQuery
(Abhimanyu Kumar Vatsa) In this quick article you will learn how to move any tag in the DOM using jQuery. I will first show you a problem and then I will explain its fixes. Here’s a problem:
Ten things to remember about MySQL backups
(Sean Hull) Hot backups are an excellent way to backup MySQL. They can run without blocking your application, and save tons on restore time. Percona’s xtrabackup tool is a great way to do this. We wrote a howto on using xtrabackup for hotbackups.
New Case Study: Automating XBRL Data Collection and Processing
(Beth O’Brien) Case studies are a great way to see how other organizations use Altova technologies to develop unique projects that meet their business goals. We’re often asked, however, what comes next. Did the project take off? Has it grown since the case study was published?