(Vishal Nayan) SQL server provides list of many predefined functions that are built in to the T-SQL language. The supplied functions helps extend the capabilities of T-SQL, providing the ability to perform string manipulation, mathematical calculations, data type conversion etc. but often we need s
Other News
Configure and monitor MicroStrategy applications with Optim Performance Manager Extended Insight
(Holger Karn and Ute Baumbach) Optim Performance Manager Extended Edition provides end-to-end database transaction response time monitoring capability for MicroStrategy applications with its Extended Insight capability.
How do you create a cross tab report using a SSAS OLAP cube
(Vamsi Bogullu) I have a need use a few different rating methods to classify my customers as Great, Very Good, Good, etc. We are using SQL Server Analysis Services and I have heard you can create a cross tab report between two members on a same dimension of a SSAS cube? Do you have any suggestions
Are You on Auto-Pilot… and Should You Be?
Have you seen the latest show? (It’s free) SelecTViews – Interview with Kalen Delaney, author of SQL Server 2008 Internals. We also have news about Hitachi Data Systems purchase of BlueArc, the upcoming PASS Summit 2011 and more. [Watch the Show] Are You on Auto-Pilot… and Should You Be? In our upcoming show I get to talk about getting back […]
What is the Semantic Web?
Currently the focus of a W3C working group, the Semantic Web vision was conceived by Tim Berners-Lee, the inventor of the World Wide Web. The World Wide Web changed the way we communicate, the way we do business, the way we seek information and entertainment – the very way most of us live our daily
XML Declarative Programming
(Roger L. Costello) In Essential XML (Chapter 5.1, p. 87), Aaron Skonnard and Martin Gudgin say that using XSLT template rules is declarative programming:
On SOA infrastructure – Tips from TSSJS presenter Jeff Genender part two
(Colleen Frye) Jeff Genender is CTO and chief architect at Savoir Technologies Inc., a consulting, training and support company offering open source solutions. He is an active committer and Project Management Committee (PMC) member for Apache Geronimo, a ‘committer’ on OpenTerracotta, OpenEJB, Servi
How to call a Stored Procedure for each record in a table
(Vadivel) Without using Cursors how to call a stored procedure for each record in a table? This was a question asked in a forum yesterday. I come up with an alternate WHILE loop logic which is shown below:
Outer Join Queries
(Hemant K Chitale) Outer Join queries are difficult to understand initially. Effectively, an Outer Join query allows the developer to create dummy rows (with NULLs for the returned columns) for a table when a join to another table would fail. Thus, the developer can see rows in the other table for w
Free JTS-based Area/Length Functions
(Simon Greener) One way of providing an area and length capability for Oracle 10g that is free from licensing issues is to use Java Topology Suite’s (JTS) GetArea() and GetLength() functions.