Jambu Krishnamurthy


SQLServerCentral Article

Five Realtime DTS Examples

SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server
2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.

4.5 (2)

You rated this post out of 5. Change rating

2008-02-08 (first published: )

17,632 reads

SQLServerCentral Article

Exception handling in DTS

While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.

3.67 (3)

You rated this post out of 5. Change rating

2007-12-14 (first published: )

9,306 reads

SQLServerCentral Article

Data Modeling using ERWIN and SQL Server 2000

Using data modeling tools should be something that all SQL Server DBAs involved in development use, but most of us cannot afford the tools or have the expertise to use them. Jambu Krishnamurthy brings us a new article that shows how you can use Erwin to work with your data model.

3.6 (5)

You rated this post out of 5. Change rating

2007-12-06 (first published: )

13,175 reads

SQLServerCentral Article

Analysis of SQL Server Performance Data

Gathering performance data on your servers can be a cumbersome task without paying for an expensive tool. New author Jambu Krishnamurthy brings us a short tutorial on how you can gather this data from Perfmon and import it into SQL Server for reporting.

You rated this post out of 5. Change rating

2006-10-30

11,316 reads

Technical Article

Complex JOIN example (involving FULL, LEFT OUTER)

A table Users contains a Create date column.A table AccessLog contains StartTime column.Both are date time fields.Users table contains one row per user and AccesLog contains as many rows as the number oftimes the user Logged into the system.The requirement is:to produce a single table that has two different COUNTs... one column will have the […]

5 (1)

You rated this post out of 5. Change rating

2005-10-06 (first published: )

1,557 reads

Blogs

Moving to Rancher Desktop

By

I’ve been very happy with Docker Desktop for years, running it on both laptop...

Logging in Azure Data Factory data flows

By

(2025-June-15) Long gone are the days when a data engineer could simply focus on building...

ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish

By

I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...

Read the latest Blogs

Forums

Crosstabs and Pre-Aggregations - Reporting on Steroids by Jeff Moden

By Jeff Moden

The LA Data Platform User Group had a necessary speaker cancellation for the group...

How Many Can Be the Greatest

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Many Can Be the...

How to process images and analyze charts with AI

By Daniel Calbimonte

Comments posted to this topic are about the item How to process images and...

Visit the forum

Question of the Day

How Many Can Be the Greatest

I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:

select GREATEST( col1, col2, col3, ...)

See possible answers