Throughout the week, I read a lot of blog-posts, articles, etc., that has to do with things that interest me
- data science
- data in general
- distributed computing
- SQL Server
- transactions (both db as well as non db)
- and other “stuff”
This is the “roundup” of the posts that has been most interesting to me, for the week just gone by.
I know, I know - there is not much for this week. A major reason for this is that, here in South Africa, we are in SQL Saturday season right now. What has that got to do with anything you may ask - well, it is like this:
In April/May (or thereabouts) emails are going out from the organizers asking for submissions to the upcoming SQL Saturday’s. At that stage I have some “awesome” ides what to present about, typically some new cool stuff coming - hopefully - just in time for SQL Saturday.
So, I put together some topics with blurbs what the presentation will be about. Then I promptly forget about this until I receive an email a month, or thereabout, before the “gig” - saying what talks have been accepted. At that stage I am like : “cool, my talk about xyz got accepted, let’s see what to cover. Ah well, I have plenty of time …”.
Then, all of a sudden it is one week before the first “gig”, and I realize I have nothing prepared yet, so NOW it is time to burn the midnight oil. And that is what I have been doing the last week (and will be next week, and the one after that). The upside of this is that the talks could potentially result in a blog-post or two.
Anyway, that aside, here is what I have found.
SQL Server
Fishing for wait types revisited – QUERY_TASK_ENQUEUE_MUTEX. Ewald has to eat some “humble pie” when it comes to wait types. This blog-post is awesome from a couple of perspectives:
- Ewald is a mere mortal as the rest of us.
- It covers some cool sh*t.
Streaming
- Introducing KSQL: Open Source Streaming SQL for Apache Kafka. Man, this is sooo awesome! Apache Kafka and SQL! This can be the best thing since sliced bread!!! I wonder what impact this will have on technologies like Esper and even Flink.
- Machine Learning-based anomaly detection in Azure Stream Analytics. Azure Stream Analytics introduces machine learning-based anomaly detection.
- Azure Event Hubs Capture. Azure Event Hubs have been the preferred choice in Azure to get data into the cloud. Then, if you wanted to push it further - Azure Data Lake, etc. - you had to either write your own consumer or use Azure Stream Analytics, with an output sink.
With Azure Event Hubs Capture you can automatically deliver the streaming data in Event Hubs to an Azure Blob storage or Azure Data Lake Store account of your choice, with the added flexibility of specifying a time or size interval. Cool!!!
SQL Server R Services
- Microsoft SQL Server R Services - Internals X. This episode covers how data is sent from SQL Server to the R components. Initially I had planned Internals - X to be the final posting the internals part of the SQL Server R Services series, but I realize now that I need at least two more parts.
Shameless Self Promotion
In the beginning of this post I wrote about how it is SQL Saturday “season” here in South Africa. If you are around, and interested I am talking at:
- SQL in Port Elizabeth 06 September 2017. Here I present on
- Real World Example of Using R in SQL Server
- The Definitive Guide to SQL Server Error Handling
- SQL Saturday 2017 Cape Town. My talk here is:
- SQL Saturday 2017 Durban. My talks here are:
So please, if you are around - come and say Hi!.
In addition to the above, I just came home from:
- SQL Saturday 2017 Johannesburg. Here I presented:
~ Finally
That’s all for this week. I hope you enjoy what I did put together. If you have ideas for what to cover, please comment on this post or ping me.