Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Dinesh Priyankara

SQLServerCentral.com profile

   Items 1 to 10 of 10   
 

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.   Read more...
Rating: |  Discuss |   Briefcase | 8,582 reads

User Defined Data Types in SQL Server 2005

One other use of the new CLR integration in SQL Server 2005 is the ability to create user defined data types using managed code. Author Dinesh Priyankara brings us a first look at this capability with some code you can use.   Read more...
By Dinesh Priyankara 2007/05/25 (first published: 2005/08/02) | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 35,163 reads

Null Functions (Arent those Meetings?)

Dinesh did a little research on nulls and was kind enough to package it up for us. How many of you know or use NULLIF? Or COALESCE? Handy stuff!   Read more...
By Dinesh Priyankara 2004/03/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,132 reads

Optimizing Your Application - Part 2

This article is for developers (and is in C#), looks at how you can avoid requerying by storing data in a hashtable. Mainly code, but you may get a good idea or two from it.   Read more...
By Dinesh Priyankara 2004/02/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,925 reads

Optimize Your Applications

This article demonstrates that one way to optimize the data access portion of your app is to do the query once and cache the results. This is not advanced caching just something to get you started thinking about the possibilities.   Read more...
By Dinesh Priyankara 2004/02/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,837 reads

UDF as Computed Column Part 2

Dinesh is back with another article on user defined functions, giving some more great examples. If you haven't read the first one, definitely go back and read it first.   Read more...
Rating: |  Discuss |   Briefcase | 7,043 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.   Read more...
Rating: |  Discuss |   Briefcase | 10,725 reads

Comparison of Business Intelligence Strategies between SQL and Oracle

Dinesh does a good write up on research he did investigating the BI market and doing a feature comparison between Oracle 9i and SQL 2000. Simple bullet point format, worth a look.   Read more...
By Dinesh Priyankara 2003/05/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 19,232 reads

Ways to Determine the Version and SP of SQL Server

There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.   Read more...
By Dinesh Priyankara 2003/02/28 | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 21,846 reads

Reusing Identities

Ever wanted to know how to reuse identity values after they're deleted? In this example by Dinesh, he shows you two methods to reuse the wholes in identity rows.   Read more...
By Dinesh Priyankara 2003/02/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,942 reads
   Items 1 to 10 of 10