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

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

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

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

Denali – Day 17: Distributed Replay

Denali – Day 17: Distributed Replay

Distribution replay a new command prompt utility provided by Denali, this works same as Profiler Reply...

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...

Denali – Day 15: Support for Windows Server Core

Denali – Day 15: Support for Windows Server Core

Windows Server Core: Microsoft Server has so many features which is not required...

Denali – Day 14: New DMV & DMF

Denali – Day 14: New DMV & DMF

As there has been so many DMV/DMF already introduced in earlier version of Sql server,...

Denali – Day 13: FileTable

Denali – Day 12: FileTable

“FileStream” is introduced in sql server 2008, for storing BLOB data like varbinary(max), it is integrated...

Denali – Day 12: More Manageability Features

Denali – Day 12: – More Manageability Features:

-K switch
With new feature added in an engine to use that feature with different way...