Category Archives: SQL

Using conditional COUNT(*)s

Whilst recently working with historic financial data, I ran across a situationĀ that neededĀ an aggregate view of transactional data grouped by a certain set of attributes in order to backfill some missing aggregate data sets. In front of me, I had … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged | 2 Comments

Announcing my SQLBits Pre-conference Session

Having been a speaker at SQLBits since 2010, I am excited to announce that I will be finally delivering a preconference session at this year’s event in Telford and it is only fitting that my session returns to subject matter … Continue reading

Posted in Community, Events, SQL, SQLServerPedia Syndication | Tagged , , , , , | Leave a comment

Configuring Red Hat Enterprise Linux 7.2 for YUM without a Redhat Subscription

It has been a very long time since I have installed a Redhat Enterprise Linux distribution having tended to prefer Ubuntu based distributions (such as Linux Mint) or CentOS if I really wanted a Redhat derivative (although for Oracle Database … Continue reading

Posted in Linux, SQL | Tagged