June 2014 Entries

Big Data 7 V

Have you heard of the 7 V of Big Data. Everyone knows the 3 V, but it was kind of interesting to hear some additional ones by IBM consultants. Personally, I think the last 2 should be present in all BI/data projects, but that's just me.

Listen to the podcasts put out through "IBM Big Data & Analytics Hub Podcast"


Posted On Thursday, June 19, 2014 4:04 PM | Comments (0)

OLEDB going away? Microsoft claims to be deprecating it in favor of ODBC

In case you haven't heard. Microsoft claims to be deprecating OLEDB in favor of ODBC. Seems like they want to push as many people to the cloud as possible... http://blogs.msdn.com/b/sql... http://social.technet.micro... ......

Posted On Thursday, June 19, 2014 3:55 PM | Comments (0)

Simple solution now to a problem from 8 years ago. Use SQL windowing function

I remember having this problem 8 years ago. We had to find the top 5 donor per month and send out some awards. The SQL we came up with was clunky and had lots of limitation (can only do one year at a time), then switch the where clause and go again. Fast forward 8 years, I got a similar problem where we had to find the top 3 combination of 2 fields for every single day. And the solution is this elegant: SELECT CAST(eff_dt AS DATE) AS "RecordDate" , status_cd , nbr , COUNT(*) AS occurance , ROW_NUMBER() ......

Posted On Tuesday, June 10, 2014 4:18 PM | Comments (2)

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski