Upcoming Events: SQL Saturday Louisville

Key Details

What: SQL Saturday Louisville
Where: University of Louisville, Founders Union, 450 N Whittington Parkway, Louisville, Kentucky
When: Saturday, August 3rd.
Admission is free. Register on the SQL Saturday website.

What I’m Presenting

09:30 AM — 10:30 AM — Launching a Data Science Project

I’ve had the good fortune to be in Louisville several times for SQL Saturdays and Derbycon before that. This year, the SQL Saturday is at a new venue. Unlike earlier this year at Madison, I checked beforehand…

PolyBase and Azul Zulu OpenJDK

One of the more interesting parts of SQL Server 2019 CTP 3.2’s release notes is the relationship between Microsoft and Azul Systems. Travis Wright covers it in some detail, as well as what it means for customers.

Prior to SQL Server 2019 CTP 3.2, installing PolyBase required an installation of Oracle’s Java Runtime Environment 7 Update 51 or higher, either directly from Oracle or through OpenJDK.

Daily security patches ahoy!

If you tried to skirt the installation, you’d get an error message telling you not to pass GO and not to collect $200.

Whomp whomp.

But as of CTP 3.2, your life just got 0.85% better. There’s no more prompt about Oracle JRE 7+ on initial installation.

Not pictured: the biggest reason people avoided installing PolyBase.

Instead, there’s another prompt in the setup for Java installation.

Look, you still have to install Java. That’s why life only got 0.85% better.

Our options now are either to tell SQL Server which Java runtime to use, or let it install Azul’s Zulu OpenJDK installation of the Java Runtime Environment. This way, you can avoid any potential issues around Oracle’s licensing changes for Java SE.

Where’s Poochy?

So there I was, working on my series on ML.NET, when someone hit me with a blackjack and I woke up a month later with a throbbing headache and lack of blog content.

At least, that’s the excuse I’m going with. Forthwith is a quick update on what’s happening.

Upcoming Events

I’ll have individual blog posts, but here’s what I’m cleared to talk about now:

  • SQL Saturday Louisville on Saturday, August 3rd.
  • TriPASS advanced DBA meeting on Tuesday, August 13th. I’m going to dive into PolyBase in SQL Server 2019.
  • SQL Saturday Baton Rouge on Saturday, August 17th.
  • Music City Tech in Nashville, September 5th through the 7th.
  • DBA Fundamentals Down Under on September 9th.
  • Open F# in San Francisco, September 25th through 27th.
  • Data Relay in England, October 7th through 11th.
  • NDC Sydney, October 14th through 18th.
  • PASS Summit Pre-Con, November 4th.
  • PASS Summit, November 5th through 8th.
  • Live! 360 in Orlando, November 17th through 22nd.

There are a few other events which I can’t announce just yet, but this part of the scheduled is firmed up.

Triangle SQL Server User Group Update

Two things of interest (which I’m blabbing about here before sending out an official notice to the group). First, thanks to Tom Norman (t | b), we are well on our way to non-profit status. We’ve incorporated in North Carolina as TriPASS and are working through the non-profit process. By “we” I mostly mean Tom. Delegation is the best.

Second, we are toying with streaming. After seeing Santosh Hari’s blog post on streaming user group meetings on the cheap, I decided to give it a try, particularly because some of the equipment was on sale during Prime Day(s). We’ll be streaming at https://www.twitch.tv/TriangleSSUG, so give us a follow.

Upcoming Blogging

Over the next six weeks or so, I plan to get back on the blogging horse. Here’s what you have to look forward to:

  • Finishing up the ML.NET series. I’m so close, yet so far.
  • More on PolyBase Revealed. Draft 1 is close to completion and I want to talk more about new external data sources and fun stuff I’ve learned.
  • Lessons learned in TriPASS streaming.
  • Lessons learned from putting an F# project into production.

Stay tuned and hope I don’t get blackjacked again.

Upcoming Events: SQL Saturday Albany Pre-Con

Key Details

What: SQL Saturday Albany Pre-Con
Where: Hilton Garden Inn Albany / SUNY Area, 1389 Washington Avenue, Albany, NY 12206
When: Friday, July 19th.
Admission is $150. Register on Eventbrite.

What I’m Presenting

08:30 AM — 05:00 PM — R for the Data Professional

This is my full-day R training under a slightly different name. Over the course of the day, we will cover a broad swath of the R ecosystem, giving you a general familiarity and setting you up to learn more. We will also spend a considerable amount of time covering scenarios specific to database administrators and other data platform specialists who might think that R is just for data scientists.