I came across a colleague of mine, who asked me if the new updatable columnstore index and ROLAP partitions in a Multidimensional cube is the new trend of fast and no-latency Business Intelligence. Well – here is my 25 cents. I’ll start with the updatable columnstore indexes. With SQL Server 2014 Microsoft introduces updatable columnstore indexes. Which in short terms defines that the columnstore no longer has to be dropped/disabled when loading data to the table.
One of my longterm customers had a database-server crash a while ago. The server would not spin up after reboot. The SSISDB crash also gave problems. 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… SSISDB crash The development of SSIS project to maintain the BI sollution had to be deployed to the SSISDB catalog.
Statistically it happens some time for all of us with a website – and today was my ‘lucky day’ when I got my blog hacked. Got a mail from my hosting-company telling me that my WordPress blog has gotten hacked and was disabled untill I changed all access-codes and made a full-re-install of the binaries. Luckily I’ve got backups of everything – so nothing was lost. Everything is a-ok now – and I hope it does not happen again.
Three days of SQL Server Deep dive at SQL Rally Nordic 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.
In every project on Business Intelligence there comes a time when the code needs to be deplyed to the production environment. No more development, no more manual work. It is time for dynamic partitioning. But what about the partitions on the tabular cube? Do we really need to tell and learn the DBA how to handle that on a periodic plan? The answer is simple: No! Thanks to the XMLA language, the DMV’s for SSAS instances (both tabular og multidimensionel) and SSIS we can do the partitioning dynamic based on the current data in the datawarehouse.
I got it! The title of MCSE Business Intelligence. My, for now, last test was 70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012. I can now call myself MSCE. The last two tests: 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012 70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012 They were not that hard compared to the first 3 to become MSCA.
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.
Ever had that awesome SQL tracer build up that does just the right thing for your system to do some performance monitoring – 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.
Ever wondered how to do dynamic picture alignment in SQL Reporting Services? I have for sure needed it often. Until now I’ve always 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.
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 formatting you needed in SQL. I know I have. I SQL 2012 this is no longer such a headache 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.