October 2010 - Posts

What, a database professional of some 24 years organising a NoSQL event? Yes, well, I think its an important emerging technical area we need to know about. Databases can't do everything (at the moment). People who know me will affirm my religion regarding using commodity kit.


The first NoSQL (Not only SQL) developer day will take place at the University of Dundee on Saturday 20th Nov (http://developerdeveloperdeveloper.com/nosql1/). Come and join other developers and database professionals and learn more about this emerging technology area. Seven sessions across the day covering VoltDB, Hadoop and HBase, Windows Azure, Cassandra and Hector, CouchDB, RavenDB and a session on is NoSQL the future of data storage.

Sponsored by the University of Dundee and NCR.

The code for the demo's I talked through at the Edinburgh SQL Server User Group can be found here: http://sqlblogcasts.com/blogs/tonyrogerson/UKSSUG/UG20101007%20-%20Hierarchies.zip

I explain recursive CTE's. 

I show how to do an adjacency list (parent/child) in SQL using recursive CTE's.

Materialised Path in SQL.


Point in time hierarchy.



The technique of Recency Frequency Intensity/Monetary is a powerful analytical technique for identifying data patterns and business performance. An introduction to the technique will be given, however the main focus of the session will be on demonstrating on how RFI/M can be performed using a number of SQL features such as Data Windowing, the OVER clause and PARTITION BY, CROSS APPLY and Common Table Expressions and how you can nest the table expressions. The session should be of benefit to both inexperienced and experienced SQL coders and analysts, each construct will be explained as well as the query plans produced. Demo's will be done on AdventureWorks which we actually discover is going out of business!

Feel free to email me with any quesitons, comments and suggestions - tonyrogerson@torver.net