A Fine Slice Of SQL Server
In this video, I cover a class of algorithm that is neither particularly naive nor particularly Bayesian: Naive Bayes.
I am a bit tongue in cheek with that description, as technically I’ll give you that the class of algorithms is “naive.” But I do still have some fun with the name and then show how we can use Naive Bayes to build a quick-and-dirty model that’s at least somewhat effective.
Comments closedIn this video, I provide a primer on logistic regression, including a demystification of the name. Is it regression? Is it classification? Find out!
I have a lot of fun with this “Is logistic regression actually a regression technique, or is it secretly a classification technique?” I think this video is the single clearest explanation I’ve given on that question, which probably says something about my prior explanations.
Comments closedIn this video, I take a look at an alternative to bootstrap aggregation & random forest: boosting. We cover a brief history of boosting and see how it works in action with XGBoost and LightGBM.
This is probably the video with the single largest number of links in my show notes. It’s also one of the shortest in the series; it’s funny how things work out sometimes.
Comments closedIn this video, I cover a powerful ensemble method for classification: random forests. We get an idea of how this differs from CART, learn the best possible metaphor for random forests, and dig into random search for hyperparameter optimization.
Click through to see the video in all its glory.
Comments closedIn this video, we look at how to perform Infrastructure as Code in GitHub. We take a Bicep script and generate new Azure resources using it and GitHub Actions.
The video includes a very brief primer on Azure Resource Manager (ARM) and Bicep, and then gets into how you can use GitHub Actions to keep your Azure resources configured the way you expect.
Comments closedIn this video, we take a look at what GitHub has for project management, reviewing GitHub Projects and Issues.
The upshot is that GitHub has a fair amount of capability for project management. Its notion of Issues definitely feels fairly well fleshed out, which makes sense considering GitHub’s original purpose as a storehouse for open-source code repositories. By contrast, Projects are a relatively new feature and there’s still some room to grow there, especially if you’re used to project management tools like Jira or Trello.
Comments closedI found a solution to an annoying problem:
After updating to the new Microsoft Teams, I could see my camera in the preview screen, but when I was in a meeting, I’d only see a black rectangle as myself. Other people mentioned that they could see me, though sometimes my video would drop off. Also, I was unable to see anybody else’s camera feed, nor could I see when people shared their screens.
Read on for the cause and solution that worked for me.
Comments closedI finish up a series on SQL Server on Linux:
In this video, we will briefly cover the various forms of replication available in SQL Server, as well as what is in SQL Server on Linux. Then, we will create a simple publication and subscription using T-SQL.
As I joke about in the video, this is the video I expect to get the least traction on, if only because DBAs tend to run away from replication. If I were 20% more inclined toward Quixotic endeavors, I’d create an entire series on replication and show that it’s not magic and it’s only 70% as painful as most DBAs think, and even that’s because there’s a relatively limited amount of information out there on how things work.
Comments closedIn this video, we will build out two availability groups for SQL Server on Linux.
This one’s a pretty lengthy video, as I describe some of the mechanisms around availability groups and we build two AGs across three instances from scratch in SQL Server on Linux.
Comments closedIn this video, we install and demonstrate PolyBase running in SQL Server on Linux hosted on Ubuntu 22.04 and get a friendly reminder to read the manual along the way.
In all seriousness, the largest percentage of time I spent on this video was because I didn’t read the manual.
Comments closed