SQL SSRS Express Edition Cannot Connect to Azure SQL Databases

This has bit a couple of clients recently, figured I'd put out a PSA.

Express editions of SQL Server Reporting Service,...

PowerShell, Pester and Ola Hallengrens Maintenance Solution

If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...

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