Monthly Archives: April 2018

Snapshot isolation level when database is set to read only.

By | April 27, 2018

Recently there was a question posted on #sqlhelp about why a database switched to Snapshot isolation level when you make it read only and then reverts back to read committed mode when its switched back to read write. You can use the below script to recreate the behavior being described [codesyntax lang=”tsql”] if exists (select… Read More »

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 »

#sqlhelp | should you remove indexes from tables before ETL?

By | April 15, 2018

Starting today we are introducing a new type of blog content which covers questions from #sqlhelp. We pick random questions from the feed and try to cover them in detail, while trying to explore other options or scenarios that might not be so obvious. The Questions is should you remove the index before doing ETL?… 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 »