Upcoming Speaking Engagements

It’s been a busy few months, so I’m going to keep radio silent for a little while longer (though Curated SQL is going strong).  In the meantime, here’s where I’m going to be over the next month:

  1. On Saturday, May 19th, I’ll be in New York City for SQL Saturday NYC, where I’m going to do two presentations:  Using Kafka for Real-Time Data Ingestion with .NET and Much Ado About Hadoop.
  2. On Tuesday, May 22nd, I’ll be in Charlotte presenting for the Enterprise Developers Guild, giving a talk entitled A .NET Developer’s View of the OWASP Top 10.
  3. On Thursday, May 31st, I’m going to give a paid pre-con entitled Enter the Tidyverse for SQL Saturday Mexico.  Click the link for instructions on signing up.
  4. Then, on Saturday, June 2nd, I’ll be in Mexico City for SQL Saturday Mexico, where I will present two talks:  Data Cleansing with SQL and R and Working Effectively with Legacy SQL.
  5. On Thursday, June 7th, I will present my R for the SQL Server Developer talk to the Roanoke Valley .NET User Group.
  6. Then, on June 9th, I’m going to give 3 sessions at SQL Saturday South Florida.  Those talks are Eyes on the Prize, Much Ado About Hadoop, and APPLY Yourself.
  7. I’ll be in Houston, Texas on June 23rd for SQL Saturday Houston.  There’s no official confirmation on talk(s) just yet, but I can confirm that I’ll be there and will do at least one session.

I have a few more irons in the fire as well, but this wraps up my May and June.


NDC Sydney Talks Up

NDC has released videos for NDC Sydney.  The NDC Conferences channel has the full set, and there were some fantastic talks this year.

I gave two talks at the conference:

They were surprisingly not awful!  Probably due to all of the post-production…

My favorite talk from NDC Sydney was Laura Bell talking about security for startups.  Definitely watch that one too; she gives four easy tips for us to use to improve our companies’ security postures.

Speaking At IT/Dev Connections

I am going to be speaking at IT/Dev Connections this year.  IT/Dev Connections will be in San Francisco, CA from October 23rd through the 26th.

I will have two sessions.  First off, on Wednesday, October 25th, I’m going to give my talk entitled R For The SQL Developer, where I go over some of what the R language can do.

Then, on Thursday, October 26th, you can check out my talk entitled Data Cleansing with SQL And R.  In addition to being high-brow (we’re “cleansing,” not just “cleaning” the data!), we will pick up some techniques on fixing messy data using T-SQL and R.

Tickets are currently available for IT/Dev Connections, though the prices will go up after June 16th, so hurry in.

Speaking At NDC Sydney

I will be speaking at NDC Sydney, which runs from August 14th through the 18th in Sydney, Australia.

I will have two talks at the event, both on Wednesday, August 16th.  First up, I am giving a talk entitled Data Cleansing with SQL and R, where I use a combination of T-SQL and R to build tidy data sets.

Then, right after that, I will give a talk entitled Peanut Butter and Chocolate:  Integrating Hadoop with SQL Server.  This talk is all about ways of tying together SQL Server and Hadoop.

Unfortunately, the Early Bird Price has expired, so tickets are at their regular price.  But tickets are still available, so if you want to see a bunch of top-notch speakers and get your passport stamped, check it out.

Kafka For The Big Data VC

I am going to speak about Apache Kafka for the PASS Big Data Virtual Chapter on Tuesday, May 16th—tomorrow!—at 2 PM Eastern.

This is in webinar form and registration is free.

I’m going to cover what Apache Kafka is, give you an idea of how it works, and show how we can write .NET code to make use of this powerful message broker technology.


Remember that first time you saw Service Broker and thought of all the great things you could do with it? Remember when you actually tried Service Broker and found all the limitations and pain points? Enter Apache Kafka. Apache Kafka is a distributed publish-subscribe messaging system which can scale out to handle millions of messages per second and support a distributed, microservices-oriented architecture. In this talk, we will cover the basics of this powerful system, including general architectural and design principles. We will also build a .NET project which uses Kafka to produce and consume messages quickly and efficiently.

Companero Conference


I am extremely pleased to have the opportunity to speak at Compañero Conference. Compañero Conference (or CompaCon, as I can’t pronounce “Compañero” because I can’t roll that n) is a paid conference in Norfolk, Virginia, starting the evening of October 3rd and going on through the 5th.

The purpose of Compañero Conference is to give lone DBAs, accidental DBAs, and new DBAs a place to meet compatriots and learn some useful skills.  Carlos and Steve have a pattern in mind for an intimate affair:  a single track of sessions, social events to give people a chance to get to know someone in a similar situation, and unfettered access to great speakers (and me).

I’m going to do two sessions at CompaCon:  one on database security, as well as a gentle introduction to the Hadoop ecosystem.  Because it’s a small group, you’ll have plenty of chances to get one-on-one discussion time with any of the speakers, so if you need help convincing your boss to attend, there’s a built-in benefit:  you have some really sharp people (and me—oh, wait, I did that one already) trapped in a room and you’ll get to pick our brains about work topics.  And unlike a SQL Saturday, you’ll still get the whole weekend to yourself.

Tickets are currently available at a discounted price of $400, but that’s only for a limited time.

Speaking At 24 HOP

I have the opportunity to speak at 24 Hours of PASS:  Data Security and Data Quality on Wednesday, May 3rd.  My topic is entitled Outlier Detection with SQL and R.  My session begins at 12 PM Eastern (4 PM UTC), nestled between a couple of great speakers in Bob Pusateri and Robert Davis.

Here’s my abstract:

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities.  As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data.  This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford’s Law, outlier analysis, time series analysis, and cohort analysis.

Webinar registration is free and easy, so sign up today.