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

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

Build a Little Free Library

I saw this on the Boing Boing feed yesterday, Little Free Library is a project to try to build 2500...