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,222 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,048 reads

Blogs

What Does Redgate Test Data Manager Do?

By

At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...

Extracting PostgreSQL database metadata for presentation in Excel format

By

(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...

Change Notebook Spark Session Time-Out in Microsoft Fabric

By

You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...

Read the latest Blogs

Forums

some questions related to Ola hallengren maintenance scripts

By vsamantha35

Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...

How to Alert When SQL Queries Exceed a Time Limit During Execution?

By IT researcher

I've been exploring various methods to monitor and alert for long-running queries in SQL...

3rd Friday of the Month

By water490

Hi everyone I need to find the last business of the week.  In most...

Visit the forum

Question of the Day

SQL Express Agent

How can I run SQL Agent with SQL Server Express 2022?

See possible answers