Friday, September 21, 2012

Weekly TidBIts (September 21, 2012)

Whoa! It's been a while but I have some neat stuff to share today. SSIS and SSAS/MDX are in the mix along with a special treat if you're "of age."

How to backup SSAS databases using SSIS? from ch1n2 - This article is really helpful for just about any type of XMLA command you want to execute via SSIS, not just backing up databases.

I may have posted about the dtexec Utility before but this is important documentation if you're running SSIS packages from the command line.

Finding and killing SSAS Sessions by Ronen Chenn. Sometimes you gotta be the bad guy.

I took an excellent class on MDX recently and the instructor Dustin Ryan (check out his SQL with Dustin Ryan blog) recommended this great MDX development tool: MDX Studio by Mosha Pasumansky. The tool comes in web-based and desktop flavors though the desktop version is a bit more feature rich. Thank you Dustin and Mosha!

I was looking up the link for that MDX class and noticed that the prices on the classes were lower than I remembered. I don't know if it's permanent or not but classes that used to be $795 are now showing up for only $595. That may sound like a lot of money but when you compare it to a Microsoft class at $3,500 for a five day class ($87.50/hour) your not just saving $11.25/hour (4-day class, 3 hours/day at the $795 rate). You're also saving a few buckets full of cash in travel costs and you can do the labs on you're own time. BTW, the classes I took and can vouch for directly are Pragmatic Master SSAS and SQL Server 2012 for the DBA.

UPDATE: I just got a promotional email from Pragmatic Works that clarifies the pricing change for their online classes. This $200 savings is part of a "Back to School" promotion and will end on September 30, 2012. You can register for any class before that time even if the class is scheduled for a later date. PW was kind enough on one occasion to let me purchase a class in advance that was not scheduled. I cannot say for certain if they are able to do that in conjunction with this promotion so you'll need to contact their sales folks if their current schedule doesn't meet your needs. I do not represent Pragmatic Works in any way nor do I receive any compensation for promoting their services. They're just good folk and I like working with and learning from them.

This last one is just for fun. Please skip this if you're under the legal age to consume alcohol where you live.
Does Beer Go Bad? from the Were You Wondering blog - I don't think I need to explain this one.

No comments:

Post a Comment