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

9,866 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

10,979 reads

Blogs

AWS RDS SQL Server Announcements - 2019

By

1.    Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/  2.    Amazon RDS SQL...

AWS RDS SQL Server Version List

By

AWS RDS SQL Server 2017 Builds RDS...

What is a strong password anyway?

By

Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have...

Read the latest Blogs

Forums

Looking for SQL Code

By patla4u

Hi I am having situation where I would like to update the existing data...

Looking for SQL Code

By patla4u

Hi I am having situation where I would like to update the existing data...

SQL Server new Linked Server

By Bristool123

hello my friends. I have a suuuuuper weird question about sql server, at my...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers