Monthly Archives: January 2019

Error on WebAPI after deployment to Azure App Services

By | January 15, 2019

Encountered this below error today while deploying a WebApI to Azure App Services. Initially it wasn’t very clear what the error was about so we checked the bin folder for the below assembly but couldn’t find it. Since the API was working locally the answer had to be a configuration change from Dev to Prod… Read More »

XML Validation: Declaration not found for element Error Message

By | January 10, 2019

Often when working with XML data type we encounter issues with the schema validation for the incoming XML. SQL Server does allow us to have XML datatype without schema binding. However it is a best practice to enforce Schema Binding so that we can improve data validation as well as index performance when querying the… Read More »

Finding candidate keys/Primary keys from data that needs to be imported

By | January 3, 2019

This is a continuation from the previous post where we went and inserted data from multiple CSV files into SQL server tables using linked server connection. Often the next step is to identify how the tables are related to each other. While there is no guarantee that the relationships defined here are 100% accurate it… Read More »

Adding CSV files as linked Server Connection

By | January 2, 2019

I often get a lot of migration projects where the data needs to port from CSV format into SQL Server. Here is a quick way I achieve it using Linked Server Connection in SQL Server. Why use Linked Server? Because it is very simple and easy to do. I could do the same using say… Read More »