Archive | Business Intelligence

GreenPlum MPP Tool Review: Navicat For Postgres

I’ve spent a few hours so far working with Navicat for Postgres connected to our GreenPlum MPP (Massively Parallel Processing Database). (pgAdmin continues to iritate me but it’ll be hard for a competitor to supplant the free incumbent). There is definitely some solid functionality here. Pros: Performance – The UI seems to be balzingly fast […]

SQL Server To GreenPlum MPP/Postgres Transition

I’m working with a team building a data warehouse using Pivotal’s GreenPlum MPP (Massively Parallel Processing) database which is based on PostgreSQL. Although, all the data modeling basics transition easily from RDBMS to RDBMS there’s a bit of a learning curve switching tools and syntax. Listed below are some of the items I’ve noted during the […]

SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)

As more and more companies are moving to heterogenous environments with both windows and unix systems the life of the Microsoft SQL Server developer is becoming much more interesting. For our recent data warehouse project I was asked to create a SQL Server 2012 Integration Services (SSIS) ETL package to output a text file for […]

SSRS Subscription Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.

So, when a SQL Server Reporting Services subscription gives you an error message like: “Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.” You know exactly what to do to fix it right? Just fix the so called “configuration error”. Problem solved! Another day another dollar. Am I […]

Change The Owner Of An SSRS Subscription: The Simple Way

So you need to change the owner of an SQL Server Reporting Services subscription? No problema. (Why would you need to change it you might ask? Perhaps because you have deactivated the user account that created the subscription and now “strange things are afoot at the Circle K”, and if you know that reference please […]

Preventing Failed SSRS Subscriptions: Which user created your subscriptions?

Check it out my friends. You need to keep an eye on which accounts are creating your SSRS subscriptions. Why? Because buried inside the ReportServer database (with no way to change it from the front end) SQL Server Reporting Services  is keeping track of this information. And when one of those user’s account is disabled strange […]

Solution! SSIS Error: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender

While running a 2012 SQL Server Integration Services package, the package ended up failing with the following message: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: “Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender”. The quickest and […]

Get The MAX Date From A Cube Using MDX

Here’s the goal: populate a sql variable with the max date from one of the dimensions in a cube. It takes a little bit of unusual code but it’s relatively simple so pay attention! It’s probably important to note this code is assuming you are using a smart key for your date dimension (e.g. the […]

DAX Formulas To Know And Love

PowerPivot this. PowerPivot that. Blah, blah, blah. Sorry folks, I don’t have time to learn your new Excel plugin because I’m writing SQL! I’m hardcore! Well, I finally started using PowerPivot a few days ago and I’m pretty impressed (although I seem to be able to make Excel crash pretty frequently). So I’m starting a […]