Exam 70-778 Revision Notes: Cleansing Data

Welcome to the third post in my series on Microsoft Exam 70-778, where I aim to provide a detailed overview and description of the skills needed to tackle the exam successfully. We saw in the previous post how we could use the Power Query Editor to perform a multitude of different transformations against data sources; [...]

Handling British Summer Time/Daylight Savings Time in Azure SQL

Is it just me or is British Summer Time (BST) AKA Daylight Saving Time (DST) an utterly pointless endeavour these days? Admittedly, on its introduction in 1916, it fulfilled a sensible objective - to provide more daylight hours during the summer. For agricultural, construction or other services that are reliant on sufficient light to carry [...]

‘Could not create a managed connection manager’ Error Message on SSISDB .dtsx Package Execution

SQL Server Integration Services (SSIS) package execution can always throw up a few spanners, particularly when it comes to the task of deploying packages out to a SQL Server SSISDB catalog - principally, a specialised database for the storage of .dtsx packages, execution settings and other handy profile info to assist with automation. Problems can [...]

‘An unexpected error occured while processing the request’ Error when Downscaling an Azure SQL Database

When considering whether or not to shift your existing SQL workloads to a single database offering on Azure SQL, one of the major pros is the breadth of capabilities the service can offer when compared with other vendors or in comparison to SQL Server on an Azure Virtual Machine. A list of these may include: [...]

Using Microsoft Flow to Extract SendGrid Statistics to a SQL Database

If you are looking for an easy-to-use and highly expandable mail relay service, SendGrid represents the most developer-friendly solution out in the market today. What's even better is that it's available on Azure, making it the ideal choice if you are developing an existing solution on the Azure stack. The best thing I like about [...]

Evaluating Database Encryption Options for SQL Server

This week's blog post is sponsored by ActiveCrypt Software. Encryption appears to be a topic of near constant discussion at the moment, spearheaded primarily by the impending deadline of the General Data Protection Regulations (GDPR). These are, in essence, a new set of data protection rules that will apply to all organisations operating within the [...]

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 [...]