Categories
Business Intelligence Geeky/Programming SQLServerPedia Syndication

SSASUtils: SQL Server Analysis Services Utilities – CodePlex

So, today I decided to try out Microsoft’s site: CodePlex. I recently created a utility app to process dimensions and partitions in SSAS (SQL Server Analysis Services) because I didn’t like the way it worked in SSMS (SQL Server Management Studio). I don’t know because I never used it, but I guess in pre-SP2 you could process multiple objects at the same time, just hit process, move on to the next one. In SP2, the process dialog is modal so you can get around it, you have to wait for the object to process – yuck!

Also, I just wanted to try out CodePlex and see how it works, what I like and don’t like. Since becoming a contractor doing Data Warehousing and BI stuff, I miss coding in .NET (and any other language), so I want to keep that up in my free time. This is a result of that. Hopefully once I get used to CodePlex I will contribute to some other Open Source .NET Projects, sounds like fun to me!

Here is the link to the project: http://www.codeplex.com/SSASUtils

Some of the glue code for connecting and processing I gleamed from other examples and projects I have seen around the web, some in VB.net , some that didn’t even work, etc. Hopefully more SSAS Utils can be added to this project and it can become way more useful that it is now (although I do use it pretty much every day right now).

CodePlex: I like it so far. There are few things that could be done better, but I am using the Team Explorer source control which fits nicely into VS2005, really cool. I will probably post up more on CodePlex later. If I get the urge, I might create project for some other stuff I have lingering around my hard drive (FFMC, PocketBlogger, other random utils). I am anxious to see what the community participation is like, I tired GotDotNet back in the day and it was weak, we will see with CodePlex.

Technorati tags: , , , , , , , , , , , , , ,
Categories
Life

311 and Matisyahu – Portland (Edgefield) OR – McMenamins

Last night we went to McMenamins in Edgefield for 311 featuring special guest Matisyahu. First off, 311 is my FAVORITE band! And they rocked. Matisyahu was OK, more background noise than anything, but he sounded good.

The real cool thing was the venue itself. Unlike in MN at the Xcel or Target center, this was a McMenamins, which is like all over Oregon, Portland especially. But it was outside, and McMenamins has food, beer, wine and all that. Just a really nice venue, places to sit and eat, etc. And then after the show, you can just go to one of the many bars/restaurants they have on their “campus” and chill, very cool.

Have some pictures up here:

P1000945

http://flickr.com/photos/scaleovenstove/sets/72157601743630162/

Technorati tags: , , , , , ,
Categories
Life

Day Tripper: Oregon Coast – Cape Lookout

Headed out the coast today. Cape Lookout, by Tillamook, OR. Walked the Cape Trail peninsula. Nice views.

Some pictures here:

P1000923

http://www.flickr.com/photos/scaleovenstove/sets/72157601684307712/

Technorati tags: , ,
Categories
Life Product Reviews

Music Millennium on 23rd and Johnson: Going out of Business

Was walking 23rd today, Music Millennium is going out of business at the end of the month, so I decided to stop by. Tons of music, all discounted. I picked up a goofy cover cd – Butchering the Beatles – metal covers of The Beatles. Anyone who is in PDX should check out MM before the close down, good deals!

Technorati tags: , , , , , ,
Categories
Business Intelligence Geeky/Programming Product Reviews SQLServerPedia Syndication

Reporting Services Scripter: Sync Reporting Services Instances and Objects

The other day, I was tasked with moving all objects from one SQL Server Reporting Services instance to another. I know you can move the database itself, but then you run into issues with encryption keys etc. I just wanted to move the objects. I know that pretty much everything in SSRS is extensible, so I knew I could write something to do it, but before I went out and coded it, I Googled first to see if someone else had something. Turns out there is an awesome utility: Reporting Services Scripter. Works like a charm!

Technorati tags: , , ,
Categories
Random

Are you stuck in an infinite loop?

image

let me know when you find the answer..

Technorati tags: ,
Categories
Life

Burnside: The Movie

As some of you might know, I live on W. Burnside St in Portland, OR

Yesterday I stumbled on a site promoting a movie of the name “Burnside”  http://www.myspace.com/burnsidemovie

I watched the trailers, it is shot in Portland, about the trials and tribulations of some people that roam on Burnside St. Pretty cool to have the street you walk up and down every day in a movie 🙂

Thing is, I don’t know where to find a showing of it, or watch the whole movie, which I would love to see it. If anyone knows or knows where to get a copy, let me know

Technorati tags: , , , , ,
Categories
Life

Congratulations Aaron and Angie

Aaron and Angie finally had their baby. Congratulations!… Who is next…

Technorati tags: , ,
Categories
Geeky/Programming Product Reviews Random

Facebook: Signing up can be tough if..

Your last name is “Gay”

I asked a buddy of mine, Joe Gay (yes that is his name), “why aren’t you on Facebook yet”, and his response was, “They won’t let me sign up, they won’t allow my last name”

What gives? That is his name, they should allow it. He shouldn’t have to email customer support to sign up.

So, what do we do? Put Gaaay instead Gay. That gets through. But in the process, accidentally picked the wrong year for his birthday.

Now, what is even better, is that you can’t update your name or birth year once you are logged in. Well not easily anyways. From the help page

Did you misspell your own name? Are you tired of that embarrassing nickname? You can request a change from the “Settings” tab on the Account page. For quality control purposes, we confirm all name changes before they take place.

But I suppose they will get bucky again about his last name

Same thing with the birth year

You can edit the month and day of your birth from the “Basic” tab of the Edit My Profile page. For security reasons, Facebook Customer Support reviews all requests for edits to your birth year. To submit a request, click here.

Facebook really should let users edit this information, instead of them having to send an email off to customer support, it just doesn’t make much sense.

Technorati tags: , , , , ,
Categories
Geeky/Programming Random

Route: Saturday Night Programming after the bars..

OK, I have to admit, this is weak. But, if you want to learn how to create an infinite loop, with one word, this is it. Route.

I happened upon this maybe 5-6 years ago, when we ended up having to set static routes on computers because of some goofy office politics, but anyways..

Create a batch file. Name it route.bat. Edit it, type in the word route. save, exit, and run it. Infinite loop.

image

Fun stuff. Not bad for an after the bar exercise..

Technorati tags: , , , ,