Database

SSISDB crash – Certificate, asymmetric key or private key data invalid

Posted on

One of my longterm customers had a database-server crash a while ago. The server would not spin up after reboot. The whole installation including tweeks and other stuff had to be re-attached to a new and fresh installation of SQL Server 2012. It was s fairly young BI-server, so the damage was not that big after all. Untill today…

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

Prep for MCSA: SQL Server 2012

Posted on

Ready, Steady, GO!! Today I’ve just passed the last certification on the road to MCSA: SQL Server 2012. GREAT!! What a journey and what a huge pile of books, blog-links and other stuff. The usual training kits from Microsoft Press has been read and been the base for further reading and study. A few days ago Microsoft launched their youtube channel with 3 very good videos regarding the path to MCSA: SQL Server 2012. It brings one 1 hour 15 mins long video for all three certifications. 70-461: Querying SQL Server 2012 70-462: Administering SQL Server 2012 70-463: Implementing Datawarehouse […]

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.

Database

Performance issue using formatting in MDX

Posted on

To make a long story short – Do not use formatting in MDX when using results for Reporting Services. Here’s a little tip for all who works with MDX and gets stuck on the performance. Sometimes when you work on MDX queries the performance is very slow. This even though the resultset is only a few rows. (I know that the dataintegrity also is a role player here…). But but, I’ve come up with a little finding. If you have used formatting directly in your MDX query in order to get the whole thing done from the SSAS servers power, […]

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 […]

Database

Will not get stuck in date formatting again

Posted on

You’ve all been there, you’ve all banged your head against the monitor just because you could not remember that code for the specific date-format you needed. I know I have. I SQL 2012 this is no longer such a headake to remember all those codes – JAY! Ex. from SQL 2008 R2 and older: SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY] –Italian SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY] –German SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY] –USA And with the codes specific for each country format needed.   Now in SQL 2012 we are all free to try to memorize those codes […]