Migrating multiple databases into a single Azure SQL DB
Migrating multiple databases into a single Azure SQL DB

If you have a bunch of databases that you want to migrate into a single Azure SQL DB, and the table names are all different then that’s quite easy. If you don’t mind renaming things, then there’s a solution for same-named tables too… Add/migrate one database Head over to the Azure SQL section https://portal.azure.com/#create/Microsoft.AzureSQL Create... » read more

An unhandled exception occurred while processing the request. Win32Exception: An existing connection was forcibly closed by the remote host
An unhandled exception occurred while processing the request. Win32Exception: An existing connection was forcibly closed by the remote host

Azure .NET web apps connecting to an AWS SQL database kept throwing up this error sporadically, seemingly without any pattern. The full message was this: An unhandled exception occurred while processing the request. Win32Exception: An existing connection was forcibly closed by the remote host. Unknown location.SqlException: A connection was successfully established with the server, but... » read more

Azure .NET Core Web App DirectoryNotFoundException: Could not find a part of the path
Azure .NET Core Web App DirectoryNotFoundException: Could not find a part of the path

Getting this error in an Azure .NET Core Web App deployed via GitHub? An unhandled exception occurred while processing the request. DirectoryNotFoundException: Could not find a part of the path ‘D:\home\site\wwwroot\Templates\my_file.html’. System.IO.FileStream.ValidateFileHandle(SafeFileHandle fileHandle) DirectoryNotFoundException: Could not find a part of the path ‘D:\home\site\wwwroot\Templates\my_file.html’. System.IO.FileStream.ValidateFileHandle(SafeFileHandle fileHandle) System.IO.FileStream.CreateFileOpenHandle(FileMode mode, FileShare share, FileOptions options) System.IO.FileStream..ctor(string path, FileMode mode,... » read more