Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Haidong Ji

SQLServerCentral.com profile

I was a developer, working with VB, SQL Server, Access and lots of other Microsoft stuff. I am currently a SQL Server DBA in my company in the Chicago area. I am MCSD and MCDBA certified. In my spare time, if I have any, I like to do Linux, C and other open source project. I can be reached at Happy_Haidong@yahoo.com

   Items 1 to 18 of 18   
 

Don't Overdo It, SQL Server

With the release of SQL Server 2005, it is more of challenger to Oracle than ever before. Guru Haidong Ji takes a quick look at how these two products compare and gives a few words of wisdom for the next version of SQL Server.   Read more...
By Haidong Ji 2006/05/22 | Source: SQLServerCentral.com | Category: news
Rating: |  Discuss |   Briefcase | 10,526 reads

Introduction to SQLCMD

SQL Server 2005 has deprecated osql and isql as command line tools and replaced them with SQLCMD. Haidong Ji brings us an introduction to this new tool and a few tricks to make you more productive when using it.   Read more...
By Haidong Ji 2006/01/11 | Source: SQLServerCentral.com | Category: tools
Rating: |  Discuss |   Briefcase | 17,594 reads

Oracle and SQL Server Interoperability Part 3

Haindong Ji brings us part 3 of his series on Oracle and SQL Server interoperability, this time taking a look at the Oracle Instant Client.   Read more...
By Haidong Ji 2006/01/24 | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 11,771 reads

PASS Summit Impressions

There have been quite a few impressions of the PASS conference from our blogs, but here's another from Haidong "Alex" Ji, oneo f our longtime authors and a guest of SQLServerCentral.com at the Summit.   Read more...
By Haidong Ji 2005/10/10 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 3,240 reads

Code Generation: Using SQL to Generate SQL and Other Code

SQL Server is a great platform against which to develop, but it can also be used as a code generation tool with a little creativity. Haidong Ji brings us a few techniques that can be used to automatically build T-SQL code and bcp code for importing and exporting data.   Read more...
By Haidong Ji 2005/02/14 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 17,022 reads

Becoming More Productive

Taking a break from SQL Server and DTS, author Haidong Ji shares a few tips and tricks to becoming more productive, whether as a DBA or developer. These hints and tips could help you separate yourself from the pack come review, raise, or interview time.   Read more...
By Haidong Ji 2004/12/28 | Source: SQLServerCentral.com | Category: state of the business
Rating: |  Discuss |   Briefcase | 10,062 reads

Comparison of Oracle Drivers

Oracle is usually a dirty word in the SQL Server community, but like it or not, lots of data resides in Oracle databases. And SQL Server is often used to gather this data together in a warehouse of some sort for spinning cubes, generating reports, etc. Haidong Ji looks at the various methods that you can connect to an Oracle driver and compares the speed of each. If you need to get data from Oracle, or may need to, this is the place you want to start.   Read more...
By Haidong Ji 2004/07/21 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 15,838 reads

Using Different Techniques for SQL Server Automation

Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do.   Read more...
By Haidong Ji 2004/08/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,290 reads

Oracle and SQL Server Data Interoperability Issues - Part 1

As much as we're SQL Server folks here, sometimes we do need to connect to other data stores. Hai shares some of his experiences doing so. Might come in handy someday.   Read more...
By Haidong Ji 2008/06/06 (first published: 2004/04/14) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 45,571 reads

Review of Lumigent Entegra

We've been trying to catch up on reviews lately, Hai was kind enough to give Entegra a try and report back on it. The basic concept is that it lets you do extensive auditing without having to add triggers. If you're trying to find an auditing solution, this is worth considering.   Read more...
By Haidong Ji 2004/02/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,767 reads

Using xp_cmdshell

Haidong continues to point out ideas that might get you thinking about ways you can do more administration with less work. In this article he demonstrates a couple useful tasks you can do with xp_cmdshell.   Read more...
By Haidong Ji 2004/01/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,671 reads

Using WMI

Get started with using WMI (Windows Mgmt Instrumentation) by seeing two good scripts to start with, one to reboot the server, another to list all the services.   Read more...
By Haidong Ji 2003/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,631 reads

Using VBScript to Automate Tasks

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.   Read more...
By Haidong Ji 2008/03/07 (first published: 2003/11/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 100,283 reads

Auditing DTS Packages

In this follow up article, Haidong explains how to audit DTS packages. While parts of it are specific to DTS, the general technique has many useful applications.   Read more...
By Haidong Ji 2003/10/06 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,888 reads

Automate DTS Logging

DTS logging is a pretty handy feature - if you've got it enabled. Got lots of packages and want to turn it on for all of them? Thats a lot of point and click using EM, but with the code Haidong has put together, it's a snap. Other possibilities to this code as well. After all, it uses a DTS package to modify other DTS packages.   Read more...
By Haidong Ji 2003/09/09 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 11,958 reads

Monitoring Disk Space and Sending Alerts with TSQL

Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring!   Read more...
By Haidong Ji 2007/09/14 (first published: 2003/08/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 50,393 reads

Managing DTS packages - Editing, Scheduling, and Viewing Package Logs

In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.   Read more...
By Haidong Ji 2006/10/06 (first published: 2003/01/02) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,595 reads

Using SQL Trace to Audit Database Access

As a new DBA, you will probably walk into an environment that is poorly documented and nobody has any idea of how many SQL Servers are on the network. In the first series of articles, Haidong Ji talks about how to audit logins in your SQL Server.   Read more...
By Haidong Ji 2002/12/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,609 reads
   Items 1 to 18 of 18