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

Column alias in order by and where

If you ever wonder why column alias can be used in order by and not in where clause, it’s the...

SQL Server security webinar now available on-demand

Last week I was able to give a SQL Server security webinar with Quest Software and SQL Server MVP Kevin...

How much space are you wasting?

A few weeks back a client of mine asked me to write a script that could tell him the space...

What #SQLFamily Means To Me

Meme Monday, What #SQLFamily means to me personally.
Tom LaRock Is kicking of November with this particular meme. I’m not sure exactly...

Download SQL Server 2012 Developer Training Kit

Microsoft has released SQL Server 2010 Developer Training Kit which includes :

LabsDemosand, Presentations

This kit will greatly help you learning Developer...