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,553 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,268 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: )

12,857 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,293 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,533 reads

Blogs

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Friday Flyway Tips–Flyway Parameters

By

Flyway is a command line tool with lots of options and parameters. Working with...

Read the latest Blogs

Forums

table with varcahar(max)

By sqlguy80

Gurus, there is a table which is very slow to query , it has...

Query goes crazy.

By Robert-378556

Hi. I have a query that returns few rows (out of 7 table join,...

Migration from Sybase SAP SQL Anywhere to SQL Server 2022

By Stewart "Arturius" Campbell

We are working on a project to migrate a client from a version of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers