Five Essentials of Effective Metrics
This is a great post from my friend Andy Kriebel. Please check it out and leave him a comment to let him know what you think! http://www.vizwiz.com/2019/11/effective-metrics.html
10 things that are hard in Tableau with Analysis Services cubes
Tableau and cubes I love Tableau, I do NOT however, love working with Tableau when it is connected to an OLAP cube (like Microsoft SQL Server Analysis Services). I don’t enjoy working with cube data in Tableau because basically all the coolest parts of Tableau won’t work or won’t work in the ways you might expect. I …
BIML: C# looping through array example
Note: This blog post was rescued from my personal blog after I lost my domain name. Let it be a lesson to you … keep up with your domain registrations! Yesterday I was working with a colleague on an interesting problem in BIML. We are using BIML to build one SSIS package per table in …
Biml comments
To set the stage, I’m a big fan of writing helpful comments into the code as I write it. Comments are ignored by the compiler you are working with, they are just sort of there, hanging out and hopefully helping you as you work or when you come back to work days, months or even …
tsql: Find varchar or nvarchar(max)
From time to time I need to find all fields in a database that are varchar or nvarchar(max). Following is a little bit of code that I’ve come back to more than once. Sharing it for you (and so I can find it next time I need it!) .
Are you playing all your cards?
If you aren’t using the data your business already captures to set directional strategy and to make day to day operational decisions are you really making the best bets possible?