Category Archives: SQL 2008

SQL 2008 Posts

Find all workflows where a field is used (Onprem only)

I have a customer with a TON of workflows and custom fields. I needed to figure out everywhere that a field was used in the workflows. After doing some Poking around in the database I created a simple SQL statement … Continue reading

Posted in CRM 2013, CRM 2015, CRM 2016, Development, Onpremise, SQL, SQL 2005, SQL 2008, SQL 2012, SQL Server | Leave a comment

AsyncOperationBase Table: Here we go again

It never fails, all is going good and then one of our QA environments (on premise) is having Workflow issues. I needed to look into what was happening on the SQL Server to understand what needed to happen. However, the … Continue reading

Posted in Onpremise, performance, SQL, SQL 2005, SQL 2008, SQL 2012, SQL Server | Leave a comment

SQL Server: The instance name must be the same as computer name

Saturday, 11 October 2008 Posted by David Jennaway at 10:11 This is something I’ve posted about on newsgroups, but one of my colleagues encountered it recently, and I think it deserves a blog entry. The CRM Environment Diagnostics Wizard may … Continue reading

Posted in SQL 2005, SQL 2008 | Leave a comment

Debugging CRM Plug-ins, Stored Procedures & Custom Workflow Activities

by Danny Varghese 02.24.09 Whether it’s developing CRM plug-ins, custom workflow activities, or writing stored procedures against the CRM database, the most useful tool I’ve used is the Microsoft Visual Studio Debugger. The debugger allows developers to step through the … Continue reading

Posted in SQL 2005, SQL 2008, SQL Integration Services | Leave a comment

Improving Microsoft Dynamics CRM Performance and Securing Data with Microsoft SQL Server 2008

Microsoft SQL Server® 2008 contains a variety of features that, when implemented properly, can improve the performance of a Microsoft Dynamics® CRM 4.0 implementation and secure the data within that deployment. These Microsoft SQL Server 2008 features include: – Compression … Continue reading

Posted in performance, SQL 2008 | Leave a comment