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

Picture alignment in SQL Reporting Services

Posted on

Ever wondered how to dynamic align pictures in SQL Server Reporting Services? I have for sure needed it often. Untill now I’ve allways answered no to requests for this. The solution can be used when creating reports in SQL Server Reporting Services with dynamic pictures in different sizes based on variables inside the report. In this article the pictures will be aligned right and these are stored in a FileTable on a SQL 2012 instance – you can also do this with other types of picture storage in Reporting Services. Well here it goes: For starters you’ll need a parameter to hold […]