(Peter Vogel) You tell your client that you have an application with a one-second response time but, possibly, data-integrity issues. Or you tell your client that the application has a five-second response time with rock-solid data integrity. Which application gets turned on and which gets shelved?
Other News
Extending JAXB – Representing Metadata as JSON
(Blaise Doughan) In previous posts I have described the XML mapping document and JSON-binding extensions in EclipseLink JAXB (MOXy). Since MOXy has a JAXB model for its mapping document we were able to eat our own dog food, and now MOXy offers a JSON mapping document.
Using TSA/db2haicu to automate failover – Part 2: How it looks if it goes smoothly
(Ember Crooks) This is my second post in my TSA/db2haicu series. The first porst, Using TSA/db2haicu to automate failover – Part 1: The Preparation, is a must-read before trying anything lined out in this post.
Least discoverable feature: Changing the cube name in the tabular model
(Cathy Dumas) Tabular models have cube names. This is unintuitive – we’re supposed to be done with cubes, right? Well as we have seen in previous AMO and SSIS posts, under the covers tabular models are still composed of cubes, data sources, data source views, dimensions, and measure groups. The cube
Parameterized Reporting Services Reports with Analysis Services as a Data Source
(John Desch) Microsoft Analysis Services is a commonly used data source for Microsoft Reporting Services reports. The combination provides an environment for creating and rendering interactive reports that are highly performant, flexible and rich in functionality.
DB2 10: Faster SQL PL and PL/SQL
(Serge Rielau) In January 2011 I posted Inline SQL PL vs compiled SQL PL.
On queries with many values in the IN clause
(Jørgen Løland) A few customers with rather extreme needs have contacted us about a performance issue with the range optimizer. Our solution to the problem is to introduce a new variable in MySQL 5.6, eq_range_index_dive_limit, which can be used to control whether or not the range optimizer will a)
SharePoint 2010 implementation success rides on strong governance
(Jonathan Gourlay) As the collaborative workplace becomes more complex, SharePoint can be a boon to enterprises of all sizes, enabling users to set up blogs, personal or team sites and a variety of other online venues for business unit and interdepartmental collaboration. But for all of SharePoint’s
Generate XML from SQL Server 2008 and update the database from XML
(CrinaT) My tutorial is going to show the code and steps for creating a Windows Forms application that:
How to Store Date and Time in Separate Columns in SQL Server 2005
(Deepak Sharma) In this article I will explain how to store Date and Time in SQL Server 2005 using a User Defined Type.