Dinesh Priyankara

  • Interests: MS SQL Server, c#.net

SQLServerCentral Article

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

11,697 reads

SQLServerCentral Article

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,603 reads

Blogs

Daily Coping 29 Sep 2022

By

Today’s coping tip is to avoid saying “I should” and make time to do...

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Daily Coping 28 Sep 2022

By

Today’s coping tip is let go of other people’s expectations of you. I think...

Read the latest Blogs

Forums

PASS Data Community Summit

By cindygross

Who's going to PASS Data Community Summit this year? It's been quite a while...

SAP S/4HANA and Microsoft Azure SQL integration and ETL DELTA Process

By Surendra Kumar Reddy Koduru

In this Article I’m going to demonstrate the heterogenous systems integration and building the...

Get addresses that match list of customers

By Jackie Lowery

Let's say i have a table with columns:  cus_no, address, city, state, zip. How...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers