Skip to main content

Posts

Showing posts from August, 2014

MySQL Workbench and MS Excel

I am a big fan of SOL Server since start of my career and will be long life may be god knows..  My SOL added in my resume in 2014. No doubt SOL Server is reach in feature and capabilities than MySQL. But today I am sharing you about MySQL's great feature that impressed me related to MySQL Excel Integration. MySQL is really very simple and light application, easy to manage and implement.
Yesterday I was working on Excel and I seen an extra add ins option in Excel for MySQL Workbench. I followed the option. Really it impressed me.. Just see below…

Remote Access Enabling in MySQL using Workbench

MySQL became part of my skill set in 2014. After installation of any instance of MySQL Server in Production or Test environment 2nd most task for any DBA is to connect the Database from Remote. While i was new with MySQL it played with me a lot to do this task from remote machine. I hang over for 3 days and ask many ppl and search many site. Did telnet, ip-config, firewall et………….. but resolve my problem in easy through below process… 1st Grant Remote Permission on Database Server2nd Configure Connection at client workbench to server

safe update mode updates in mySQL workbench error

Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

above error came in MySQL Workbench 5.2. During executing update command on table using MySQL Workbench 5.2. while updating rows.
update bl_user set user_email='smnjha989@gmail.com' where user_name='suman';

File attachment or query results size exceeds allowable value of 1000000 bytes

Msg 22051, Level 16, State 1, Line 0 File attachment or query results size exceeds allowable value of 1000000 bytes.
Hi fiernd, after 3 days illness now i am back in work and trying to short out some issues. Recently I got some error on Database mail, the error I face in SQL Server Database mail while sending bigger attachment using below query.

Operating system error 5(Access is denied.)

Actually I should write this post before my last post Network shared Backup , which I shared yesterday. I have decided I will share this week on network database activity. Show this is my 2nd post on the same. While I was started to backup, restore and creating a database on network shares I faced below errors. And most of the cases issues are related to Start-up services. Generally when we install SQL server the service will be Local or Network in this situation it will not work until we will not change start-up services or we will give full access to the network shared folder.  

Backup-Restore on Network Shared drive

Hi friends,
This is my post on Backup-Restore on Network Shared drive. After 2 days holidays coming back on job is difficult task and today I am not well due to cold. I did some wrong with myself eaten sweets more and after that cold water. SO my throat is not working properly.

Actually Every Enterprise is facing with Crunch of resources for running application and keeping backups. Sometime we require to restore database and we have no more space on local server drive. We all facing in our life as a SQL-DBA. If you have space on Shared drive then we can use it for our backup-restore task test activity. I am sharing you how to do on Network shared drive below tasks but be sure SQL have proper access on such drive or shares :-

How to add an article in Transactional Replication

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process.
To add an article In Transaction replication with PUSH Subscription 

Definition='MachineToApplication'

Error: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS." I faced with above error while implementing VB.net+MySQL application yesterday in the company where I am working. Actually this error will come when Virtual Directory is not being configured as an ASP.NET application. To do so we have to follow below steps :-