Business Intelligence Developer, Smile Doctors

How to Execute SQL Queries in Python and R Tutorial

Learn easy and effective ways to run SQL queries in Python and R for data analysis and database management.
How to Execute SQL Queries in Python and R Tutorial - DataCamp

SQLBits 2022

Learned about parameter sniffing, query tuning, DAX and much more on SQLBits, the largest Microsoft Data Platform conference in Europe.

My first maintenance solution on SQL Server

Over the years, I have gotten more and more interested in how SQL Server actually works and the tasks associated with running a high-performing and well-functioning server.

This journey has led me to Ola Hallengren's maintenance solution which is both easy to use, flexible and well-documented.

I just implemented his scripts for the very first time and it has been a great success.

You can read more about Ola Hallengren's maintenance solution here.

Automatic Handling of Documents

I built a machine learning pipeline with my colleagues that takes PDF documents as its input and returns only relevant text from these documents to the end user.

The solution uses machine learning to both convert pictures into text using easyOCR and to learn which texts are of interest using the SVM algorithm. 

We used Python for processing the documents and text, SQL Server for storage and a simple Microsoft Excel interface to create training data by classifying text of interest.

Microsoft certified: Azure Data Fundamentals

I earned this year's first Microsoft certification: Azure Data Fundamentals. I intend to build on it.

See my credential here.