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,012 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,166 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,071 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,429 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
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers