Install this theme
SQL Server To Postgres/GreenPlum Transition

I’m working with a team building a data warehouse using Pivotal’s Postgres / GreenPlum database. 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 transition.

Table and Column Names

In a typical SQL Server installation table and column names are case…

View On WordPress

The less effort it takes to process a factual claim, the more accurate it seems. When we fluidly and frictionlessly absorb a piece of information, one that perhaps snaps neatly onto our existing belief structures, we are filled with a sense of comfort, familiarity, and trust. The information strikes us as credible, and we are more likely to affirm it – whether or not we should.
The science of truthiness, which also helps explain the psychology of why we have such a hard time changing our minds, also known as "the backfire effect." The best antidote? Carl Sagan’s timeless Baloney Detection Kit. (via explore-blog)
Which code page for UTF-8?

Which code page for UTF-8?

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 take a look at the post SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for…

View On WordPress

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

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 consumption by another system. No problem! I can do that in my sleep!…

View On WordPress

SQL Query To Find Your Version of GreenPlum or Postgres

Ummm, what version of GreenPlum am I running? (Which is the same as asking: What version of Postgres am I running?) There are a few easy ways to figure this out but I’ll stick with the SQL since that’s the most universal:

SQL Query To Find Your Version of GreenPlum or Postgres

Ummm, what version of GreenPlum am I running? (Which is the same as asking: What version of Postgres am I running?) There are a few easy ways to figure this out but I’ll stick with the SQL since that’s the most universal:

thefrogman:

Safely Endangered by Chris [website | patreon]

Find all users in an Active Directory group from the command line

Find all users in an Active Directory group from the command line

For some reason no one has ever trusted me enough to let me help administer the active directory groups. This means I’m always adding database perms to groups somewhat blindly, hoping the group names are intuitive enough that I can deduce who’s in them. Enter the magic of the command line! TUrns out you can view the members of an AD group with a quick trip to the command prompt. Witness: (more…)

View On WordPress

questionableadvice:

~ Etiquette; Or, A Guide To The Usages of Society, by Count Alfred D’Orsay, 1843

True that

questionableadvice:

~ Etiquette; Or, A Guide To The Usages of Society, by Count Alfred D’Orsay, 1843

True that

To sit in the shade on a fine day and look upon verdure is the most perfect refreshment.

Jane Austen

And science supports this!

(via currentsinbiology)
SSDT - Pre and Post Deploy Script Markers And Flava Flav

SSDT – Pre and Post Deploy Script Markers And Flava Flav

I admit, this post is primarily to provide a place for me to copy and paste my own code, but it’s so sweet I figured some of you other SQL Server Data Tool Users might find it handy.

When troubleshooting the generated deployment scripts I’ve always added a PRINT statement to indicate the beginning and ending of the pre and post deploy section. But, a post by SSDT kingpin Jamie Thompsonmade my…

View On WordPress

this is a test fb int test 5

this is the body of fb int test 5

View Post

fb int test 4

fb int test 4 body

View Post