Monthly Archives: April 2018

Cannot use row granularity hint on the table

By | April 16, 2018

Got approached with the below error message recently and thought it might be an interesting problem to look into. ProgrammingError((\’42000\’, 651, \'[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot use the ROW granularity hint on the table “XXXXXX” because locking at the specified granularity is inhibited.\’, 11159)  The client faces this issue when they implement a clustered… Read More »

The-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn -FIXED

By | April 9, 2018

Interesting little problem came up today when migrating a database from Azure SQL database to local server. The connections sting in the web app had the following property set Encrypt=True; TrustServerCertificate=False   The combination of the two keywords ensures that data transfer from Website to Database server is encrypted using a certificate generated by the… Read More »

Does god exist? A BI guy’s dilemma

By | April 8, 2018

You must be wondering what the heck this means? To give you some context I was recently asked if I believed in God. The answer is:- As a kid yes because my parents were god fearing and I copied them when it came to concepts I didn’t have a clear understanding of. As a teenager… Read More »