SSIS MySQL to Azure SQL using Visual Studio 2015

Introduction Recently I had the pleasure of using SSIS (SQL Server Integration Services) to transfer a database from a remote MySQL database to an Azure SQL database in the cloud. This post describes the steps in transferring the data using SSIS through Visual Studio 2015 and the integrated BI Data Tools. What is SSIS? Microsoft … Continue reading SSIS MySQL to Azure SQL using Visual Studio 2015

Enterprise Library 6 Semantic Logging to Azure SQL Database

What is the Semantic Logging block? Any time I need to log to a database, flat file, console, or event viewer I always go back to the Microsoft Enterprise Library. The Enterprise Library is a set of components created by Microsoft to simplify and standardise common software development using best practice and patterns. Microsoft describe … Continue reading Enterprise Library 6 Semantic Logging to Azure SQL Database