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

Denali – Day 18: Engine: Express LocalDB–Command line

Denali – Day 18: Engine: Express LocalDB–Command line

Express LocalDB is an express edition with minimum files required to start sql server...

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

Help I’m an Oracle guy – whats all this SQL Server stuff ?

Having ventured into both the SQL Server world and the depths of Oracle RDBMS – Im often asked what the differences...