Blogspot - nadvi.blogspot.com - ORACLE @ Work
General Information:
Latest News:
MySQL Import Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes 23 Aug 2013 | 05:54 pm
Today I was importing a MySQL database and ran into this Error “Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes”. Basically , When you dump table data from MySQL, you may end up pull...
MySQL : Monitor live MySQL queries 31 Jul 2013 | 07:44 pm
mysql> SHOW VARIABLES LIKE "general_log%"; +------------------+----------------------------+ | Variable_name | Value | +------------------+----------------------------+ | g...
MSSQL : Bring database back to normal from Restoring State 27 Jul 2013 | 01:17 am
If you are restoring a database using multiple backup files, you would use the WITH NORECOVERY option for each restore except the last. If your database is still in the restoring state and you want to...
SQL Server: Linked Server is not configured for RPC error: 19 Jul 2013 | 06:44 pm
Workaround for calling table-valued function remotely in SQL Server over Linked Server needs some fancy in the coding. Something like this EXEC SERVER_LINK.DATABASE_NAME..sp_executesql N'SELECT value...
MSSQL Server to MSSQL Server Instance connectivity with Linked Server 19 Jul 2013 | 06:39 pm
In order to create LINKED Server the user needs to have SYSADMIN privileges. Here in this demonstration I’m going to show the preferred LINKED SERVER option called “Be made using the login’s current s...
SQL Server - Maintenace plan integrity checks fail with "Alter Failed for server xxx" 18 Jul 2013 | 06:14 pm
My maintenance plan integrity check task was failing with "Alter failed for server XXX". After tracing i found the maintenance plan executes sp_configure 'USER OPTIONS',xxxx followed by RECONFIGURE.....
SQL Server Performance Dashboard Reports in SSMS 28 Jun 2013 | 09:03 pm
The step by step procedure has been published on Microsoft MSDN blogs both for 2005 & 2008. Couple of tweaks required for 2008, but everything is documented. Here's the link. http://blogs.msdn.com/b/...
When did a user changed his password in Oracle? 11 Jun 2013 | 08:42 pm
The table sys.user$ contains the field ptime, which keeps the time when the password was changed the last time over. Do not confound it with ctime, which is the "creation time", nor with ltime, which ...
Recover MySQL Root Password 7 Jun 2013 | 11:25 pm
/usr/bin/mysqladmin -u root password 'new-password’ /etc/init.d/mysql stop mysqld_safe --skip-grant-tables & mysql -u root mysql> use mysql; mysql> update user set password=PASSWORD("NEW-PASSWORD...
Create oracle as is user 5 Jun 2013 | 01:50 am
The following script takes the input for SOURCE user and for the user I want to create. This script can go through many customization to suit your needs. This can extract existing user hash password, ...
