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,174 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,086 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,518 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,054 reads

Blogs

Azure Databricks to Power BI

By

A very common approach is to query data straight from Databricks via Power BI....

SQLSaturday #1000! Join Oregon Virtually this Saturday

By

Honored to be a part of not just SQLSaturday #1000, but the long proud...

Azure DevOps–Reconfiguring an Agent

By

This post looks at how to re-configure a local Azure DevOps agent when you...

Read the latest Blogs

Forums

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct section to post my question. I...

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct forum to post my question. I...

SQL Case statement

By mtz676

select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers