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)

You rated this post out of 5. Change rating

2007-08-21

12,306 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)

You rated this post out of 5. Change rating

2003-06-18

12,103 reads

Blogs

Speaking at SQL Saturday South Florida 2024

By

I’m heading to SQL Saturday South Florida 2024 next week. This is my second...

The Next Phase & A Fresh Start

By

As of June 1, I am no longer an employee at 3Cloud. I am...

How do you restore a SQL Server 2000 database in the year 2024?

By

A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I...

Read the latest Blogs

Forums

The Secondary Database Name in an AG

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Secondary Database Name in...

Cloud Transformation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Transformation

How I Used PostgreSQL RLS To Avoid Code Changes During a Migration

By shwets.ven@gmail.com

Comments posted to this topic are about the item How I Used PostgreSQL RLS...

Visit the forum

Question of the Day

The Secondary Database Name in an AG

I am setting up a SQL Server 2022 Availability Group and I am ready to restore the database on the secondary. The primary database is named Finance. However, we also use this instance for QA and already have a database named Finance. How do I configure the AG to use a different database as the secondary?

See possible answers