Archive by Author

Tableau – Parse Parameters From URL

Well, file this under “just because you can doesn’t mean you should.” Search the forums on parsing strings with Tableau and you’ll find a lot of guidance which pretty much says “don’t do it!” and “better to do it in your source!” These people are undoubtedly right. But, what if your source is an existing […]

SSRS: Parse parameters column from ExecutionLog

Ever worked on a quick little project, come across what you assume is a common need and think “I’ll just google up some code that someone else has written and then be off to the races”?  Have you done this and not been able to find the code you’re looking for? Well, that was me […]

Parse pg_dump Functions and Views Into Their Own Files (GreenPlum / Postgres)

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 […]

Easy SQL Server Snapshot Script / Proc

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 […]