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.
Enjoy my code sample and screencast (below) – happy programming!
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…
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.
I took the standard edition out for a spin and recorded the results in a short screencast (embedded below) – enjoy!
Deck from a talk I will be giving this Saturday at SQLSaturday in Mountain View, CA — hope to see you there!
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!
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.
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’.