Articles

I adopt a 'learn in public' approach to blogging.

Whenever I learn something new, I try to capture it in a blog article.

This is just a snap-shot of my most recent articles. You can see all of them at my blog site: blogs.msdn.microsoft.com/Andrew

To SQL or not to SQL

16 Oct 2017

I was on tour last week at @SQL_Relay and gave a talk on CosmosDB at To SQL, or not to SQL: that is the question: Whether ’tis nobler in the mind to suffer The tweets and articles of outraged fanatics, Or to code structured queries against a sea of data, And by opposing end them?... <a aria-label="read more about To SQL or not to SQL" href="https://blogs.technet.microsoft.com/andrew/2017/10/16/to-sql-or-not-to-sql/" class="read-more">Read more</a>

Read More


Qualification

06 Jan 2017

Data Science and machine learning are very cool just now and It’s relatively easy to find lots of resources to learn either from books to MOOCs (massively Open Online Courses). But how can you prove you are an expert? The Microsoft tradition and one that I have followed in the past is to get certified... <a aria-label="read more about Qualification" href="https://blogs.technet.microsoft.com/andrew/2017/01/06/qualification/" class="read-more">Read more</a>

Read More


Think Data Science–Pitfalls

12 Aug 2016

In my last post and generally I like to talk up how useful a data science approach is to understanding your data but in this post I want to sound a note of caution as it can be easy to get carried away and generally if the results look to good to be true that’s... <a aria-label="read more about Think Data Science&#8211;Pitfalls" href="https://blogs.technet.microsoft.com/andrew/2016/08/12/think-data-science-pitfalls/" class="read-more">Read more</a>

Read More


Think Data Science – Approach

04 Aug 2016

I go to a lot of computer events and I feel for the organisers when 80 have registered and only about 30 turn up. I am not sure why the no shows feel it’s OK not to spend a few seconds on Meetup or EventBrite to cancel, as a matter of common courtesy. Anyway rant... <a aria-label="read more about Think Data Science &#8211; Approach" href="https://blogs.technet.microsoft.com/andrew/2016/08/04/think-data-science-approach/" class="read-more">Read more</a>

Read More


So you want to be a Data Scientist

26 Jul 2016

In the dark days of the last millennium data scientists were serious statisticians using exotic hardware, expensive software and were largely isolated from the rest of the organisations they worked for. Today the cloud and open source languages like R &#38; Python have made this technology available to anyone curious enough to be interested in... <a aria-label="read more about So you want to be a Data Scientist" href="https://blogs.technet.microsoft.com/andrew/2016/07/26/so-you-want-to-be-a-data-scientist/" class="read-more">Read more</a>

Read More


PowerShell for taming Azure

20 Apr 2016

Have you got your subscription under control particularly if you are on MSDN or a smaller budget and it’s just you or a small team using it? If you aren’t sure then read on; else Coffee. Here’s the problem we all forget to turn stuff off or kill it when we don’t need it which... <a aria-label="read more about PowerShell for taming Azure" href="https://blogs.technet.microsoft.com/andrew/2016/04/20/powershell-for-taming-azure/" class="read-more">Read more</a>

Read More


If you haven’t got a question then Machine Learning is not the answer

26 Feb 2016

I am in the middle of preparing for some more events the next big one being a day of machine learning (ML) at SQL Saturday Exeter. The organisers asked me to make a short video to explain what I’ll be covering and that got me to thinking about what my advice would be having worked... <a aria-label="read more about If you haven't got a question then Machine Learning is not the answer" href="https://blogs.technet.microsoft.com/andrew/2016/02/26/if-you-havent-got-a-question-then-machine-learning-is-not-the-answer/" class="read-more">Read more</a>

Read More


Azure SQL Data Warehouse Don’t do this..

26 Oct 2015

I am always one of the first to try new stuff when it comes out and so it was great for Microsoft to give me job doing this some 99 months ago. One of the latest things I signed up for was the Azure SQL Data Warehouse (ADW), and then setup a demo ADW so... <a aria-label="read more about Azure SQL Data Warehouse Don't do this.." href="https://blogs.technet.microsoft.com/andrew/2015/10/26/azure-sql-data-warehouse-dont-do-this/" class="read-more">Read more</a>

Read More


Data, no use at all without a catalog

06 Oct 2015

About a decade a go I went on a Microsoft BI boot camp which was also attended by Microsoft staff specifically Matthew Stephen and Rob Gray who inspired me to work towards joining Microsoft myself. Two years later I got in and haven’t looked back and I still track Matt on LinkedIn, so I was... <a aria-label="read more about Data, no use at all without a catalog" href="https://blogs.technet.microsoft.com/andrew/2015/10/06/data-no-use-at-all-without-a-catalog/" class="read-more">Read more</a>

Read More


Cortana – Remembering the Future

02 Sep 2015

If you have ever watched the Star Trek First Contact film the crew allude to the fact that the star ship Enterprise is named after the first space shuttle, when actually it’s the other way around the first space shuttle was so named because over 2 million star trek fans lobbied NASA to call it... <a aria-label="read more about Cortana &#8211; Remembering the Future" href="https://blogs.technet.microsoft.com/andrew/2015/09/02/cortana-remembering-the-future/" class="read-more">Read more</a>

Read More