This weekend saw the eighth SQLBits conference take place in Brighton. Alex Whittles from Purple Frog presented two technical sessions at the conference, one on using DMVs and spatial data to visualise star schemas and the BUS matrix to automate OLAP cube documentation, and one for a bit of fun, drawing pictures using SQL Server spatial queries.

The sessions were recorded so should be available to watch in the near future, in the meantime here’s a quick two minute summary of each session.

OLAP Cube documentation using DMVs and spatial data

Drawing pictures with SQL Server spatial data