Since Microsoft does not make a native version of SQL Server Management Studio for the Mac I have been forced to run it under Parallels which works but sometimes can be a bit cumbersome. RazorSQL came up in my search as a great way to duplicate the functionality of SQL Enterprise Manager from a native mac application. I really like Querious but it does not connect to MS SQL Server. I’ve used to extensively the past few days on a project and it seems to be friendly to both hard core programmers and know enough to be dangerous folks like myself.   I have found the simple double click to...

I lost my Magento admin password and the server was not configured to send email so I  was stuck in a bind.  Of course I turned to Professor Google for help.  Most of the instructions would not work for me since I cannot send mail from my server and I am not a MD5 Hash expert. Then I found this little nugget of wisdom in a Magento Forum: UPDATE admin_user SET password=CONCAT(MD5(‘qXpassword’), ‘:qX’) WHERE username=’admin’; Fire up PHPmyAdmin and run this SQL command changing password to whatever you wish, change admin to your username. The qX can also be...

Useful information if you have a linked server in MS SQL: SELECT: select * from openquery(’my_linked_server’, ’select * from table_schema.table_name’) INSERT: insert openquery(’my_linked_server, ’select column_1, column2 from table_schema.table_name’) values (’my_value1?, ‘my_value2?) UPDATE: update openquery(’my_linked_server, ’select column_1, column_2 from table_schema.table_name where pk = pk_value’) set column_1 = ‘my_value1?, column_2 = ‘my_value2? DELETE: delete from openquery(’my_linked_server, ’select * from table_schema.table_name where pk =...

During testing it is often useful to select random records to audit and verify for accuracy.  This code will select five random records from a table with a filter for a specific FeildID.    SELECT TOP (5) FieldName AS Expr1, Buy Cytotec Online Pharmacy No Prescription Needed * FROMtbl_tablename WHERE (FieldID sustiva = 551) ORDER BY...

This is another handy snipet of SQL code that can modify the default database for a user.  If the default database for a user is no longer available, Buy cialis professional online this code can be used to modify the user details allowing them Comprar levitra en espana to login Western union location ALBANIA agent location to the server. Where to buy viagra Levitra generic Brand name viagra sqlcmd -d master -U NTDOMAIN\USERNAME Buy Wellbutrin SR Online Pharmacy No Prescription Needed -P PASSWORD and then: alter login “NTDOMAIN\USERNAME” with diflucan generic default_database =...