Is Dynamic T-SQL a Good Design Pattern?

In a recent discussion it was suggested to me that not only is dynamic T-SQL useful for things like catch-all...

Denali – Day 21: Security

Denali – Day 21: Security

 
Security wise Microsoft sql server is going great and on compare with other RDBMS in the market...

SSRS: FORMAT option for milliseconds

Some of our reports have hyperlink enabled on few metrics which points to an internal website. Recently there was a...

MS SQL Server : Nested Transaction and Partial Rollback of Transaction

Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...

Denali – Day 20: More Programmability Feature

Denali – Day 20: More Programmability Feature

Native XML Web Services (SOAP/HTTP endpoints) is Removed:

Earlier version of sql server support Web services...

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