Category Archives: SQLServerPedia Syndication

Speaking at SQLSaturday Parma!

Anyone who knows me well will know that I like to fly my colors close to my chest and am a proud Chelsea fan. I have supported them since they fell to and rose back from the English old Second … Continue reading

Posted in Community, SQLSaturday, SQLServerPedia Syndication | Tagged | Leave a comment

Learning to say NO

Thank you to Kendra Little who is hosting this month’s T-SQL Tuesday topic on “Interviewing Patterns and Anti-Patterns” – and what advice I might have for someone preparing for an interview. But instead of regurgitating the obvious advice you can … Continue reading

Posted in Personal Development, SQLServerPedia Syndication | Tagged | 2 Comments

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