Upcoming Events: SQL Saturday Dallas

Key Details What: SQL Saturday DallasWhere: UT Dallas, Naveen Jindal School of Management, 800 West Campbell Road, Richardson, TexasWhen: Saturday, June 1st, all day.Admission is free. Register on the SQL Saturday website. What I’m Presenting 01:15 PM — 02:15 PM — A Map to Success: Functional Programming for Database Developers This is a brand new talk.…

Machine Learning with .NET: Premise

This is part one in a series on Machine Learning with .NET. Microsoft has officially released ML.NET 1.0. The idea behind ML.NET is to bring some of the data science techniques and algorithms we use in R and Python over to C# and F#. Over the course of this series, we will look at a…

Upcoming Events: TriPASS Data Science Group

Key Details What: Triangle SQL Server User Group: Data Science SIGWhere: 3100 Tower Boulevard, Durham, NCWhen: Tuesday, May 28th at 6 PMAdmission is free. Register on Meetup. What I’m Presenting 06:00 PM — 08:00 PM — A Brief Look at ML.NET This will include my example from my Machine Learning with .NET talk as well as…

PolyBase on Linux with CTP 2.5

The SQL Server team continues to make my day. The latest reason for joy (but also consternation because who has time for all of this?) is that PolyBase is now available on Linux as of SQL Server 2019 CTP 2.5. I decided to give this a shot by building a container. Walk with me here.…

Course Review: Docker and Kubernetes

This is a review of Nigel Poulton's Pluralsight course entitled Docker and Kubernetes: the Big Picture. This is a great introductory course for someone with zero container experience, as Nigel takes us through a quick primer on containers, Docker, and Kubernetes. Nigel brings an energy to this that I appreciate---he has a lot of passion…

All Data is Dirty: Subjective Data, Likert Scales, and More

One of the things I like to point out in my Launching a Data Science Project talk is that all data is, by its nature, dirty. I figured I could get into that a little bit here and explain why. I'll pick a few common problems and cover why each is intractable. Subjective Data Lacks…

PolyBase Revealed: SQL Server to SQL Server

Today I'm going to cover something I've been waiting to do for just about three years: use PolyBase to connect one SQL Server instance to another SQL Server instance. In this post, we'll cover the basic setup and a couple points of interest I've found in writing this chapter of the book. Setup: One Less…

Upcoming Events: Hampton Roads SQL Server User Group

Key Details What: Hampton Roads SQL Server user groupWhere: 100 Constitution Drive, Virginia Beach, VAWhen: Wednesday, May 15th at 6 PMAdmission is free. Register on Meetup. What I’m Presenting 06:00 PM — 08:00 PM — SQL Server Machine Learning Services in Production I gave this once as a "beta" talk and have tweaked it a…

I’m Speaking at PASS Summit

Are you going to PASS Summit this year, from November 4th through the 8th? If so, I have a two-fer for you. First, I'm going to present a full-day training called Architecting a Big Data Analytics Solution in SQL Server 2019. I'm going to draw a few boxes, link together a bunch of interesting technologies…

First Thoughts on Automating Jupyter Notebooks

Every time I give a talk covering notebooks, one of the questions I get from people is, "How do I automate the execution of notebooks?" In this post, I'll look at one way to do just that. Command Line Execution I'm going to stick to the command line version of Jupyter. There is also a…