T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs

T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs

This blog entry is participating in T-SQL Tuesday #024, hosted...

SQL Saturday #99 Minnesota on Friday 11/11/11

SQL Saturday 99 on Friday is upon us.  I look forward to seeing you at the event.  For details check...

PASS Board Of Directors Interview

I had my telephone interview for the PASS Board of Directors this afternoon and I'm cautiously optimistic that I did...

T-SQL Tuesday #024: Prox ‘n’ Funx

Functions are very handy.  They can also prove to be the cause of poor performance (such as was the case with that string splitter).  When used appropriately, you can...

T-SQL Tuesday #024: Prox ‘n’ Funx

I find myself just now sitting down to write this as the deadline for TSQL Tuesday 24 fast approaches.  Fortunately...

Quite a salary

If this article is true, and I suspect it is for some software engineers, why aren’t more people learning programming?
I...

My Playbook For Putting On a SQLSaturday Part 1

The Long Road
I am going to post this as a series covering, in detail, everything humanly possible about the logistics...

CONVERT Dates and Confusion

Right I've been itching to post another Blog and actually contribute something this time.  This isn't something I've learned but something I've taught many...

A view has no data

I have seen quite a few posts and questions lately from people that are trying to change the data in...

Inline TVFs can't use FORCE ORDER hint but Multi-Statement TVFs can...?

Doing some work with converting Multi-Statement TVFs to Inline TVFs and I'm finding that the Inline TVFs cannot use the...