Tuesday 19 June 2007

SQL Server User Group : Analysis Services and Many 2 Many

Good presentation by Analysis Services aficionado Darren Gosbell at this evenings SQL User Group meeting. ApplauseNot worthyApplause

The presentation covered many to many relationships in Analysis Services. Many to many relationships have been around in the relational DBMS arena for many a year, but it's only been with the 2005 release that it's been possible in Analysis Services.

One of these days I might get around to putting some of my meager Analysis Services skills into practice ... one day ... in my spare time ... Surprised

Quote of the Day:
The company's most urgent task is to learn to welcome, beg for, demand - innovation from everyone
--Tom Peters

In case you're wondering what all the emoticons and "Quote..." stuff is about, I'm playing with the latest release of Windows Live Writer. Looks pretty cool so far, but I don't think it'll take pride of place before Outlook or my mobile phone as my blogging tool of choice. It's far too easy in the other tools.

Monday 18 June 2007

Something every guy loves ... Gadgets!!


Really cool discussion over here ) at SQLServerCentral about gadgets.

My favourites are,
Surface Computing - http://link.brightcove.com/services/link/bcpid932579976/bclid932553050/bctid933742930
The Tesla Roadster - http://www.teslamotors.com/

Just goes to prove that it's not all about the Database ;)


Friday 15 June 2007

Split function

Another script that I'm forever tracking down.


CREATE FUNCTION [dbo].[fn_Split] (
@arr AS VARCHAR(MAX)
, @sep AS CHAR(1)
)
RETURNS TABLE
AS
RETURN


SELECT n - Len(REPLACE(LEFT(@arr,n),@sep,'')) + 1 AS pos
,CAST(Substring(@arr,n,Charindex(@sep,@arr + @sep,n) - n) AS INT) AS Element
FROM (SELECT @arr AS arr) AS a
JOIN dbo.nums
ON n <= Len(@arr)
AND Substring(@sep + @arr,n,1) = @sep