Get to know Jayanth

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

Errors

XML Validation: Declaration not found for element Error Message

Posted on: January 10, 2019June 27, 2025

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

administration / Database / Errors / TSQL

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

Posted on: January 3, 2019June 27, 2025

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

MSBI

Adding CSV files as linked Server Connection

Posted on: January 2, 2019June 27, 2025

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

Errors / TSQL

SQL 2019:- Truncation Error message and where it fails

Posted on: December 6, 2018June 27, 2025

I was wondering if I should even bother checking this feature out since it was pretty obvious what it does and how useful it is. I can’t even […]

TSQL

SQL 2019:- Table Variable deferred compilation – PART 2

Posted on: December 3, 2018June 27, 2025

In the last post we ended with two questions remaining unanswered. Shouldn’t a more accurate row count have resulted in the correct amount of memory being granted and […]

TSQL

SQL 2019:- Table Variable deferred compilation

Posted on: November 30, 2018June 27, 2025

One of the features being released in SQL 2019 that has got some attention is table variable deferred compilation. As its name suggests it applies to Table Variables […]