Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...

Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...

Note: While this sample uses local accounts I urge you to consider using an oauth provider/Azure AD as the user store for a real project. It is much more secure than managing username/password ...

I've got this view defined on two tables, one of which has an identity field that auto increments. There seems to be no way to insert into this view. If I leave the auto-increment field blank it barks ...

I associated a managed identity to the VM on azure, and use blow code to connect sql database on azure. I have added the managed identity into db as a user, and grant permission. But encounter issue.