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 »
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 »
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 »
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 »
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 »