Dinesh Priyankara

  • Interests: MS SQL Server, c#.net

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,190 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,312 reads

Blogs

Azure Arc

By

Azure arc is another great stuff coming with Microsoft Azure, as we were expecting...

Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements

By

The next batch of exciting updates to the block editor is live on WordPress.com....

Are You a Diverse User Group or Event?

By

One of the things that I’ve seen crop up at various points in my...

Read the latest Blogs

Forums

Log shipping performing log backups despite its backup jobs being disabled

By alexhdavies

Hi Came across an odd issue this evening. Running a migration over the weekend...

Granting Schema Permissions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Granting Schema Permissions

Lots of Data and AI Helping Firefighters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lots of Data and AI...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers