PASS Summit 2014 Pre Cons + Wednesday

This year I finally got to say “I am attending PASS Summit”. I have been envious of those who got to attend previous years, and now finally I got to put on the PASS badge.

pass-summit-2014

I have been attending two pre cons, Predictive Analytics in The Enterprise and Agile Data Warehousing : Start to Finish. Both did not, unfortunately, live up to my expectations. Maybe I was just hyping myself, being first timer and all, but I have attended pre cons before, and they were all on a completely different level. Sadly very little take away on both topics.

On Wednesday the Summit really kicked off, and I went to some very good sessions, including Building Hybrid Power BI solutions w/ Rod Colledge [b|l|t], Interactive Data Visualization with Power View w/ Will Thompson neding the day of with Continuous Delivery for Data Warehouses and Marts w/ John Welch [b|l|t]. All of the session were very well executed and obviously hosted by great professionals.

Regarding the community, I have had the pleasure of meeting up with some old acquaintances and meeting new people – always a pleasure and very interesting to hear about problems and solutions that other have solved or are currently facing. Unfortunately I haven’t managed to get much spare time to really go sight seing in Seattle, hopefully I’ll get a chance next year, as the Summit is announced to be hosted here in Seattle again.

 

Posted in Programming | Tagged , | Leave a comment

Power BI Visualization – Hands on

I was very happy to get the news, that I have been selected to speak at Campus Days 2014 in Copenhagen, Denmark. The session will mainly be focusing on how to integrate data into Power Map and Power View, what are the new features and how do I present that to the business… The session level is 200, which means that some prior knowledge about Power Pivot is to be expected, but if your new to it, you would probably be able to tag along.

See abstract here: http://channel9.msdn.com/Events/Microsoft-Campus-Days/Microsoft-Campus-Days-2014/SQL2008

Not sure which day the presentation will be, as the schedule is not yet public. Will update when public.

Posted in Programming | Tagged , , | Leave a comment

Mediterranean Container Vessel Traffic

Currently working on a project, where I as a side kick have been playing with Power Map.

Enjoy todays minute of Power BI Zen :)

m4s0n501
Posted in Programming | Tagged , , | Leave a comment

Filtering SQL Agent Jobs

I suspect that any developer who has been near a SQL Server for more than just a short while, you will be able to recognize a list of SQL Agent jobs that can no longer can be seen in its full extent without having to scroll.
A tip to make it easier for yourself is that you can filter the list.

Just right-click ‘Jobs’ and select Filter->Filter Settings and you’re off.

Looong SQL Agent Job List

Looong SQL Agent Job List

 Then punch in the filtering you’d like to have

SQL Agent Jobs Filter

SQL Agent Jobs Filter

And voila, your list of jobs are filtere to show only the ones you want:

SQL Agent Jobs Filtered

SQL Agent Jobs Filtered

Posted in Programming | Tagged , , | Leave a comment

Microsoft Visual Studio is unable to load this document

This issue has actually been on my TODO list for quite some time. Now I had to go back to an old SSIS package and do some changes, I got reminded of how annoying this bug is.

The scenario is SQL Server Integration Services 2008 R2 combined with loading an Excel file. This should in anyones mind be the perfect match (if any such exists). I mean, both Microsoft products, one tailored to accommodate for the other – what could go wrong?

I turns out, that Business Intelligence Development Studio (BIDS) is unable to open the file, when you have configured a file in a remote localtion. Or so at least is my theory. Below is what fixes the flaw:

Opening the package fails:

SSIS Error Page

View Code to fix error:

SSIS View Code

SSIS View Code

Remove the inner text of the <DTS:PropertyDTS:Name=“ConnectionString”></DTS:Property> in question:

SSIS Code Behind

SSIS Code Behind

This Works, until the next time you save the file. :/

Filed a Microsoft Connect Item: https://connect.microsoft.com/SQLServer/feedback/details/894728/visual-studio-bids-unable-to-load-file-dtsx

Posted in Programming | Tagged , , | Leave a comment