Jambu Krishnamurthy


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)

2008-02-08 (first published: )

17,284 reads

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)

2007-12-14 (first published: )

9,122 reads

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)

2007-12-06 (first published: )

12,582 reads

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)

2005-10-06 (first published: )

1,228 reads

Blogs

Accessibility is not just about slides

By

Although I don’t write about it much on this website, I am on the...

Daily Coping 4 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Read the latest Blogs

Forums

Nested Join Alternative

By Jackie Lowery

Is there a better way to write this nested join query?  I'm concerned about...

How to determine whether SSIS is being used?

By jankovic

Hello I've inherited some dev environment which looks like was abandoned, but I'd like...

xml output from sql query

By Bruin

The script runs but gives me "no data to export"  I see data in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers