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

SQL Server 2008 SP3 Cumulative Update 5 Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3...

SQL Server 2012 Certifications Revamped

Reprinted from my Database Weekly editorial.
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned...

SQLSaturday #119 Chicago – In the Books

As I write this, I’m enjoying a margherita pizza and a Miller High Life in my room.  The SQLSaturday #119...

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

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

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

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

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