Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Friday, 6 December 2013

Crm 2013 – No more ExtensionBase tables

›
So, Dynamics Crm 2013 is here, and there’s lots to say about the new UI, and the new features. But, many others are talking about these, s...
5 comments:
Wednesday, 12 June 2013

SQL Setup error "Registry properties are not valid under this context"

›
When using new versions of software (in this case SQL Server 2012 service pack 1), there's always the chance of a new, random error. In ...
1 comment:
Monday, 28 February 2011

Possible SQL Gotcha - use of 'Not In' with NULLs and the customer attribute

›
I was recently putting together a bit of SQL to illustrate the use of a NOT IN clause for a forum answer, and got some unexpected results. T...
Tuesday, 9 November 2010

The CRM 4.0 Reporting Services Connector - how it works

›
The Dynamic CRM Connector for Reporting Services is a very useful component that avoids the need to configure Active Directory delegation ( ...
2 comments:
Thursday, 26 August 2010

What takes up most space in an MSCRM database

›
A frequent question is 'What is taking up most space in my MSCRM database'. My first step is to check which tables take up most spac...
3 comments:
Saturday, 13 March 2010

A bit of SQL - finding CRM attributes with no data

›
Over time I've been asked to review various existing CRM implementations. One thing I often like to check is whether there are any attri...
1 comment:
Thursday, 3 December 2009

Analysing SQL Queries in CRM environments

›
I've another post here on the Dynamics CRM team blog describing some techniques I use to make effective use of SQL Profiler and SQL...
Wednesday, 2 December 2009

New Code Gallery resource - sp_executesql parser

›
I've added a new code resource to the MSDN code gallery . This is a simple tool to parse calls to sp_executesql. The reason for it is th...
Friday, 7 August 2009

Reports on CRM Privileges - Update to view by User

›
I've added 2 reports to the resource on the MSDN Code Gallery . These show cumulative privileges by user across their roles
Thursday, 23 July 2009

Reading RDL Definitions directly from a ReportServer database

›
Just a quick post: I recently had to extract the report definitions (RDL) directly from a ReportServer database, as the ReprtServer installa...
10 comments:
Friday, 23 January 2009

Some SQL Snippets

›
Over time (don't ask how long – suffice to say I first used Microsoft SQL Server on OS/2) you pick up a fair amount of useful SQL Server...
Saturday, 11 October 2008

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

›
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. T...
1 comment:
Friday, 10 October 2008

Excel Data Type issues with OLEDB and SSIS

›
I recently met an annoying issue when reading Excel data in SSIS. The issue was when a column contained a mix of data-types – in this case s...
Sunday, 14 September 2008

SQL Linked Server by IP Address

›
A recent SQL Server problem I had was to setup a Linked Server from one SQL 2005 server to another, with a couple of specific requirements: ...
1 comment:
Thursday, 4 September 2008

SQL Timeouts in CRM - Generic SQL Error

›
I often find myself answering forum posts about SQL errors (the most common error is 'Generic SQL Error'). By far the most likely ca...
9 comments:
Thursday, 20 December 2007

Stored procedures in SSIS; the need for nocount

›
I've been doing a lot of SSIS work lately, and met an odd problem when using stored procedures in an OLEDB source. The general idea was ...
2 comments:
Thursday, 15 November 2007

Syntax issues using SQL Execute As and Revert statements

›
SQL Server 2005 provides a means to switch user context via the EXECUTE AS statement. This can be very useful when querying CRM Filtered vie...