The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data Platform conference: PASS Summit! I will be presenting on one of my favourite topics: In-database analytics inside Microsoft SQL Server (www.pass.org/summit/2018/sessions/details.aspx?sid=76976). So if you happen to be at PASS Summit and want to learn more […]
I am pretty hyped to be able to finally announce a new project of mine that I have been working on for quite some time now: Crazy Data Science! Crazy Data Science is a YouTube channel I created to show off real-world Data Science methods and techniques applied to “interesting” problems. And with interesting I mean cases […]
In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In the article I used a model that was stored directly inside SQL Server to perform predictions. But what if your models are not stored inside SQL Server but are build inside Azure Machine Learning? […]
Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and statistical analysis inside their database engine. In SQL Server 2016 Microsoft introduced the integration of the R language and in SQL Server 2017 Python was added. Both these languages give you the advantages of bringing […]
When you are working with Machine Learning there are many things you need to keep an eye on. You need to prepare the data, deal with any missing values and you need to select an algorithm you will be using for you model. Choosing an algorithm can be a difficult one though. Azure Machine Learning […]
With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning tasks on your data. One disadvantage I frequently run into is that cloud based approach of AzureML since the data you are building your machine learning models on has to be in the cloud as […]
Good news! The recording of my session “Introducing the SQL Server 2016 Query Store” at the GroupBy conference 2 weeks ago is available for your viewing, listening and reading pleasure! //groupby.org/2017/05/introducing-the-sql-server-2016-query-store/ Not only is a video recording available at the page above, but also a podcast version if you prefer only audio and a transcript […]
I remember writing an article about Query specific wait statistics being available inside execution plans in SQL Server 2016 SP1. The way that works is when you view the actual execution plan of a query (through SSMS or the XML) you are able to see the wait information that specific query ran into during execution. […]
In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely in your work as a DBA. Just one example: migrating SQL Server Instances takes a massive amount of work. You need to backup and restore every database, write down instance specific configuration and apply it […]
The 1.2 version of the Query Store Replay script a number of new features are added that return information of the query behavior on the target server. More specifically, in version 1.2 you are able to compare execution plans and query runtime statistics between replay executions on the source and target servers! Video guide to […]