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.
2008-06-06 (first published: 2004-04-14)
46,266 reads
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.
2008-03-07 (first published: 2003-11-04)
103,014 reads
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!
2007-10-01 (first published: 2003-08-13)
54,168 reads
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.
2006-10-06 (first published: 2003-01-02)
41,798 reads
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.
2006-05-22
10,600 reads
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.
2006-01-24
12,072 reads
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.
2006-01-11
18,432 reads
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.
2005-10-10
3,263 reads
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.
2005-02-14
17,976 reads
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.
2004-12-28
10,122 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers