The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)
No process is on the other end of the pipe
Recently I got the below error when trying to connect to SQL Server. There error was caused in this case because the max memory setting was set to […]
Error IDX21323 – RequireNonce is ‘[PII is hidden by default. Set the ‘ShowPII’ flag in IdentityModelEventSource.cs to true to reveal it.]
One of the best features of Azure is the ability to authenticate with Azure Active Directory. This is easy to implement and therefore a very nice way to […]
Error when installing SQL 2019 – Developer Edition
Error Message Cannot insert the value NULL into column ‘CustomContext.ClusterId’, table ‘DWDiagnostics.dbo.pdw_component_health_data_lock’; column does not allow nulls. INSERT fails. Affected Components DB Engine , Replication , Polybase , […]
SQL 2019 – TDE SUSPEND RESUME
In this video we are going to talk about transparent data encryption. Transparent data encryption is a feature in SQL server that protects data at rest. Data at […]
The Key didn’t match any rows in the table – PowerBI
When you get the below error it usually has nothing to do with primary keys or rows. In fact the majority of the time it is because you […]
Error on WebAPI after deployment to Azure App Services
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 […]
XML Validation: Declaration not found for element Error Message
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
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 […]
SQL 2019:- Truncation Error message and where it fails
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 […]