Category Archives: Microsoft SQL Server
Click through to CRM records from SSRS custom report for Microsfot Dynamics CRM 4. Linking information on SQL Reporting Services custom CRM reports to Dynamics CRM 4 records and opening them up from within the report.
Click through to CRM records from SSRS custom report for Microsfot Dynamics CRM 4. Linking information on SQL Reporting Services custom CRM reports to Dynamics CRM 4 records and opening them up from within the report.
Return and display picklist value (display value) in custom sql report reporting services report in Microsoft Dynamics CRM 4 entity attribute and StringMap picklist values table
Normally, you should be able to get the picklist display value and picklist item id in the filtered view of any entity. In some cases, you may need to work with StringMap table directly to get the picklist values for a specific field of a given entity. This could be the case if you are [...]
Configure Microsoft SQL Server to allow remote connection and remote SQL Management Studio access
To get straight to the point. I have been trying to setup Microsoft SQL Server 2008 to allow remote connection and specifically I wanted the SQL server to allow SQL Server Management Studio on a different computer completely outside the network to be able to access this remote SQL Server and manage it fully without [...]
Error with Report Server
We have been recently approached by a client who had a problem with their report server. If you try to access reports from the reports manager, reports run fine and you can view any report fully and in the right format. The problem arrises when a .NET application tries to open these reports, it just [...]
Improving Microsoft Dynamics CRM Performance Enhancements & Optimization and CRM Server maintenance and improvements
Microsoft Dynamics CRM Performance enhancements, optimisation and maintenance can be divided into three main areas: – Performance enhancements at Client level: networking issues such cache expiration times, latency and bandwidth – Optimisation at application level: plugins, sdk code, – and, improvements at Data layer: Indexes, (physical data layout) This post is based on Microsoft recommendations [...]