Learn for Life!

SSAS Cubes – Dynamic generation of partition


There is no easy way to generate partition for SSAS Cubes by default. So you have to do a SSIS-Package  (here is a way you can do it dynamic-cube-partitioning-in-ssas-2008) or write a SQL Script which generates XMLA executables.

As shown in the Statement, you can dynamically generate month partitions. The trick is, to create a linked server, that you can execute XMLA statements with relational T-SQL, so i created a Linked Server first.

Thanks for any advice or improvements in the comment section:
[crayon-59c3c5b3eaf7a476727400/]
 

 

 … Read more

There is no easy way to generate partition for SSAS Cubes by default. So you have to do a SSIS-Package  (here is a way you can do it dynamic-cube-partitioning-in-ssas-2008) or write a SQL Script which generates XMLA executables.

As shown in the Statement, you can dynamically generate month partitions. The trick is, to create a linked server, that you can execute XMLA statements with relational T-SQL, so i created a Linked Server first.

Thanks for any advice or improvements in the comment section:

 

 

 …

Read more

The Reality of a developer’s life…


How true these pictures are 🙂 :

http://sharepointspot.blogspot.ch/2013/04/the-reality-of-developers-life.html

When you upload something to the production environment:


When I show my boss that I’ve fixed a bug:
… Read more

How true these pictures are 🙂 :

http://sharepointspot.blogspot.ch/2013/04/the-reality-of-developers-life.html

When you upload something to the production environment:

When I show my boss that I’ve fixed a bug:

Read more

Need any Headphones?


They are not cheap, but they are best! This are the new technology of headphones. They do have an active noice canceling in it. So you will not hear (or almost not) the monotonous sounds of trams, train, flight or even talking from other peoples. If you are traveling a lot or working in a shared room with more than 5 people, you have to buy them, you won’t regret it!!

I have the old one, the Bose QuietComfort 15, but I think the 25 series is even better, but not worser I hope :-).

Try it or ask me in the comment section, I will love to answer your questions.

Link zu Bose – QuietComfort 25bose quietcomfort 15

 … Read more

They are not cheap, but they are best! This are the new technology of headphones. They do have an active noice canceling in it. So you will not hear (or almost not) the monotonous sounds of trams, train, flight or even talking from other peoples. If you are traveling a lot or working in a shared room with more than 5 people, you have to buy them, you won’t regret it!!

I have the old one, the Bose QuietComfort 15, but I think the 25 series is even better, but not worser I hope :-).

Try it or ask me in the comment section, I will love to answer your questions.

Link zu Bose – QuietComfort 25bose quietcomfort 15

 …

Read more

Do you listen to music while working?


If yes, there is one best thing I used for the last time. If you listen to music while you working or study, this makes you focus on the work:

https://www.focusatwill.com/

It is a music player with neuroscience based music channels, which dosen’t disturb you.

Some advertising from their website:

Stop the wrong music.
50% of us play background music while studying, working or inventing. But…it’s the wrong music! Mainstream music lowers comprehension and creates distraction because it is designed to connect with you intellectually and emotionally.

Use the right music!
Focus@will technology delivers various “Attention Amplifying” music channels scientifically designed to engage with your brain’s limbic system. This soothes the easily distracted fight or flight mechanism increasing attention span and general focus.

The science behind this.
We developed this in partnership with leading neuroscientists Dr. Evian Gordon (www.brainresource.com) and Dr. Stephen Sideroff (UCLA Professor of Psychology). Trials show typical 12-15% positive increase in focus biomarker and up to… Read more

If yes, there is one best thing I used for the last time. If you listen to music while you working or study, this makes you focus on the work:

https://www.focusatwill.com/

It is a music player with neuroscience based music channels, which dosen’t disturb you.

Some advertising from their website:

Stop the wrong music.
50% of us play background music while studying, working or inventing. But…it’s the wrong music! Mainstream music lowers comprehension and creates distraction because it is designed to connect with you intellectually and emotionally.

Use the right music!
Focus@will technology delivers various “Attention Amplifying” music channels scientifically designed to engage with your brain’s limbic system. This soothes the easily distracted fight or flight mechanism increasing attention span and general focus.

The science behind this.
We developed this in partnership with leading neuroscientists Dr. Evian Gordon (www.brainresource.com) and Dr. Stephen Sideroff (UCLA Professor of Psychology). Trials show typical 12-15% positive increase in focus biomarker and up to…

Read more

Annoying advertising, what you can do


Recently I was asked what I do against advertising on websites. I was a bit confused at first because I didn’t have that problem the last 2-3 years I think. This is when I started to use Adblockers on my browsers to get rid of this annoying advertising or flashing everywhere on the page what distract you from the essential on the page.

So I recommend to use Adblockers as soon as possible and you will look confused as I when you hear about advertising on web pages the next time because there isn’t anymore.

These are two I use:

	https://adblockplus.org/
	https://getadblock.com/

Or if you want to compare more of them, follow this link on comparitech.com… Read more

Recently I was asked what I do against advertising on websites. I was a bit confused at first because I didn’t have that problem the last 2-3 years I think. This is when I started to use Adblockers on my browsers to get rid of this annoying advertising or flashing everywhere on the page what distract you from the essential on the page.

So I recommend to use Adblockers as soon as possible and you will look confused as I when you hear about advertising on web pages the next time because there isn’t anymore.

These are two I use:

https://adblockplus.org/
https://getadblock.com/

Or if you want to compare more of them, follow this link on comparitech.com…

Read more

ORDER BY Oracle vs. Microsoft SQL


Like you would think ORDER BY is the same in Oracle as in the Microsoft environment, it isn’t. It depends on the Collation of the database. In the following example you see, that two manually added text in Oracle and Microsoft don’t order the same. After I added the Collation for SQL_Latin1_General_CP850_BIN2, it ordered the same.

ORDER BY Oracle:



 

ORDER BY Microsoft – normal and with collation:



 … Read more

Like you would think ORDER BY is the same in Oracle as in the Microsoft environment, it isn’t. It depends on the Collation of the database. In the following example you see, that two manually added text in Oracle and Microsoft don’t order the same. After I added the Collation for SQL_Latin1_General_CP850_BIN2, it ordered the same.

ORDER BY Oracle:

 

ORDER BY Microsoft – normal and with collation:

 …

Read more