(Bonnie Baker) If you’re a programmer and you want to manipulate data, you write a program. But in some cases, that may not be the best option. DB2 has several utilities that can save you time—and using them instead of program code can help you improve system availability and performance. Running ut
Other News
Configuring SQL Server to Use Multiple Ports
(Jugal Shah) Recently I came across a situation where an existing production SQL Server default instance was configured to use static TCP/IP port 48030 and the default 1433 port was disabled. A number of database applications are hosted on the same default SQL instance and these applications are con
Will JSON Replace XML?
Will JSON Replace XML? JavaScript Object Notation (JSON) is a technique for passing structured data across processes in the form of a string. This technique results in the ability to pass JSON data across network protocols that prefer string traffic, such as HTTP. Data can be serialized into a JSON string much the same as XML. The key difference is […]
Covering Index vs. Indexed View
Covering Index vs. Indexed View A covering index and an Indexed View are two different techniques for solving the same problem; performance needed when retrieving data from an table or view that has too much overhead for retrieving a subset of the possible data. Both techniques operate as a virtual table if they contain the necessary data required by queries. […]
DB2 Temporal Data: Three More Reasons the Ultimate Server, z/OS, Leads the Industry
(Dave Beulke) Having just designed and implemented a 22-billion-row data warehouse on DB2 z/OS I have seen first-hand the incredible performance of DB2 Version 9 with a z/10 configuration take report processes from 37 hours to minutes or sub-second response time.
Migration Month – DB2 10 Overview, Get Ready to Plan your Migration!
(Laura) Last week Triton Consulting & IBM hosted a webcast on DB2 10 Migration Planning. Look out for the replay coming soon. In the meantime you can view the presentation below:
UMBEL Services, Part 2: Full-text, Faceted Search
(Mike Bergman) This continues our series on the new UMBEL portal. UMBEL, the Upper Mapping and Binding Exchange Layer, is an upper ontology of about 28,000 reference concepts and a vocabulary designed for domain ontologies and ontology mapping [1]. This part focuses on the search function within the
Building a SharePoint advanced search application with Silverlight 4
(Corey Roth) At SharePoint Conference 2011, I showed off a great looking advanced search application using Silverlight 4. This application queried the Search web service at /_vti_bin/search.asmx to retrieve results and display them directly inside the application. A couple of years ago, I demonstr
Analyzing social media data beyond the simple trends
(XML Aficionado) Using the iPhone 4S vs. Galaxy Nexus announcements as an example, we use the Twitter Search API with MapForce to extract deeper insight from social media interactions.
Working with the XML Data Type in SQL Server
(Robert Sheldon) Not all SQL Server data types are created equal. Just look at the XML data type. On the surface, it might seem like your run-of-the-mill type, except, of course, being geared toward XML data; but the ways in which it’s used, how its data is queried, and when and how XML columns shou