(Sheeri Cabral) Someone asked me what applications were good/bad for MySQL Cluster. As I’ve now actually had experience with a Cluster setup and a real-life application of it, and dug through the manual, I present a few characteristics of applications that will work with Cluster, and why they are so
Other News
The Framework And The Database
(Kenneth Downs) Today’s example deals with a situation of “deep nesting”, where one table has not just a parent, but a grandparent and perhaps a great-grandparent. This case is going to bring into clear light one of the basic realities of writing database applications, which is that the tools and fr
Search Engine Q&A #15: Mirrored backups
(Paul S. Randal) This post is based on one from my old MSDN blog but the topic has come up a few times in recent days so I want to revamp it and re-post.
Justifying Best Practices
Great Whitepaper Available Working with SSIS? If so, check out the white paper we have in the library that talks about how you can use SSIS to do quite a bit more than just an import of your data. Tips, tricks and lot more — learn about why SSIS really does the ETL – Extract, Transport and Load for SQL […]
Developing RESTful Web Services in Perl
(Andrew Sterling Hanenkamp) If you are a web developer and aren’t familiar with the term “REST,” you should know that you regularly work within this software architecture. REST is a term that can describe the interactions that occur between client and server on the World Wide Web. However, as with m
DB2 9 Certification Study Questions: All about indexes
(Roger Sanders) Try your hand at these questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted with permission. Check back each week for more, and try past questions here.
Design for Extensibility
(Miguel A. Castro) Today’s customers demand easier-to-modify and more flexible applications than ever before. In this article, I will show you how to design applications with extensibility points so that they will grow with the clients’ needs as well as provide a way to “swap” functionality in and o
.NET 3.5 Client Product Roadmap
(Scott Guthrie) A few months ago I did a .NET Web Product Roadmap blog post where I outlined some of the product plans we have to build on top of the web development features we’ve shipped with Visual Studio 2008 and .NET 3.5.
How not to do XML
(Armin Ronacher) Imagine for the moment there was a PHP blog software that has the ability to dump the blog posts into some sort of extended RSS 2 feed and import from there later and probably from a different installation. That’s nice, XML is a flexible format and RSS allows extensions via namespac
Are Dataset Extents Really a Performance Problem?
(Troy Coleman) Last week I wrote about the DB2 secondary sliding scale space allocation feature in DB2 V8. DBAs often wonder about the impact of sliding scale allocation on their systems. Specifically, they want to know what the performance hit or CPU cost will be when they let their application run