Browse by Tags

Stop Using OPENXML (Please...)

As we all know by now, the xml data type is one of the new features introduced in SQL Server 2005. The xml data type has a handy feature for shredding XML data, the nodes() method; but based on newsgroup postings and various articles on SQL Server 2005 XML it seems that developers are still stuck in...

Posted to Pseudo-Random (Weblog) by Mike C on 01-20-2008
Stoopid Tech Interviewer Tricks

OK, so you’ve got your suit fresh from the drycleaners. Your shirt is pressed and your shoes are shined. You’ve gone over the job requirements a dozen times, and even took the time to scan BOL for obscure tips the interviewer might try to turn into trick questions. All that hard work and now you find...

Posted to Pseudo-Random (Weblog) by Mike C on 01-15-2008
Problems with Oracle Migration Workbench

Database vendors like to bash each other, sponsoring dubious “objective industry studies” to “prove” they are better than others. All of them do it. In my opinion, Oracle is particularly bad in this regard, compared against IBM DB2 or Microsoft Sql Server. Talking about “unbreakable...

Posted to Haidong Ji (Weblog) by hji on 10-09-2007
Monitoring error logs in Oracle and Sql Server

In Oracle, there are 3 places that I know of that are important for monitoring: the bdump, where background process error is stored; udump, where user trace error is dumped; and cdump, the core dump, where Oracle internal error is dumped. cdump is in the binary format, you can use “strings -a” to look...

Posted to Haidong Ji (Weblog) by hji on 03-07-2007
Best way to represent date value in Sql Server

I am going through Kalen Delaney and Itzik Ben-Gan’s Inside Sql Server 2005 books. I am surprised and happy to learn that you can always represents date/time value in the format of [YY]YYMMDD[ HH:MI[:SS][.MMM]] in Sql Server, with things inside the square bracket being optional. In fact, that is...

Posted to Haidong Ji (Weblog) by hji on 02-05-2007
PASS Reports 20061116

It is good to be at PASS Sql Server conference in Seattle. Most people here have this kindred Sql Server spirit. Since we all have this in common, it is easy to start a conversation with pretty much anybody. All you need to do is to smile, greet each other warmly, and share your own stories that a lot...

Posted to Haidong Ji (Weblog) by hji on 11-16-2006
At PASS conference in Seattle

After 2 hours of flight delay, I’ve made it to Seattle. I am attending PASS Sql Server conference here. No, not the P.A.S.S. above. (I got that picture from a place not too far from where I work in Chicago area.) The PASS I am talking about here is Professional Association for Sql Server . I met...

Posted to Haidong Ji (Weblog) by hji on 11-13-2006
Transferring files to a box with McAfee VirusScan

If you have McAfee VirusScan on your server, most likely the On-Access Scan feature is enabled. This is good but can cause you problems when you transfer files to the server. For example, say you want to copy some install media to \\MyServer\C$, most likely it contains files like autorun.exe, autorun...

Posted to Haidong Ji (Weblog) by hji on 09-29-2006
Connect to a different database server within command line utility

In sqlcmd, you can connect to a different server by this command: :connect MyServer The above command will attempt to use integrated / Windows Active Directory authentication. To use traditional Sql Server authentication, use this instead: :connect MyServer -U MyLogin You can do the same kind of thing...

Posted to Haidong Ji (Weblog) by hji on 05-09-2006
Creative ways for ego boost

The book I co-wrote on Sql Server Integration Service (formerly know as DTS) has been selling pretty well at Amazon. I received 10 copies from the publisher a few weeks ago. I must confess that I felt pretty good seeing my own picture on the book cover . It should reach bookstores soon. However, don...

Posted to Haidong Ji (Weblog) by hji on 02-09-2006

Page 1 of 3 (29 items) 1 2 3 Next >