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

Organizing a SQL Saturday – Part 3 – The Venue

You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you...

I’m Speaking! SQL Saturday #548 – Kansas City

This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. This particular event is like going home...

sp_WOxCompliant Update

I just released an update to the sp_WOxCompliant script to fix a couple of issues. You can download it here! What...

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

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