nadvi.blogspot.com
ORACLE @ Work: MSSQL Server to MSSQL Server Instance connectivity with Linked Server
http://nadvi.blogspot.com/2013/07/mssql-server-to-mssql-server-instance.html
Friday, July 19, 2013. MSSQL Server to MSSQL Server Instance connectivity with Linked Server. Here are the steps:. 1 I’m going to use a user called TEST for this demonstration, and going to provide SYSADMIN privilege to this user. Once the link created and tested, I’ll revoke SYSADMIN privilege from the TEST user. 2 Login as TEST user. 3 Open SSMS, Go to Server Objects- Right Click Linked Servers- New Linked Server. The below form pops up. My “Linked Servers” has been created! Toronto, ON, Canada. MySQL ...
nadvi.blogspot.com
ORACLE @ Work: February 2013
http://nadvi.blogspot.com/2013_02_01_archive.html
Wednesday, February 20, 2013. ORA-00054: resource busy and acquire with NOWAIT specified. A common error we face on day to day life. Happens when someone tries to modify a table which is already locked by other user. Now there are couple of ways to get rid of it. Check to see which user is locking the object and then kill the session. Select a.sid, a.serial#. From v$session a, v$locked object b, dba objects c. Where b.object id = c.object id. And asid = b.session id. And OBJECT NAME='EMP';. How to increa...
bryanhoff.com
Bryan Hoff | web designer | Portfolio
http://www.bryanhoff.com/portfolio.html
Roda Farms (work in progress).
nadvi.blogspot.com
ORACLE @ Work: MySQL : Monitor live MySQL queries
http://nadvi.blogspot.com/2013/07/mysql-monitor-live-mysql-queries.html
Wednesday, July 31, 2013. MySQL : Monitor live MySQL queries. You can run the mysql command "show processlist" to see what queries are being processed at any given time, but that probably won't achieve what you're hoping for as this won’t show the whole SQL text. Here are the steps to dump sql into a file for analysis. Mysql SHOW VARIABLES LIKE "general log%";. General log file /var/run/mysqld/mysqld.log. Turn on the SQL Logging and go to the general log file location. Mysql SET GLOBAL general log = 'ON';.
nadvi.blogspot.com
ORACLE @ Work: June 2013
http://nadvi.blogspot.com/2013_06_01_archive.html
Friday, June 28, 2013. SQL Server Performance Dashboard Reports in SSMS. The step by step procedure has been published on Microsoft MSDN blogs both for 2005 and 2008. Couple of tweaks required for 2008, but everything is documented. Http:/ blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/sql-server-performance-dashboard-reports-in-ssms-introduction-install-datediff-error-amp-modified-for-sql-2008.aspx. This is how it looks like:. Links to this post. Tuesday, June 11, 2013. WHERE ptime IS NOT NULL. Mysql ...
nadvi.blogspot.com
ORACLE @ Work: March 2013
http://nadvi.blogspot.com/2013_03_01_archive.html
Wednesday, March 27, 2013. Move SQL Server transaction log files to a different location via TSQL. To optimize I/O performance of a database, it's always a good idea to keep LOG file and DATA file in separate physical drives. I'm going to show a demonstration of moving LOG files to another drive. 1: Capture database and transaction log file information. 2: Set database to single user mode and detach database. Set database to single user mode. Sp detach db 'AdventureWorks'. Now Attach the database. After ...
nadvi.blogspot.com
ORACLE @ Work: July 2013
http://nadvi.blogspot.com/2013_07_01_archive.html
Wednesday, July 31, 2013. MySQL : Monitor live MySQL queries. You can run the mysql command "show processlist" to see what queries are being processed at any given time, but that probably won't achieve what you're hoping for as this won’t show the whole SQL text. Here are the steps to dump sql into a file for analysis. Mysql SHOW VARIABLES LIKE "general log%";. General log file /var/run/mysqld/mysqld.log. Turn on the SQL Logging and go to the general log file location. Mysql SET GLOBAL general log = 'ON';.
nadvi.blogspot.com
ORACLE @ Work: July 2012
http://nadvi.blogspot.com/2012_07_01_archive.html
Wednesday, July 04, 2012. Ora-12012: Error On Auto Execute Of Job "Oracle ocm"."Mgmt config job 2 1. OCM job was failing with below error at alert log:. ORA-12012: error on auto execute of job "ORACLE OCM"."MGMT CONFIG JOB 2 1". ORA-29280: invalid directory path. ORA-06512: at "ORACLE OCM.MGMT DB LL METRICS", line 2436. ORA-06512: at line 1. This messages happen because of the OCM collection database job is unable to access the directory location where the OCM data is written . 1 export ORACLE HOME=.
nadvi.blogspot.com
ORACLE @ Work: “The program can’t start because MSVCR100.dll is missing from your computer.” error on Windows
http://nadvi.blogspot.com/2013/10/the-program-cant-start-because.html
Tuesday, October 22, 2013. 8220;The program can’t start because MSVCR100.dll is missing from your computer.” error on Windows. I was installing a software on windows 2008R2 64 bit edition and ran into this error. The program can't start because MSVCR100.dll is missing from your computer. Try reinstalling the program to fix this problem". After doing some online research I figured. Microsoft Visual C Redistributable package requires installed prior installing my desired installation. Toronto, ON, Canada.
nadvi.blogspot.com
ORACLE @ Work: What's Your Favorite Feature of SQL Server 2012?
http://nadvi.blogspot.com/2013/10/whats-your-favorite-feature-of-sql.html
Tuesday, October 01, 2013. What's Your Favorite Feature of SQL Server 2012? Subscribe to: Post Comments (Atom). Toronto, ON, Canada. BSC in Computer science, Oracle Certified Professional, Oracle Certified Expert (Administering RAC), OCE (Administering Oracle on Linux), OCE 11g (Performance tuning expert) , MCP , Microsoft SQLServer 2012 database professional. Working with Oracle Since 2005. View my complete profile. 8220;The program can’t start because MSVCR100.dll is m. DB Upgrade Troubleshoot Link.