(Shhh…. the SQL Server Virtual Conference for June has soft-launched…) Webcast Today Data Protection and Recovery Options with SQL Server We’ll look into the various data protection options you have with SQL Server when it comes to setting up a recovery system for your server. We’ll explain the pros and cons of each and where you can apply them in […]
Other News
APAR Friday: A few fixes for Optimizaiton Service Center and Optimzation Expert
(Willie Favero) Today’s the focus is on OSC and OE. There were a couple of fixes published this week that could be interesting if you are a fan (or user (or both)) of these tools.
Generating Java using XSLT
(Oleg Tkachenko) We are working on yet another language migration tool and faced once again Java source code generation problem. Unfortunately Java doesn’t have anything similar to .NET’s CodeDOM, so we had to build own own Java generator. This time our development platform is XSLT 2.0. Yes, we are
Addressing Doubts about REST
(Stefan Tilkov) Invariably, learning about REST means that you’ll end up wondering just how applicable the concept really is for your specific scenario. And given that you’re probably used to entirely different architectural approaches, it’s only natural that you start doubting whether REST, or rath
Hash_Value, Plan_Hash_value and other CBO Queries…
(Vivek Sharma) Sometime back, I received a mail from one of a Regular reader of my blogs and fortunately happens to be known to me. Though I replied to his mail, but thought of posting this, as the queries he raised seems to be interesting and worth writing a blog on it.
Evolving your XML schemas using DB2 pureXML
(Khurram Faraaz, Ronny Bartsch and Susan Malaika) In many systems that use XML, the XML schemas will evolve over time. In this article, you’ll learn how to handle those changes using DB2 pureXML Schema Registry (XSR) features, whether they are major or minor, and walk through an example of schema ev
XML processing in Ajax, Part 3: JSON and avoiding proxies
(Mark Pruett) Ajax-style server calls don’t necessarily require XMLHttp requests. This last installment of the series uses a public Web service, JavaScript Object Notation (JSON), and dynamic script tags in a final approach to the weather badge project.
The real difference between SQL Server and Oracle
(Sean McCown) For years now there’s been a constant war between MS supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that’s not really where the real importance lies. Sure, functionality is a part of it because your DB should be able to do what you
Store Indexes In A Larger Block Tablespace: The Multiblock Read Myth Part II (The Fly)
(Richard Foote) Thought I might begin by mentioning a lovely little story by Billy Verreynne in this OTN Forum Thread. Basically a scientist is doing research on the behaviour of flies. He notes when he opens the jar lid of a trapped fly and claps his hands, the fly takes off and flies away. One
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
(George Baklarz and Paul C. Zikopoulos) In this chapter you will be introduced to the DB2 family of products that run on the Linux, UNIX, and Windows operating systems. This version of DB2 is often referred to as the distributed version to differentiate it from the DB2 for z/OS version that runs on