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

Think Using .. In Code Is A Time Saver? Think Again!

Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out...

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

TGI SQL Friday: Weekly Roundup 23rd September

Its been another Learning Tree week for me this week and a very interesting one at that. I'm on the...

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

SQL QUERY NIGHTMARE

Last week, we faced a basic and yet the only major problem that sql developers/admin had to deal with and...

Why SQL Cruise?

I was riding the elevator up from lunch today, at work. I am relatively new at my job and do...

More Azure Database Creation in Powershell

I wrote about Azure SQL Database for T-SQL Tuesday #82, but I had a few mistakes in my process, at...