Save Money On Your Azure Monthly SQL Database Bill

Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model...

Data Professionals at Work – a book-writing adventure

I love to write. It is how I express myself best. During the last fall I was pondering starting on...

Deploying To a Power Bi Report Server with PowerShell

Just a quick post to share some code that I used to solve a problem I had recently.
I needed to...

Does The Order Of Index Columns Matter?

Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...

Does The Order Of Index Columns Matter?

Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...

Don’t cutoff yourself with dates in T-SQL – Did you know…

Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident.

Who’s...

Don't cutoff yourself with dates in T-SQL - Did you know...

Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident. Who’s ever heard something like “Normal user don’t even...

Getting started with SQL Server Tools

This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques...

Interview Query – 1

Somewhere on internet i found this question. Thought to share it with you all. We have two tables,  school_students and Class_student.                ...

MongoDB 4.0.2 release

As i was discussing about MongoDB in my earlier blog, on NOSQL ACID stands for Atomic, Consistent, Isolation, and Durable...