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

Open Source PowerShell – Play by Play

What’s going on here?
So last week you may have seen this picture on Twitter…it went a little crazy…and you may...

Restoring Azure SQL Database

A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering...

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

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

Why SQL Cruise?

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

Changing connection colours in SQL Server Management Studio

A simple but effective setting in SQL Server Management Studio is using custom colours to identify which server you are...

Have you Upgraded From SQL Server 2005?

My first Learning Tree SQL Server Newsletter that was sent out back in August was titled SQL Server 2016: Keeping...