All sections →
Some Thoughts on Report Usability
September 22, 2022
A usable report meets a specific need, clearly presenting the facts in a way that's appropriate for the user's context.
April 24, 2018
For certain use cases, BIML is pure magic. The best kind of power tools
Day-of-Week Differences in MySQL and MS SQL Server
November 9, 2012
Heads-up! In MySQL, WEEKDAY('2012-11-09') = 4 (0-6 starting on Monday), but in SQL Server, DATEPART(dw,'11/09/2012') = 6 (1-7 starting on Sunday).
Converting to Project Connection Across Multiple Packages in SSIS 2012
June 4, 2012
I’m migrating a Business Intelligence project from SQL Server 2005 to SQL Server 2012. Microsoft has, overall, done a great job with their
Generating a Range of Dates in MySQL
May 4, 2012
Working on a report from a MySQL database, I needed a table of all dates for the next year. With SQL Server (2005 and later) there’s a CTE/recursive