Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Wednesday, April 3, 2013

Key SQL CLR Decisions - Microsoft SQL Server

Key SQL CLR Decisions
# Using SQL CLR or T-SQL
# Using SQL CLR or Extended Stored Procedures
# Using SQL CLR or OLE Automation Procedures
# Using the Data Tier or Application Tier for Business Logic

SQL CLR Barriers of Entry

# Security Considerations
# The DBA Perspective on SQL CLR
# Implementation Considerations
# Performance Considerations
# Maintenance Considerations

Required Namespaces for SQL CLR Objects
There are four namespaces required to support the creation of SQL CLR objects. The required namespaces
are:
❑ System.Data
❑ System.Data.Sql
❑ System.Data.SqlTypes
❑ Microsoft.SqlServer.Server

SQL CLR Vs T-SQL - Microsoft SQL Server

In this blog post, comparing the SQL CLR and T-SQL in Microsoft SQL Server

Attribute   T-SQL SQL CLR
 Code Execution




 Interpreted Compiled
 Code Model Set-Based Procedural-Based
 Access to subset of the .NET
Framework Base Class Libraries (BCL)
 No    Yes
 SQL Server Access  Direct Access In-Process Provider
 Support Complex types No Yes
 Parameter Support Input and Output
Parameters
 Input and Output
Parameters