LOGIN | REGISTER NOW | SUBSCRIBE
 
print Printable version 
Most Read Latest News Blog Resources
Does Windows cost Microsoft opportunities?
Microsoft's decision to focus .NET on Windows is stifling innovation due to the specter of...

Mono brings .NET to Android
At Microsoft MIX, Mono will unveil the ability to port .NET applications to the Android op...

OSBC focus turns to best practices for open-source adoption
Businesses are no longer asking why they should adopt, but how do they use open source leg...

Digg!  Digg
Reddit  Reddit
Slashdot  Slashdot
Share on facebook  Facebook
Share on Twitter  Twitter

Why program Microsoft SQL Server from .NET?


By Jennifer deJong
November 18, 2008 — 
Microsoft developers may use LINQ or other data access technologies for applications that implement common business operations. But larger, more specialized applications are good candidates for .NET-enabled SQL Server. Microsoft’s José Blakely, a partner architect for SQL Server, offers three scenarios where programming the database from .NET makes sense:

Deep extensibility in the database. Developers can build core database constructs such as table-valued functions, user-defined aggregates or rich types using a CLR language (such as C# or VB.NET) in Visual Studio. The managed environment is safer and more robust compared with unmanaged extensions (built in C++, for example). And it runs faster and scales much better than similar functionality in Transact-SQL.

A more powerful environment for database developers. They can leverage .NET libraries (such as those for regular expressions, string manipulation and math functions) and use them in SQL Server.

The ability, via the CLR, to write specialized business logic using modern .NET programming languages and run those programs close to the data inside the database. With the very high data volumes being stored in databases—often hundreds of terabytes or even petabytes—managing data in the middle tier is unworkable. Embedding the CLR in SQL Server lets developers move complex business computations to the database.


Related Search Term(s): LINQ, NET, SQL, Microsoft


Share this link: http://www.sdtimes.com/link/33055
 

Add comment


Name*
Email*  
Country     


  • Comment
  • Preview
Loading



 
 
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 
Download Current Issue
ISSUE 3/15/2010 PDF

Need Back Issues?
DOWNLOAD HERE

Receive the print Edition?


 
blogs tab
Google Code turns 5
Google Code Turns 5, and adds a Paxos Algorithm to make the system more stable and reliable.
03/17/2010 11:16 AM EST

Test your Visual Studio 2010 know-how
Microsoft is offering free beta certification exams for Visual Studio 2010.
03/17/2010 11:08 AM EST

Microsoft lifts the hood on IE9
Microsoft is previewing IE9.
03/16/2010 01:10 PM EST

 

Events calendar tab
EclipseCon
3/22/2010 to 3/25/2010
Santa Clara, Calif.
The Eclipse Foundation

DevConnections
4/12/2010 to 4/14/2010
Las Vegas
Penton Media

MySQL Conf. and Expo
4/12/2010 to 4/15/2010
Santa Clara, Calif.
O'Reilly Media

High Performance Computing Linux Financial Markets
4/19/2010
New York City
Flagg Management

Informix User Conf.
4/25/2010 to 4/28/2010
Overland Park, Kans.
IIUG