Nil to Speaker: Improving your PowerPoint skills

As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...

Setting DBCC 1222 on startup

The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)
However, once the SQL instance is restarted this...

Using an ORDER BY in a view

For many years it’s been a best practice to never put an ORDER BY in a view. The idea is...

What does UNION do or what result set UNION return ? What is the difference between UNION and UNION ALL?

UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...

What will be the result of the query below? Explain your answer?

select case when null = null then 'True' else 'False' end as ResultSet;

Order by Month Number and Show Month Name

This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought...

11 years of PASS Summit

This is a story of my 11-year association with PASS, and the many ways it helped me grow as a...

Announcing SQLSaturday Portugal Lisbon-Edition 2017

With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017...

I'm Back!

I've been gone... wow. Since March 31st of this year?! Let's fix that.

So what has been holding me back? 
Kids? I...

Mastering Index - Filtered Index

Mastering Index - Filtered Index

This article is the part of series Mastering Index, in this particular article we will be exploring Filtered Index. Take...