Latest Entries
Data Analysis / Statistics & Data Science

Which degree is right for you?

What a great coincidence. I was reading a blog on AllAnalytics, Get Smart About Analytics Education, which describes some of the questions a potential student should be asking of the institute. Coincidentally, I have been having exactly the same thoughts recently while reviewing the various options to study data science in New Zealand and Australia. … Continue reading

Performance Tuning / SQL Server DBA / sqlLAB

Writing Scalable Queries with T-SQL Ranking Functions

More frequently, I am coming across code that incorporates the various ranking functions now available in T-SQL. These functions have been around for a while and provide ways to include explicit ranking columns in query results. For example, in a race with three runners you could return their rank (1, 2, 3) with the following: … Continue reading