WHITE PAPERS SPONSORED PROFILES JOB BOARD WEBINAR CENTER FREE SOFTWARE BZ RESEARCH ALMSHAREPOINT EVENTS CALENDAR PRINT/PDF EDITION PRINT/PDF BACK ISSUES

SUBSCRIBE TODAY CUSTOMER SERVICE EDITORIAL BEATS GUEST VIEW GUIDE SD TIMES 100 GUIDE EVENTS CALENDAR ADVERTISING ARTICLE REPRINTS REPORT A BUG SITE MAP

ABOUT US BZ MEDIA NEWS BZ RESEARCH NEWS ON MONDAY SPTECHREPORT SPTECHWEB SPTECHCON IPHONE/IPAD DEVCON ANDROID DEVCON PRIVACY POLICY CONTACT US

HOME >> SPECIAL REPORTS

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://sdt.bz/33055

Most Read Latest News Blog Resources

Virtualization: Not just for machines anymore
Network virtualization allows multi-tiered applications to behave as though they were in a physical network

Magic announces the release of its revolutionary mobile offering for the development of business applications, with new native clients for iOS and Android platforms
Magic announced today the availability of native iOS and Android clients for its mobile enterprise application platform

Achievements and learning: Gamification comes to businesses and schools
Startup takes page from gamers by offering achievement marks to get developers more engaged in their projects

Zeichick’s Take: The handheld and the tablet, circa 1976
Texas Instruments' and Hewlett-Packard's calculators were doing things decades ago we take for granted today

Virtualization: Not just for machines anymore
Network virtualization allows multi-tiered applications to behave as though they were in a physical network

Achievements and learning: Gamification comes to businesses and schools
Startup takes page from gamers by offering achievement marks to get developers more engaged in their projects

Google talks tools at AnDevCon III
New 3D debugging tool and recent ADK changes are detailed by Google developers at the third Android Developer Conference

SmartBear rolls out new quality solution: API Complete
Software gives organizations ability to write test scripts and monitor APIs by bridging the DevOps divide

Creation
To write better software, cultivate your ability to be creative.

Slick...but who needs it?
compilr.com is a well-designed site and the folks behind it seem to have their heart in the right place. But...who needs it?

How to be a better software developer
Want to be a better developer? You won't get there by mastering an interesting language or learning a new set of APIs.

Wooing Galatea
Do yourself a favor and check out Galatea 2.2, a wonderful book by novelist Richard Powers.

Five SCM Best Practices Two-thirds of all software projects fail, according to the Standish Group’s CHAOS study. Improper usage of software configuration management...

Best Practices for Branching and Merging Patterns

Development teams often create a branching pattern, usually drawn out on a white board or in a Visio document, that is used as a model to...

Automated Error Reporting We invite you to read a short e-zine that tells you all about automated error reporting for .NET applications. This 8-page e-zine is packed...

The End of Application Redeploys Imagine that every time you wanted to write, send or receive an email, you needed to restart your computer. How much time would this take, a...

Technorati

Digg

Slashdot

Facebook

Friendfeed

Twitter

del.icio.us

SQL still serves When it came to database programming, SQL was supposed to give way to other languages. But new technologies, such as LINQ, JPA, and improvements to SQL itself have allowed it to persist as the language of choice in this field.

What's the holdup? Interviews by SD Times have revealed five reasons why most developers don't program the database from their primary programming language. The emergence of new technologies and preference by developers to move data to the middle tier were two of those reasons.

Microsoft ships SQL Server 2008 Nearly six months after its gala launch event, SQL Server 2008 is now in the hands of customers. Its arrival formalizes the ADO.NET data entity framework and the server also includes new facilitates for data warehousing.

Add comment

Name*
Email*
Country

Comment

SQL still serves
When it came to database programming, SQL was supposed to give way to other languages. But new technologies, such as LINQ, JPA, and improvements to SQL itself have allowed it to persist as the language of choice in this field Read More...

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

Download Current Issue
MAY 2012 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?

Creation
To write better software, cultivate your ability to be creative.
05/19/2012 07:40 PM EST

Slick...but who needs it?
compilr.com is a well-designed site and the folks behind it seem to have their heart in the right place. But...who needs it?
05/16/2012 12:45 PM EST

How to be a better software developer
Want to be a better developer? You won't get there by mastering an interesting language or learning a new set of APIs.
05/14/2012 12:18 PM EST

Wooing Galatea
Do yourself a favor and check out Galatea 2.2, a wonderful book by novelist Richard Powers.
05/12/2012 07:05 PM EST

The world as story
An artificial-intelligence system at Carnegie Mellon seeks to understand the world by making statements about it.
05/10/2012 06:39 AM EST

The Rise of the Brogrammer, or the Rise of the Sexist Programmer?
Women in Silicon Valley get vocal about sexist ads and campaigns that contribute to a tense work environment.
05/09/2012 03:14 PM EST