STRING_SPLIT arrives in SQL Server 2016

A string splitting function has finally been included in SQL Server 2016!!! It might come as a surprise that previous versions did not have such a rudimentary string function, but there you go. I had a go at coming up

STRING_SPLIT arrives in SQL Server 2016

A string splitting function has finally been included in SQL Server 2016!!! It might come as a surprise that previous versions did not have such a rudimentary string function, but there you go. I had a go at coming up

A quick sound bite on predictive analytics

Was reading this post, and this little quote jumped out: “I now know the probability of an outcome [and] what can be done to influence it in the direction that’s positive for me,’ whether that be preventing customer churn or

A quick sound bite on predictive analytics

Was reading this post, and this little quote jumped out: “I now know the probability of an outcome [and] what can be done to influence it in the direction that’s positive for me,’ whether that be preventing customer churn or

Signal extraction: fourier transform

Stretching my brain back a decade, I used to work a lot with fourier transforms (FT) which are foundational methods of analysis MRI / NMR data. FT is so powerful and versatile that is widely used across all physical sciences

Signal extraction: fourier transform

Stretching my brain back a decade, I used to work a lot with fourier transforms (FT) which are foundational methods of analysis MRI / NMR data. FT is so powerful and versatile that is widely used across all physical sciences

Adoption of R in Business Intelligence

Like’d this post on R & BI. Arguably, the initial learning curve for R is much much steeper than slick software like Tableau. But, I think this misses the point. The adoption of R is about embracing a different type

Adoption of R in Business Intelligence

Like’d this post on R & BI. Arguably, the initial learning curve for R is much much steeper than slick software like Tableau. But, I think this misses the point. The adoption of R is about embracing a different type

MySQL Restores: waiting… waiting… waiting…

There are gazillions of posts with basic instructions for using mysqldump. But unless you are looking for it, very few of these comment on the shockingly slow restore times. However, there are some good hints and tips: http://loopj.com/2009/07/06/fast-mysql-backup-restore/ http://vitobotta.com/smarter-faster-backups-restores-mysql-databases-with-mysqldump/ Interesting

MySQL Restores: waiting… waiting… waiting…

There are gazillions of posts with basic instructions for using mysqldump. But unless you are looking for it, very few of these comment on the shockingly slow restore times. However, there are some good hints and tips: http://loopj.com/2009/07/06/fast-mysql-backup-restore/ http://vitobotta.com/smarter-faster-backups-restores-mysql-databases-with-mysqldump/ Interesting

Tuning MariaDB configuration for high throughput data warehousing

I have been suffering under the abysmal performance of MariaDB this week, as I have been trying to run a large extract-transform-load (ETL) process into my newest data warehouse. It’s times like this that I really miss SQL Server. But

Tuning MariaDB configuration for high throughput data warehousing

I have been suffering under the abysmal performance of MariaDB this week, as I have been trying to run a large extract-transform-load (ETL) process into my newest data warehouse. It’s times like this that I really miss SQL Server. But

The stages of data science maturity

In theirĀ Field Guide to Data Science, Booz Allen Hamilton describe the various phases of data science maturity. I quite liked this picture: Booz Allen Hamilton, 2015, p. 35 There are other similar models which describe the progression from traditional business

The stages of data science maturity

In theirĀ Field Guide to Data Science, Booz Allen Hamilton describe the various phases of data science maturity. I quite liked this picture: Booz Allen Hamilton, 2015, p. 35 There are other similar models which describe the progression from traditional business