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… Continue reading GreenPlum MPP Tool Review: Navicat For Postgres
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… Continue reading SQL Server To GreenPlum MPP/Postgres Transition
If you're trying to export data in Windows to a UTF-8 format you may be wondering which code page you should use. Well the riddle is solved. Code Page 65001 is the equivalent of UTF-8. If you need to create an SSIS package to export data as UTF-8 for consumption by a unix system you should… Continue reading Which code page for UTF-8?
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… Continue reading SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)
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… Continue reading SSRS Subscription Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.
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… Continue reading Change The Owner Of An SSRS Subscription: The Simple Way
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… Continue reading Preventing Failed SSRS Subscriptions: Which user created your subscriptions?
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… Continue reading Solution! SSIS Error: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender
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… Continue reading Get The MAX Date From A Cube Using MDX
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… Continue reading DAX Formulas To Know And Love