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

What is #SQLFamily?

There’s a large group of people that mean a lot to me.  Some of them I know well, and others...

Financial Transparency is Good for Community

I was recently in a conversation with several people that had previously organized one or more community events. The topic evolved into a discussion of Sponsors, and eventually, fund...

Financial Transparency is Good for Community

I was recently in a conversation with several people that had previously organized one or more community events. The topic evolved into a discussion of Sponsors, and eventually, fund...