Database

SQL Rally Nordic 2013

Posted on

Three days of SQL Server Deep dive and new trends in Stockholm, SE. The sessions have been held and the impression will last a while – at least for me. Day 1 – The precon ‘Data Warehouse modelling – making the right choises’ by Davide Mauri (site|blog|twitter) and Thomas Kejser (blog|twitter) was a very good walktrough of the aspects, seen from a architectural angle, of building a data warehouse.

Database

SQL 2012: Performance monitoring the light and right way

Posted on

Ever had that awesome SQL tracer build up that does just the right thing for your system – well I know that I had. And someday you might need just the same trace again. But now you need to build it again… Here comes the feature Extended Events in place. It was first introduced in the SQL 2008 version. The feature is a good and lightweight event-driven mechanism for collecting information about your SQL server.