by Eric Isaacs | Jul 13, 2016 | Blog, Microsoft Dynamics, Microsoft SQL Server, Uncategorized
We were using KingswaySoft to import hundreds of thousands of Activities (Emails, Phone Calls, Tasks, Appointments) into Microsoft Dynamics CRM 2011. Importing that many rows can be time consuming, so we opted to utilize Microsoft’s Balanced Data Distributor within…
by Eric Isaacs | Mar 16, 2016 | Blog, Microsoft SQL Server
Occasionally I get questions about how to create a T-SQL result set with dynamic column names. Similarly I see people with issues creating temporary tables with dynamic column names. While it’s easy to create an entirely dynamic SQL statement that can display…
by Chris Scott | Oct 27, 2015 | Blog, Microsoft Dynamics CRM and Salesforce.com
Microsoft Dynamics CRM and Salesforce both offer proprietary languages to query the respective platform’s databases. In this post, I will provide a comparison of FetchXML (Microsoft) and SOQL (Salesforce) and how they relate to Transact SQL (T-SQL, Microsoft’s…
by Aaron Elder | Oct 8, 2015 | Blog
We recently helped a customer troubleshoot some SQL 2014 timeout issues in an Azure hosted environment. In this instance, the Azure VM was a well powered G-Series machine with a properly configured Storage Space stripe set of drives. The behavior seen was that SQL…
by Chris Scott | Aug 7, 2014 | Blog, Salesforce.com
Salesforce is arguably one of the better CRM systems available on the market today. However, it comes with certain restrictions that make integrating it with other systems difficult. Salesforce has its own data structures, query language and syntax. In addition,…