(Matthew Millet) RESTful web services have become something of a buzzword in the world of the Internet. Maybe not as popular as cloud, but just as misunderstood by the decision makers who should really be caring.
Other News
SQL Server Database Corruption–Part VIII : The Importance of Backups
(Michael K. Campbell) In Part VII of this series on SQL Server Database corruption we touched upon how backups can be used as an additional means of early detection for corruption – by making sure to validate the checksums of all data being backed up.
Aggregate Functions in SQL
(Mike Chapple) SQL provides the COUNT function to retrieve the number of records in a table that meet given criteria. We can use the COUNT(*) syntax alone to retrieve the number of rows in a table. Alternatively, a WHERE clause can be included to restrict the counting to specific records.
Reclaim space easy in DB2 v9.7 and show off!
(Elder Ribeiro Lira) Video from DB2’s Got Talent 2012 finalist.
DB2 for z/OS: Trading Memory for MIPS (Part 1)
(Robert Catterall) If you are a DB2 for z/OS DBA or systems programmer, chances are that a good bit of what you do is focused on improving the CPU efficiency of your organization’s DB2-accessing application workload.
Managing Data Sources in a PowerPivot Gallery
(Melissa Coates) A quick tip about how to manage data source connections within a SharePoint PowerPivot Gallery.
Things I should have known: fn:doc-available($url)
Sometimes you run across something in a technology or domain that you really should have known long long ago but didn’t. This is one of those things. Thank you to the person who pointed it out to me.
A starter guide to Page Inspector
(Brij Mishra) There is a very exciting tool that was launched by Microsoft with Visual Studio 11 Developers Preview. That is Page Inspector.
Guru Tip: Avoid the HTML5 FOUJUI Experience
(Peter Vogel) As I continue to incorporate more JavaScript into my applications and, especially, as I try to leverage the new JavaScript/HTML 5 technologies, I’m discovering a new problem: It’s now possible for users to see raw, uninitialized HTML in their browser before my JavaScript properly arran
In-memory databases: Oracle TimesTen vs. Sybase ASE
(Mich Talebzadeh) An in-memory database, or IMDB, can be a standalone database management system (DBMS) like Oracle’s TimesTen, or a specific database that is part of a DBMS, like Sybase Adaptive Server Enterprise (ASE).