Why Separate Your Compute From Your Storage

There are many advantages to using Microsoft Azure. One big reason people look at Azure is the ability to separate...

Watch SQL in the City Streamed September 2018

I’m over in the UK and we have SQL in the City Streamed tomorrow. This is our September edition, and...

Did Not Know That - Redirecting CMD to the Clipboard

One of the items I frequently deal with as a Production DBA is drive alarms.  I have written previously about...

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.                ...

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.
 
 ...

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...

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...

Does The Order Of Index Columns Matter?

When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance...

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...