Dinesh Priyankara

Accessing .NET assemblies with SSIS

SQL Server Integration Services has changed the ETL process dramatically with many new capabilities. It's extensibility is unmatched, allowing you to build workflows that were not possible in DTS. Dinesh Priyankara brings us a useful new technique for referencing your .NET assemblies from within SSIS to take advantage of code reuse.

4.5 (2)

2007-08-21

10,108 reads

UDF as Computed Column

UDF's are useful if somewhat tricky. Dinesh uses a common scenario where you have a self referencing table (the common example is an employees table where each employee has a managerid that links to another employee in the same table) to illustrate how a UDF can make querying easier, how to use it as the basis of a computed column, and how to index that column.

5 (2)

2003-06-18

11,039 reads

Blogs

Daily Coping 9 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Webinar: How to unlock the value of frequent deployments

By

I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...

SSMS 18.5 Fixes from Redgate

By

I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...

Read the latest Blogs

Forums

ALWAYS On Setup problem

By interest

While configuring N1 and N2  Nodes connected to DC  Domain Controller working fine. Establishing...

Do You Have a Mentor?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Have a Mentor?

Counting Rows in DAX

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Rows in DAX

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers