(Pinal Dave) In SQL Server Denali, there are three new conversion functions being introduced, namely:
Other News
End to End Security – z/OS Identity Propagation
(Karan Singh, Rogerio Camargo, Simon Dodge, Bob McCormack, Alain Roessle, Martina Schmidt, Ruben Thumbiran and Nigel Williams) This IBM Redbooks publication explores various implementations of Identity Propagation where the Distributed Identity of an end user is passed to z/OS and used to map to a R
Replacing Text Nodes With jQuery
(Ben Nadel) This morning on Twitter, I came across a Tweet from Robert Rawlins (aka. @SirRawlins) asking about replacing text values within a DOM element. He had a situation in which a node contained mixed children; that is, the node contained both element nodes (type 1) and text nodes (type 3).
Integrating Lambda Expressions for Flexible Processing
(Peter Vogel) When you have a method that could do more than one thing, you have two ways to implement the method: Enclose the different processes in If…Then or Select…Case statements, or implement the strategy pattern.
Is group_concat_max_len in bytes or characters?
(Eric Bergen) The manual says bytes but sometimes it is measured in characters. It seems like group_concat_max_len is in bytes when being passed through a temporary table and in characters otherwise. This works fine when using latin1 but when converting to utf8 mysql must reserve 3 bytes per charact
Conversation between Databases in SQL Server – Service Broker
(Paresh Prajapati) Recently I have posted for Service Broker for single database in which i have explained it with table history example and it was invoked within trigger. It was a for single database, here i will explain service broker for between databases. In earlier post of service broker with s
Calculating total of all MM:SS
(Vadivel) Yesterday in a forum I found a question asking for a way to calculate the total of MM:SS in SQL Server. More over that column is being maintained as a “Varchar” type!!
What is XSL Template
(Darla Ferrara) Definition: A template is a reusable set of formatting instructions meant to present data from an XML file. XSL templates contain rules for a specified node within the document. Node identification comes via a XPath expression such as ‘match.’
IBM Cognos Proven Practices: Improving IBM Cognos Report Studio Master Detail Report Performance
(Daniel Wagemann, George Xu and Henk Cazemier) This document describes an IBM Cognos Report Studio report design technique that can be used for master-detail style reports running against a relational data source.
Parallel Wrapup
SelecTViews With Stephen Wynkoop Today you’re in for a treat as Stephen interviews Kalen Delaney, author of SQL Server 2008 Internals. Of course there is a lot more…Watch the Show Parallel Wrapup Our readers have submitted a number of good insights and suggestions for parallel processing. Today we’ll wrap up this particular topic with those comments. Michael: Since 25. August […]