In our last technical post, I covered using Visual Studio Code to debug PHP code. Today, I'm going to cover integrating with SQL Server. Step One: Get Drivers Assuming that you followed the instructions for setting up PHP in the link above, you have a version of PHP running in C:\xampp\php. From there, you will…
PolyBase Revealed + Azure Data Studio
As I work on PolyBase Revealed, I made a conscious decision to prefer Azure Data Studio for my demos over SQL Server Management Studio. Because I don't plan to go into much detail on why in the book (after all, the book is about PolyBase, not SQL Server clients), I wanted to take a little…
Upcoming Events: SQL Saturday Cleveland
Key Details What: SQL Saturday ClevelandWhere: Hyland Software, Cleveland, OhioWhen: Saturday, February 2nd, all dayAdmission is free. Sign up at the SQL Saturday website. What I'm Presenting 04:00 PM -- 05:00 PM -- Getting Started with Apache Spark
Using Visual Studio Code For PHP Development
For a consulting engagement, I needed to be able to run a debugger against a PHP codebase as part of a migration project. Because my last experience with PHP was sometime last decade, I had no clue how to do this. Now I have a slight clue, so I figured I'd share that slight clue.…
SQL Saturday Raleigh

SQL Saturday Raleigh 2019 is now live. It will take place on Saturday, April 27th at Wake Technical Community College's RTP campus. For the past three events, we hosted at William Peace University, which I absolutely enjoyed having as a venue. But with Wake Tech opening a campus just a couple of miles from the…
Course Reviews: Apache Spark 2 With Scala
This is a review for Frank Kane's Udemy course entitled Apache Spark 2 with Scala --- Hands On with Big Data! All in all, this was a fine course. Frank aims the course at people new to Spark. In my case, I have experience but wanted to start at the beginning to fill in the…
I’m Writing A Book
Due to having far too much free time (I mean, there are hours a day where I'm doing nothing but sleeping! More than one!), I've taken to the idea of writing a book on PolyBase. The working title is PolyBase Revealed and has a scheduled release date of "That's way in the future so I…
What’s On My Work PC?
I just had to rebuild my work machine, so I figured I'd get a cheap blog post out of it discuss the tools that I use regularly. I've broken these down by category. As a quick note, this is on my main work machine, so there are some things which I use on other PCs…
TriPASS Incorporation, Part One
As the Triangle Area SQL Server Users Group (TriPASS) grows ever-larger, we have decided to incorporate as a not-for-profit corporation. This is something which several of the members, including Tom Norman (blog | twitter) and Tracy Boggiano (blog | twitter) have been pushing for a while, and they sicced Jamie Wick (blog | twitter)---who wrote…
Solving Naive Bayes With R
This is part four in a series on classification with Naive Bayes. Classification Of Features With R So far, we've walked through the Naive Bayes class of algorithms by hand, learning the details of how it works. Now that we have a good understanding of the mechanics at that level, let's let the computer do…