Monthly Archives: October 2014

Fixed – Error: Invalid Serial Number. Please contact forceAmp.com for a valid key.

I encountered this error while configuring DBAMP on one of the Production Server, had to work with Salesforce Support team to understand and fix the problem. Useful notes for reference: • What is the Error while importing data or testing … Continue reading

Posted in SQL | Tagged , , , , | 1 Comment

Multiple SQL Server Query results in single Result set

Often I have to run same query against multiple Servers for analysis and club all results for presentation. I come across simple option which allows to do it all in one go… • View Registered Servers (Ctrl+Alt+G) • Create new … Continue reading

Posted in Productivity, SQL | Tagged , , , | Leave a comment

DATE format in Foxpro – Microsoft Visual Foxpro

I am using Microsoft Visual Foxpro (Version: 06.00.8167.00) to read data from Foxpro data files for one of the analysis project, had tough time to query based on date column. I have tried at least 10 different options but of … Continue reading

Posted in Productivity | Tagged , , , | Leave a comment

Gracefully shutdown SQL Server, stop accepting new connections

During maintenance activity we try to bring down SQL server gracefully without impacting existing transactions and not accepting new connections. One of the best options to accomplish this is to PAUSE SQL Service using SQL Server configuration Manager. Pausing SQL … Continue reading

Posted in Productivity, SQL | Tagged , , , , , | Leave a comment

Basics of Foxpro, Conversion failure

Recently I had a situation where my SSIS package was not able to read the data from Foxpro, error message is [Conversion failed because the data value overflowed the specified type.]; I spent long hours investigating finding actual record impacted, … Continue reading

Posted in SQL | Tagged , , | 1 Comment