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

No comments:

Post a Comment