tag:blogger.com,1999:blog-41392346264465055502024-02-02T09:39:59.077-08:00HSNhardware, software, network, game, database, unix, linux, redhat, microsoft, oracle, sun, java, j2ee, IBM, market, lifestyle ......Unknownnoreply@blogger.comBlogger81125tag:blogger.com,1999:blog-4139234626446505550.post-46990662524121940892009-12-10T18:34:00.000-08:002009-12-10T18:42:22.649-08:00Seven Tips for SQL Server Production DBAsUse Forfiles utility (forfiles.exe) to delete old database backup files:forfiles /p "e:\sqlbackup" /m "*.bak" /c "cmd /c del /Q @path" /d -2Use ALTER USER WITH LOGIN to repair orphaned logins.Use sp_addsrvrolemember to give yourself the sysadmin role. Use the PortQryUI utility to troubleshoot connectivity problems. Use a different strategy when running DBCC CHECKDB against large databases. Use Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-25183560855858230882009-12-09T01:23:00.000-08:002009-12-09T01:24:37.401-08:00HSN: MSSQL DBA daily jobsHSN: MSSQL DBA daily jobsUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-11472624767799477372009-12-09T01:19:00.002-08:002009-12-09T01:21:04.780-08:00MSSQL DBA daily jobsDaily maintenance jobs:Backup database.Check database integrity: check primary key etc.History cleanup: log history archive.Check indexes: rebuild index, re-organize index etc.Shrink database.Daily monitoring jobs:Monitor database connections.Monitor physical storage usage.Monitor memory usage: cache hits ratio, page reads, writes/sec etc.Monitor CPU usage.Monitor physical disk I/O, network Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-16215748215898658982009-12-09T01:19:00.000-08:002009-12-09T01:24:28.043-08:00HSN: Oracle DBA checklistHSN: Oracle DBA checklistUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-67218364378008360482009-12-09T01:18:00.000-08:002009-12-09T01:19:00.342-08:00Oracle DBA checklistDaily proceduresVerify all instances are up: run daily reports or via "Oracle Enterprise Manager's 'probe' event"Look for any new alert log entries: Check ORA-errors in $ORACLE_BASE//bdump/alert_.logVerify success of database backupVerify success of database archiving to tapeVerify enough resource for acceptable performance:a. Verify free space in tablespaces (free.sql, space.sql)b. Verify Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-49352099629619577572009-12-09T00:41:00.000-08:002009-12-09T00:42:24.396-08:00HSN: 股票买卖操盘策略HSN: 股票买卖操盘策略Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-25156015305875659882009-12-09T00:30:00.000-08:002009-12-09T01:05:10.504-08:00股票买卖操盘策略根据美国次贷危机,中国A股崩盘,网络泡沫破裂,911危机及亚洲金融风暴经验,股市通常会下跌到1/5位置,甚至会到达1/10, 在此调整操盘策略: 买入:跌幅 百分比 买入金额-20% 81% 1000 (短期) :从近期高处下跌-20% 63% 1 / 4 (短期)-20% 45% 1 / 3 (中期)-20% 36% 1/2 (中期)-20% 25% 1 (长期)-20% 15% reserved 1/2 (长期)卖出:涨幅 百分比 卖出金额 +30% 130% 1000 (短期) :从近期低处上涨+30% 170% 1 / 4 (中期) :中期走势+30% 220% 1 / 3 (中期)+30% 280% 1 / 2 (长期)+30% 350%Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-27241094240279451452009-12-09T00:19:00.001-08:002009-12-09T00:20:19.032-08:00HSN: Replication Configuration Between MSSQL 2005 and OracleHSN: Replication Configuration Between MSSQL 2005 and OracleUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-47209083665371478522009-12-09T00:19:00.000-08:002009-12-09T00:20:19.033-08:00HSN: VMs vs. Multiple SQL Server InstancesHSN: VMs vs. Multiple SQL Server InstancesUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-29784351683152706392009-12-09T00:18:00.000-08:002009-12-09T00:20:10.974-08:00HSN: Steps to set up oracle database RACHSN: Steps to set up oracle database RACUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-21433003732892173622009-12-09T00:17:00.001-08:002009-12-09T00:19:59.102-08:00HSN: 基金买卖操盘方式HSN: 基金买卖操盘方式Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-19757000132770187732009-12-09T00:17:00.000-08:002009-12-09T00:19:59.103-08:00HSN: 我的投资策略HSN: 我的投资策略Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-9561343652848798612009-12-09T00:16:00.000-08:002009-12-09T00:19:59.104-08:00HSN: 如何从MACD指标研判股市走势?HSN: 如何从MACD指标研判股市走势?Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-12843598854043466892009-12-09T00:14:00.000-08:002009-12-09T00:14:30.178-08:00HSN: Dollar Cost AveragingHSN: Dollar Cost AveragingUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-65262848610769341802009-12-09T00:10:00.001-08:002009-12-09T00:13:46.401-08:00HSN: 4 ways to be a millionaireHSN: 4 ways to be a millionaireUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-3999881396779570242009-12-09T00:10:00.000-08:002009-12-09T00:13:46.402-08:00HSN: All Money SenseHSN: All Money SenseUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-74598263441115004292009-12-09T00:09:00.000-08:002009-12-09T00:09:42.118-08:00HSN: Linux User Guide (2)HSN: Linux User Guide (2)Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-84198612606621682572009-12-09T00:08:00.000-08:002009-12-09T00:09:42.119-08:00HSN: Linux User Guide (1)HSN: Linux User Guide (1)Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-87456659985989968392009-12-08T23:43:00.002-08:002009-12-08T23:44:46.145-08:00HSN: Oracle Dictionary - DBA ViewsHSN: Oracle Dictionary - DBA ViewsUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-5575591204610199832009-12-08T23:43:00.001-08:002009-12-08T23:44:46.146-08:00HSN: Oracle Dictionary - All ViewsHSN: Oracle Dictionary - All ViewsUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-28101138060705483332009-12-08T23:43:00.000-08:002009-12-08T23:44:46.146-08:00HSN: Oracle Dictionary - Dynamic ViewsHSN: Oracle Dictionary - Dynamic ViewsUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-87637465434371332092009-12-08T23:42:00.000-08:002009-12-08T23:44:46.146-08:00HSN: Oracle Dictionary - User ViewsHSN: Oracle Dictionary - User ViewsUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-90450984974007197752009-12-08T23:33:00.000-08:002009-12-08T23:34:15.653-08:00HSN: SCJP 310-035 Sample Questions (1)HSN: SCJP 310-035 Sample Questions (1)Unknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-91652149977705275272009-12-08T23:32:00.001-08:002009-12-08T23:34:15.654-08:00HSN: Sun Certified Web Component Developer 310-081 Sample QuestionsHSN: Sun Certified Web Component Developer 310-081 Sample QuestionsUnknownnoreply@blogger.comtag:blogger.com,1999:blog-4139234626446505550.post-66115296508123693182009-12-08T23:32:00.000-08:002009-12-08T23:34:15.654-08:00HSN: J2EE PatternsHSN: J2EE PatternsUnknownnoreply@blogger.com