1 / 16

SQL Server 2005 CLR Integration & Programmability

SQL Server 2005 CLR Integration & Programmability. Aseel Mansour Product Technology Specialist Microsoft - South Gulf. They say: A picture is worth a thousand words . We say: A demo is worth a thousand slides . Programmability .NET Framework Integration

diata
Download Presentation

SQL Server 2005 CLR Integration & Programmability

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server 2005CLR Integration & Programmability Aseel Mansour Product Technology Specialist Microsoft - South Gulf

  2. They say: A picture is worth a thousand words

  3. We say: A demo is worth a thousand slides 

  4. Programmability .NET Framework Integration Stored Procedures User Defined Types Aggregates Web Services Support XML Support Summary Agenda

  5. Programming environment for Functions, Stored Procedures, Triggers User Defined Types, Aggregates In-Proc Data Access (ADO.NET V2) Symmetric data access Mid-tier/data tier deployment decision Security Integration of SQL and CLR security Three levels of code access security Safe, External-Access (verifiable), Unsafe Tight integration with Visual Studio Authoring, debugging, deployment, & profiling .NET Framework Integration

  6. VB,C#,C++ Build Assembly: “TaxLib.dll” SQL Data Definition: create assembly … create function … create procedure … create trigger … create type … SQL Queries: select sum(tax(sal,state)) from Emp where county = ‘King’ SQL Server The Developer Experience VS .NET Project Runtime hosted by SQL (in-proc)

  7. Server debug integration Set breakpoints anywhere Full debugger visibility Single step support: Between languages: T-SQL, C#, VB, & C++ Between deployment tiers: E.g. Mid-tier, through SQL Server stored proc call & back to mid-tier Authoring/Debugging/Deploying

  8. Choice of where to run logic Database, for logic that runs close to data Mid-tier, for logic that scales out Symmetric programming model Leverage skills mid-tier & server Choice of programming language C#, VB.NET, & Managed C++, for a safe, modern execution environment T-SQL continues to be supported & enhanced Remains good choice for data-intensive procedures Safe extended stored proc replacement .NET Integration Choices

  9. CLR Integration DemoStored ProceduresUser Defined TypesAggregates

  10. SQL & stored proc calls via HTTP/SOAP Easy, standards based connectivity from Unix platforms to SQL Server Provides native HTTP listening HTTP endpoint specifying URL, port, reqs Publish WSDL for endpoints Standard-based SOAP 1.1 and 1.2, WSDL 1.1, inlined XSD Windows and SQL authentication (SSL only) Stored Proc can return result as DataSet Compatible with mid-tier prog. model HTTP/SOAP Features

  11. SOAP Demo

  12. XML data type & XML index support Unified XML & relational store Both SQL & XQuery supported by same industrial strength infrastructure Leverages existing SQL engine & optimizer XQuery with data modification extensions XML views Declarative Mapping Files XML schema enforcement Client access using ADO.NET & SOAP XML Support

  13. XML data type Native SQL type Use for column, variable or parameter CREATE TABLE docs (id INT PRIMARY KEY, xDoc XML NOT NULL) Store un-typed or typed XML instances Well-formed and validation checks Methods on XML data type Query(), value(), exist() & modify() Native XML Store

  14. Create XML index on XML column CREATE XML INDEX idx_1 ON docs (xDoc) Creates indexes on tags, values & paths Speeds up queries Entire query is optimized Same award winning cost based optimizer Indexes are used as available XML Indexes

  15. XML Demo

More Related