I will be speaking @ SQLSaturday #795 Porto

On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...

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

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