Code Sample for D&B Business Verification API published

D&B Business Verification Service

I’ve been doing work with Dunn & Bradstreet (and am also a D&B MVP), to that end, I wrote a code sample for working with their Business Verification service API in C# and published it to GitHub.

D&B’s Business Verification service is useful for many of my clients as it provides the ability to take partial (and potentially duplicate) customer information and returns back cleansed, completed, validated company information.  Also their unique identifier, the DUNS number, helps to identify duplicates.

My code sample is in C# and access their endpoint which is hosted in the Windows Azure Marketplace. D&B has a number of other data services, in addition to this one.  In addition to the Azure Marketplace, D&B has data services available at endpoints via their own D&B Direct site.

If you don’t need to code a custom solution the D&B Business Verification service is also available via the Windows Office store (as an Excel 2013 add-in) or via Excel Power Query.

D&B Business Verification Add-in for Excel

Enjoy my code sample and screencast (below) – happy programming!


Posted in Azure, Big Data | Tagged | Leave a comment

First Look – Windows Virtual Machine on the Google Cloud

Yes, you read this right.  Google announced last week at their cloud event, that their IaaS service - Google Compute Engine would begin to offer ‘premium operating systems’ – including Windows.  After getting approval from Google to join their limited preview, I tried this functionality out and here’s the results…



Posted in Cloud, google, Microsoft | Leave a comment

First Look – SQL Server 2014 RTM on Windows Azure

It’s a SQL Server kind of day.  First, congratulations to the team at Microsoft for releasing SQL Server 2014.  Also, thanks again to Microsoft to awarding me their MVP award for my SQL Server community education activities for the second year in a row.

As promised, the Azure team made a set of Azure Virtual Machine images with SQL Server 2014 RTM available today as well.
SQL Server 2014 RTM images on Windows Azure

I took the standard edition out for a spin and recorded the results in a short screencast (embedded below) – enjoy!


Posted in Azure, Cloud, Microsoft, SQL Server 2014 | Leave a comment

Microsoft Machine Learning Smackdown

Deck from a talk I will be giving this Saturday at SQLSaturday in Mountain View, CA — hope to see you there!

Posted in Agile, Big Data, Cloud, Data Science, SQL Server 2012 | Leave a comment

Intro to Go language and Google App Engine


I attended a Go Language bootcamp this weekend and wanted to continue my learning by working with Go and the Google Cloud.  To that end I made a short screencast of how to setup the Go Language, my preferred Go IDE (Sublime) and a local Google App Engine development environment (as well as how to push to production). — Enjoy!

Go language mascot - the Gopher!






Posted in Cloud, google | Tagged , | Leave a comment

Quandl and Excel – Public Data you can use










I found a great tool for integrating Quandl free, public data into Excel PowerBI. I made a quick screencast too.  There are over 8,000,000 datasets to pick from and everything is free, so lots to work with here.


Posted in Big Data, Data Science | Leave a comment

Where is Lynn? March-May 2014

I’ll be speaking at and/or attending a number of technical events this spring. I decided to make a short video to list all of them – if you are attending any of these events, stop over and say ‘hi’.

Posted in Agile, AWS, Azure, Big Data, Cloud, Data Science, google, Microsoft, Technical Conference | 1 Comment