Dynamic Stored Procedure Execution in SQL Server

In my previous blog post: Suggestion: “USE” Keyword with Linked Servers, I talked about the suggestion I’ve posted on Microsoft...

SQL Server Memory Usage - Task Manager

Another question I have answered 100s of times to Non SQL folks. "SQLServr.Exe is consuming 80% of memory. Can you...

Promised Links from SQL Saturday 119 Presentations

If you attended one of the sessions I promised to post the links we discussed here. I have done my...

Denali – Day 19: Programmability Feature -T-Sql

Denali – Day 19: Programmability Feature -T-Sql

ORDER BY .. OFFSET and FETCH :mysql LIMIT (srno ):

OFFSET is a location of the rows...

SQL Server 2012 Upgrade Technical Guide is available

The SQL Server 2012 upgrade white paper is now available from Microsoft.  I’m proud to have made a contribution and...

Rocky Mountain Tech Trifecta 2012

My fourth visit to the Rocky Mountain Tech Trifecta will be tomorrow where I’ll deliver two talks:
Branding Yourself for a...

The Brain Dump Blog

I was chatting with a friend recently and he said he could never blog the way I do. Which way...

Expectations-The Big Disconnect

One of the things I’ve learned from running events is to set expectations. If you’re going to provide coffee don’t...

SQLSat 142 – Waltham

Wow – have I ever been dark and silent this past couple of months.  Nothing like the present to reverse that trend.  I do have a good excuse for...

SQLSat 142 – Waltham

Wow – have I ever been dark and silent this past couple of months.  Nothing like the present to reverse that...