George Zhou Zhiqing

LOAD LINUX HPUX disk space info through ORACLE external table into SQL SERVER TABLE I have exported all my Windows Disk info from SQL server views into my Metrics database, so that I can expect the disk growth and check if disk is going to full in how many days. (will introduce next time). But for my 10 oracle physical servers, I manually collect to Excel and import to SQL table, present in SSRS report. This is time consuming. Today I have create on external table in ORACLE and made it happen automatically, same like my other SQL night DBA, ORACLE night DBA (backup alert) etc. my Oracle servers on a few HP UX servers and a few LINUX servers, except some part (I listed two), most are same for both systems. Thanks to  https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5088536900346242095  ----create directory >mkdir -p /home/oracle/diskspace --create run_df.sh      > [9004] $ vi .bashrc      export PATH=$PATH:/ho...

Developing Nightly DBA PACKAGE for MS SQL SERVER and ORACLE CHECK IF SQL AGENT JOB RUNNING Scenario: 1 DBA, 200+ MSSQL instances (PM, VM), 1700+ MSSQL databases, version 2000-2016  10 Oracle machines(Windows, Linux, HPUX), 30 Oracle Databases. version 10g-12c to be able to manage such big amount of MSSQL and Oracle databases, an automatically monitored system is required to highlight only the instances/database to be checked every morning. Tool to be used: MSSQL, SSIS , SSAS, SSRS CHECK IF SQL AGENT JOB RUNNING it would be easy to check if the sql agent job running when you have very small amount of SQL Servers to monitor, by just check it in SSMS, but it would be difficult or impossible to check when you have 200+ SQL servers as you have many many other important things to check and fix. We used to tool nagios to check if a Windows service is stopped until recently we have a situation as I asked  https://social.msdn.microsoft.com/Forums/sqlserver/en-U...

random memo one of the many differences between Oracle and SQL, to be continued. Oracle uses REDO log roll forward and uses UNDO tablespace to rollback, though theoretically can use redo(transaction log)  log to rollback but not efficient. SQL server uses transaction log to roll forward androll back. Noticed a good summary of Differences between UNDO and REDO in oracle by Francisco Munoz Alvarez https://oraclenz.wordpress.com/2008/06/22/differences-between-undo-and-redo/ difference of Schema:  Schema is collection of objects, in SQL, create user doesn't create schema, in oracle then it does in oracle a  user and a schema have the same name, but SQL doesn't have to

Scenario: 1 DBA, 200+ MSSQL instances (PM, VM), 1700+ MSSQL databases, version 2000-2016  10 Oracle machines(Windows, Linux, HPUX), 30 Oracle Databases. version 10g-12c to be able to manage such big amount of MSSQL and Oracle databases, an automatically monitored system is required to highlight only the instances/database to be checked every morning. Tool to be used: MSSQL, SSIS , SSAS, SSRS Data to be collected and analyzed Instance and Databases properties, hardware info, CPU, Memory, DiskIO, latency, waits, Part one: Design Database to store metric data

I received today's posts from Brent Ozar, I feel it is very interesting, LOL: Brent Ozar says: Stop People From Changing Tables with This One Trick Brace yourselves. Our Black Friday sale is coming. Developers hate his bad idea jeans: CREATE VIEW dbo.StopThemDead WITH SCHEMABINDING AS SELECT COUNT(*) FROM dbo.Table1 UNION ALL SELECT COUNT(*) FROM dbo.Table2 UNION ALL.... Presto, the schemabinding option means no one can change the underlying tables. (At least, until they figure out about your view.) Obligatory disclaimer: seriously, this is a really bad idea. But it’s hilarious.

Though Lily had perfect 5/5 score being 1st place under K-8 Section in 2013, 2014, she will be absent from this year's Michigan Scholastic tournament, I am too tired to bring her to such tournaments. Windsor will still send a huge strong team to participate all k-3, k-5, k-8,k-12 sections. Good luck to every Windsor players.

For many years, it is ambiguous as no Microsoft license expert is sure that SSMS should be licensed if it is installed on a separate server other than database engine. But we know it should be licensed after reading their document again and again. Now excited news is confirmed that SSMS 2016 is free to install on any computers, https://msdn.microsoft.com/en-us/library/mt238290.aspx