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: )

16,963 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,063 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,319 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: )

806 reads

Blogs

Prompt in ADS

By

Ever since VS Code and Azure Data Studio came out, people have been asking...

When Too Much is Not a Good Thing

By

Explore how to avoid unwanted results that oft occur due to lack of attention...

SSMS Tip: Vertical Text Selection

By

Occasionally, I’ll stumble across one of those neat tricks that makes me ask myself,...

Read the latest Blogs

Forums

Question on Index

By sabarishbabu

Hello, In my Datamart having FactTable like below and planing to create a index...

Analysis Services crashes sporadically

By stewwe

Hello! On our Microsoft SQL Server we provide tabular models that are executed as...

Trigger the job automatically

By Charmer

Hi Friends, I have a table where data is loaded every morning on a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers