Skip to content

Home#

My year in Big Data, ML and AI

Although I’ve made this blog live a couple of months ago and it has a Big Data section, I didn’t have the time to work with technologies from this field very much, especially in the latter part of the year.

Even though I didn’t manage to test these technologies and implement them in a “homework” project, I’ve tried to keep myself up to date with things happening in this Big Data and Machine Learning ecosystem. And so, a small review of what small steps I managed to take this year:

How to find queries while tracing in SQL Server

Let’s say you’re working on a DEV database and you’re trying to get some information from SQL Server Profiler about the number of READS or WRITES that your queries are making and / or CPU time spent or other metrics. On a database with a lot of users running queries on the DB at the same time this can be difficult. But luckily there’s an easy fix to find those queries.

How to use a SQL trigger for the wrong reason

A couple of days ago I came onto a question on Stackoverflow asking how to create a trigger to impose constraints. The question asked about a SQL trigger where the OP (original poster) asked for, and I quote:

” I understand the idea of triggers but a bit confused on how to use it to impose constraints.

For example I have two tables: a student table and book_order table that shows what book a student orders. I want to create a trigger that will check that a student with a book order cannot be deleted from the student table.”