(Simon Greener) This article shows how the rounding of ordinates has a definite benefit in reducing storage costs and that this benefit passes over into performance improvements especially for sdo_geometry objects with a large number of vertices.
Other News
ColdFusion 10 – Script vs. Tags And My Coding Methodology
(Ben Nadel) I have traditionally been a fan of Tag-based ColdFusion programming. I think that tags are superior when it comes to integrating SQL scripting and HTML templating. With ColdFusion 10, however, I’ve needed to resort to Script-based programming as a means to include Closures and Function E
Running Commands Against Your MySQL Databases using PowerShell
(Rob Gravelle) From performing database backups and restores, rollbacks, sanity checks, and even the occasional report generation, there are a lot of tasks that database administrators (DBAs) have to fulfill on a regular basis.
Determine data latency between Publisher and Subscriber in SQL Server Transactional Replication
(Mohammed Moinudheen) I have transactional replication configured in my production environment. It appears the subscriber data is quite far behind from the publisher database. What are the ways we can identify how far behind the subscriber is for replication?
‘I could use a little help here’ or ‘I can do it myself, thank you’ for Cloud Projects
(Buck Woody) Windows Azure allows you to write code in languages within the .NET stack, you can use Java, C++, PHP, NodeJS and others. Code is code – other than keeping things stateless, using a Web or Worker Role in Azure is not all that different from working with an on-premises system.
DB2 10.1 for Linux, UNIX, and Windows announced!!!
(Henrik Loeser) IBM today announced the next version of DB2, DB2 10.1 for Linux, UNIX, and Windows (the press release is here). If you, like I, worked with the new version already as part of the alpha and beta programs, you couldn’t await talking about the great new features. Some of them are listed
RMAN in Oracle SQL Developer
(Jeff Smith) I’ve already violated my oath to never use acronyms with the blog title, so for those that do not know what RMAN is, please go read the DOCS.
XML Processing using XSL with Parameters
(Anish_R) Recently during the development of a consolidated report for a web application we used XML/XSL processing to generate the report which is basically a custom grid generated out of the XSL processing. The screenshot of the user interface is given in the overview section.
Does InnoDB data compression help with short disk space?
(Shinguz) Because we are a bit short off disk space on one of our servers I had the idea to try out the MySQL feature Data Compression for InnoDB. This feature is useful if you have tables with VARCHAR, BLOB or TEXT attributes.
Observer Pattern in .NET
(Udeshika Horanagama) After writing the article of Strategy pattern I thought that it would be useful to write a small article about the Observer pattern. This is a pattern I have been addicted to during my application designs. Specifically I prefer this pattern because it makes the objects very loo