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

Zeichick’s Take: Radio moves from analog waveforms to digital packets
Streaming radio highlights the need for streaming applications to be designed to take up as little bandwidth as possible

Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans

Appcelerator Acquires Cocoafish to Add Instant Mobile Cloud Capabilities to its Industry Leading Titanium Platform
Appcelerator Offers Messaging, Social, Location and Storage Mobile Cloud Services to All Mobile App Publishers

ComponentOne Releases a Collection of 40+ UI Widgets Powered by HTML5 and jQuery
ComponentOne has announced the 2012 release of Wijmo: a kit of UI widgets for HTML5 and jQuery development

Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans

Top five apps to manage your workload
Web applications offer new ways to track your “to-do” lists

Not so fast when it comes to testing in the cloud
Developers face outsourcing, virtual lab management and mobile devices as obstacles

Xceed releases UX-focused suite for Microsoft’s WPF
"Blendables" helps match user experiences to developer visions

Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.

Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.

RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!

GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.

The Hidden Costs of Software Licensing Moving beyond paper-based software licensing to more flexible, software-based licensing is a business decision. There is a growing trend tow...

Case Study: You May Need a Development Mechanic As a contractor for a major financial player in Germany, SOBEGE, a German-based consultancy specializing in embedded IT and web services, wa...

Ensuring Software Quality at a Major International Bank One of the world’s leading international banks has adopted AgitarOne technology for delivering generated unit tests for their Java software...

Load Testing Adobe Flex Applications Adobe Flex applications may be different from applications you’ve worked with before. For classic HTML web applications, the server does all...

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
FEBRUARY 2012 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?

Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.
02/09/2012 02:16 PM EST

Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.
02/07/2012 11:57 AM EST

RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!
02/04/2012 01:57 PM EST

GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.
02/03/2012 12:17 PM EST

Facebook claims hacker cred
Facebook's SEC S-1 filing form includes a short essay on the Hacker Way by Mark Zuckerberg himself.
02/02/2012 08:26 AM EST

Ryan Dahl steps down
Ryan Dahl, creator of Node.js, steps back from his position as gatekeeper for the project.
02/01/2012 04:58 PM EST