So, this month's T-SQL Tuesday topic is to think about a non-SQL Server technology that we want to learn. For me, I'm going to pick machine learning. As a DBA, I've always looked at machine learning as a thing for the BI guys. I'm a DBA after all why do I care about that? Well,... Continue Reading →
In my recent post, Installing External Modules into SQL Server’s Python I had a look at just how simple it is to import external modules into Python so that they can be used within SQL Server. In this post I'd like to show you a little something to demonstrate how we can integrate one of these modules... Continue Reading →
So Microsoft have integrated Python into SQL Server, from the moment I heard that I thought to myself, "wow, this is exciting stuff" and not just for the machine learning, BI guys that it was marketed at. It's exciting for us DBAs too, my head was in a buzz with all the things that we... Continue Reading →
Recently I've been thinking about Python and whether it can be useful to the DBA as well as the data scientist. One good use that I have found for it is to copy logins from one server to another. There are plenty of times when you might want to copy your SQL logins (including the... Continue Reading →
SQL Server's integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer anything for the DBA? All the attention has been on machine learning, so much so that for a while I didn't pay it any attention at all, but then I got thinking to myself. DBAs... Continue Reading →
SQL Undercover 