Recently I wrote a blog which will help workers handle sexual harassment at workplace. We don’t talk about this topic as much as we should.
Sql server agent service issue: My junior DBA met me on an interesting issue. Sql service account is not able to start the Sql server
This is found that the cluster service in one of the passive stops. This throws following error when I try to start this. Error 1067:
Read blog Sql Server Error 8951 Data row does not have a matching index row in the index to understand and resolve this quickly. Along
Let’s try following command to get this error: SELECT CAST( CAST(virtual_memory_in_bytes AS VARCHAR(5)) AS DECIMAL(5,2)) FROM sys.dm_os_sys_infoWe can fix this using a perfect CAST statement:select
Wrong or stale spn settings cause this error. I got following alert on tow of my servers eg Tuitionaffordable11, Tuitionaffordable23: “Cannot generate SSPI context”. This