PASS Summit 2018 was rejuvenating!

I just wanted to say ‘Thank You’ to the following for their continued guidance and support:

PASS Mentors: Laurie Carr, Ravi Kumar, Mike Wall
Role Models: Cathrine Wilhelmsen, Julie Koesmarno

#PASSWIT: Rie Irish
#SQLTrail: Carlos L Chacon
#KillaDBA: Homer McEwen

See you all at a #SQLSaturday soon =)


Custom Vision API

Henk Boelman has a great tutorial on using the Microsoft Custom Vision API. Easy to follow and a great resource to get you going quickly. Bonus if you’re a Simpson’s fan =)

More on Custom Vision API available on the Microsoft site here:

Counting Down.. T-minus 2 days to PASS Summit 2018!

Too excited to sleep last night, its almost that time of year!

If this is your first time at PASS Summit, … check out Bob Pusateri’s post on where he’ll be and what to do while you are there… Lots of fun stuff, with lots of fun data people this week!

Exam 70-475 Designing and Implementing Big Data Analytics Solutions

Passed!  Working in Azure sure helps you get up to speed on the technology faster!  After learning about the cloud on AWS, I am now continuing my journey on Azure.  Stop 1 on my certification journey was Exam 70-475.



Mastering Azure Analytics: Architecting in the Cloud with Azure Data Lake, HDInsight, and Spark

Author: Zoiner Tejada

Cert Exam Prep:

Big Data Exam Prep session from Microsoft Ignite 2017

Microsoft Professional Program Big Data

available on

Unit 1 – Data Fundamentals

Course 1:      Microsoft Professional Program : Introduction to Big Data

Course 3:      Introduction to NoSQL Data Solutions

Unit 2 – Big Data Processing

Course 5:      Delivering a Data Warehouse in the Cloud

Course 6a:    Processing Big Data with Azure Data Lake Analytics

Course 6b:    Processing Big Data with Hadoop in Azure HDInsight

Course 7a:    Processing Real-Time Data Streams in Azure

Course 7b:    Implementing Real-Time Analytics with Hadoop in Azure HDInsight

Unit 3 – Big Data Analysis Solutions

Course 8:      Orchestrating Big Data with Azure Data Factory

Portland SQL User Group BIML Demo – Dec 13th

Hope to see you at the Portland SQL User Group meeting on Dec. 13th.  I will be presenting a brief demo/overview of BIML.  Summary below:
How BIML Changed My Life! – An Introduction to BIML
Are you an SSIS developer who is building out your organizations datalake from multiple sources?
Or do you manage multiple SSIS packages comprised of components that do many of the same things?
Then BIML can simplify your life!
This demo will be an introduction to BIML.
Business Intelligence Markup Language (BIML) is a scripting language that allows data developers to programmatically
create SSIS packages and objects.  This demo will include and overview of pre-requisites for installing BIML components,
as well as a demo of SSIS package generation using BIMLExpress tools embedded in SQL Server Data Tools.
Tools Used:
Varigence BIMLExpress 2017
SQL Management Studio 2017
SQL Server Data Tools 2017

AWS Re:Invent 2017

This year was my first time attending the AWS Re:Invent conference in Las Vegas.  It was a great experience!  I sat through presentations on days 1 and 2, switched over to Spotlight and Open Labs on days 3 and 4.  Sat for the AWS Certified Solutions Architect: Associate Exam on day 5 … and Passed!

For my SQL friends, SQL Server 2017 on RDS  coming soon!  Plus new capabilities for expanding SQL Server compute ONLINE.