Browse by Tags

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
How long has my Sql Server been running

Sometimes you want to know how long you Sql Server has been running. There are a number of ways to find that out. You can start from Sql Server error log. Go all the way to the beginning of your currect error log, assuming you have not recycled the error log manually, and look at the time stamp there...

Posted to Haidong Ji (Weblog) by hji on 10-08-2007
Backup from Sql Server 2005 cannot be restored on Sql Server 2000

In this post , I mentioned that you can restore a Sql Server backup file to a Sql Server 2005 server. You cannot do it the other way, though. A backup taken on Sql Server 2005 cannot be restored on a Sql Server 2000 server. If you try, this is the likely message you will get: Msg 3169, Level 16, State...

Posted to Haidong Ji (Weblog) by hji on 10-05-2007
C2 and Common Criteria Compliance

In Sql Server 2000, C2 auditing is a US government standard that monitors database security. When it is enabled, a trace will be created to collect all Security Audit related events, 21 or so of them. You can find what those events are by browsing through them in Profiler. By default, the trace file...

Posted to Haidong Ji (Weblog) by hji on 03-22-2007
A few handy Sql Server tips

Here are a few handy tips I learned lately: 1. When using sp_configure, you don’t need to type the whole parameter string. You just need to type enough of it for Sql Server to be uniquely identify it. For example, sp_configure ’show ad’ will resolve to sp_configure ’show advanced’...

Posted to Haidong Ji (Weblog) by hji on 03-22-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
Enable File and Printer Sharing for Microsoft Networks for cluster install

I talked about one issue when setting up Sql cluster here . Recently I came across another problem while setting up a Sql Server 2000 cluster on a 2-node Windows 2003 cluster. The error occurred at the step where you were asked to provide a login that can get into the remote node(s), server(s) where...

Posted to Haidong Ji (Weblog) by hji on 02-09-2007
Assign SELECT results into variables

I mentioned here that SELECT INTO in Sql Server is functionally similar to CREATE TABLE AS in Oracle . Oracle also has SELECT INTO, but it is used for assigning query results to a variable. Here is a PL/SQL code snippet: declare MyVariable varchar2(20); Begin select ColumnName into MyVariable from MyTable...

Posted to Haidong Ji (Weblog) by hji on 02-08-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
Hot fix for SP4 is cluster-aware

Service Pack 4 for Sql Server 2000 introduced a bug . After it is installed, if Address Windowing Extentions (AWE) support is enabled, a single instance of SQL Server 2000 can only use a maximum of 50 percent of the physical memory that is on the server. Microsoft has a hot fix for that problem here...

Posted to Haidong Ji (Weblog) by hji on 01-24-2007

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