For Tableau requirements like: Allow user to choose "Last 7 Days", "Last 30 Days", etc. this is your ticket. It turns out one parameter and one calculated field are all you need.
Suppose you create an extract in your desktop version of Tableau and everything is running great. Then one of your peers casually asks "how big is that .tde file anyway?" You quickly check file explorer and discover the extract is not in the default location (What is the default path?). It seems like there should […]
What is the default path for tableau extracts on a windows desktop? C:\Users\<your user name>\Documents\My Tableau Repository\Datasources For example mine is: C:\Users\psteffek\Documents\My Tableau Repository\Datasources Boom.
Here's what we wanted: Each function from our GreenPlum (aka Postgres) database scripted out into it's own file. I think after much hacking I've got something working that only requires a small amount of manual intervention. For whatever reason PostgreSQL/GreenPlum doesn't seem to have a native way to split objects into separate files. This functionality is […]
Man!!!! Why is the code to create a database snapshot so ridiculously complicated? Actually, I guess I understand why but how about allowing it to be done through SSMS and then setting a bunch of the parameters as defaults for us? Come on Microsoft! Help a SQL brother out! Well luckily, where Microsoft fails, I'm […]
I love the idea of DBFit (being able to run tests against every database system under the sun) but have found it very challenging to get up and running. There is documentation but it seems to assume a level of familiarity with FitNesse that I definitely did not have. The primary hurdle for me was […]
If you are using the java version of DBFit and you want to connect to SQL Server you may start to think it can't be done. Fear not! It is possible! I'll summarize the required steps as well as all the error messages I received along the way. Running through these steps will enable you […]
I'm a git and cygwin noob. Despite that I like using the command line. It's a bit of mental gymnastics and keeps the mundane from getting mundane. One thing that irritated me though was having to constantly retype my password when pushing or pulling from remote. Through dumb luck I stumbled across the secret config […]
Just a quick little stub of a post to track progress using the DBFit Test Driven Database Development Tool with our GreenPlum installation. DBFit seemed like a great option since it will theoretically support both GreenPlum and SQL Server. I ran through the getting started documentation on the DBFit site fairly quickly and had the initial […]
Yuck. This works and I'm recording it here in case I need it again but yuck. Here's the scenario: there is a column in a database with a delimited string. The number of delimited values can vary. SOmetimes there will be one delimited value, sometimes there will be twenty. For this specific case I needed […]