Top 10 Most Viewed CRM Chap Blog Posts

Slight change of pace with this week's blog post, which will be a fairly condensed and self-indulgent affair - due to personal circumstances, I have been waylaid somewhat when it comes to producing content for the blog and I have also been unable to make any further progress with my new YouTube video series. Hoping [...]

Resolving “Failed to decrypt an encrypted XML node because the password was not specified or not correct” Error (SSIS)

If you are looking at automating the execution of SQL Server Integration Services .dtsx packages, then there are a few options at your disposal. The recommended and most streamlined route is to utilise the SSIDB catalog and deploy your packages to the catalog from within Visual Studio. This gives you additional flexibility if, when working [...]

Getting Around SQL Server Table Restrictions (Microsoft Flow)

Microsoft Flow is a tool that I increasingly have to bring front and centre when considering how to straightforwardly accommodate certain business requirements. The problem I have had with it, at times, is that there are often some notable caveats when attempting to achieve something that looks relatively simple from the outset. A good example [...]

Using Azure SQL Database Firewall Rules with Database Projects (Visual Studio)

The world of database security and protection can be a difficult path to tread at times. I often find myself having to adopt a "tin-foil hat" approach, obsessing over the smallest potential vulnerability that a database could be compromised with. This thought process can be considered easy compared with any protective steps that need to [...]

Resolving GUID SSIS Import Error “The value could not be converted because of a potential loss of data”

Perhaps one of the most fiendish aspects of working with SQL Server Integration Services (SSIS) is the inevitable data transformation/conversion issues that get thrown up, even as part of relatively simplistic Extract, Transform & Load (ETL) packages. It doesn't help as well if, having come from a strictly T-SQL focused background, you are then having [...]

Combining T-SQL Sub Queries with CHECK Constraints

The biggest headache when managing any database system is enforcing data quality and consistency across the entire dataset. This can range from ensuring that field values are entered correctly through to enforcing rules to prevent duplicate records from even touching the periphery of your database. If you are using an application like CRM Online/Dynamics 365 [...]

What’s New in SQL Server 2017

The very recent Microsoft Data Amp event provided an excellent forum for the SQL Server 2017 announcement, which is due to be released at some point this year. Perhaps the most touted feature of the new version is that it will be available to be installed on Linux; an entirely inconceivable premise 10 years ago, which [...]

Using SQL Server Functions to Simplify Option Set Label Retrieval (Dynamics 365 for Enterprise Data Export Service)

When you have spent any length of time working with Dynamics CRM Online/Dynamics 365 for Enterprise (D365E) data programmatically, you become accustomed to how Option Set, State and Status Reason values are presented to you in code. To explain, the application does not store your Option Set value display names within the SQL Server Entity [...]

Microsoft Dynamics 365 Data Export Service: Review

Although CRM Online/Dynamics 365 for Enterprise (D365E) does provide a plethora of different tools aimed at satisfying reporting requirements for users of the application, you are restricted in how data can be queried within the application. For example, you cannot just connect straight up to the applications SQL database and start writing stored procedures that perform complex [...]