In addition, they will have access to a rich set of .Net components that could, for instance, help them to get data from an Oracle database as part of an authorization check, the architect said.

"T-SQL and stored procedures are not the best tools for accessing non-SQL Server data," he noted. "But sometimes you need data from other sources to securely process a query."

Sidebar

Key questions that developers should ask

-- Will T-SQL or a .Net procedure-based language, such as C# or Visual Basic, enable a database job to be processed with the least amount of resources?