Implicit vs Explicit transactions
Recently I was reminded about a query tuning technique that I have learned some time ago. I would to share it with everyone so it can also benefit you.
Recent Posts
T-SQL Tuesday 138: Managing Technology Changes
This is my first contribution to T-SQL Tuesday. It is about how I manage technology changes. As this is the question from this months host, Andy Leonard. Tha...
Check constraint is changed on creation
Today I performed a schema compare between my SQL Database Project and the deployed version of that project. I expected some differences because of various r...
Microsoft Certified: Azure Database Administrator Associate
Today I passed the Exam DP-300: Administering Relational Databases on Microsoft Azure to become an “Microsoft Certified: Azure Database Administrator Associa...