Dealing with “SQL Bulk Copy failed due to received an invalid column length from the bcp client” Errors in Azure Data Factory

When you are amid a pesky IT issue, it can be difficult determining whether the problem is down to a bug/system fault or human error. Like this recent example involving Azure Data Factory illustrates, it is generally best to assume the latter, to avoid any prolonged difficulty.

Resolving AADSTS50126: Invalid username or password Errors During Azure SQL Database Deployment Task (Azure DevOps Pipelines)

We saw a few weeks ago how to utilise Azure Active Directory (AAD) Security Groups to manage Azure SQL database access at scale. When using this feature, you must ensure database changes are deployed out using an AAD administrator account or similar, a task which may be difficult to achieve in an Azure DevOps Pipeline.

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

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