There is no other time better than this when Nasa and SpaceX successfully launched their first Astronauts to space station from U.S. since 2011. This launch will create lots of new opportunities in space science and will create a new race in space dominance. When all these developments are going on, we cannot find better… Read More Tech Talk with Saurabh Kaushal ( TEDx speaker)

Issue – Customer was getting below error when he was running any query. Msg 468, Level 16, State 9, Line 36 Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “SQL_Latin1_General_CP1_CS_AS” in the equal to operation. Back ground – Table was part of replication and when he was running query on subscribe he was getting collation conflict… Read More Cannot resolve the collation conflict between “xxx” and “xxx” in the equal to operation

Yesterday, one of my client send me email stating she is not able to run any query against database. she was getting below error message – The transaction log for database ‘xxx’ is full due to ‘LOG_BACKUP’ From error message it’s look like transaction log full issue hence I looked for db property and found… Read More The transaction log for database ‘XXX’ is full due to ‘LOG_BACKUP’

Configuring deadlock and Storing Deadlock events in a table SQL Server 2012 and above. Verification – Ensure Extended Event “system_health” is running. SSMS, checking Management -> Extended Events -> Sessions. These should be green arrow which indicate its running.   The system_health session writes to two targets, both an event file and the ring buffer:  … Read More Configuring deadlock and Storing Deadlock events in a table

Originally posted on Learn Sql Team:
SQL Server 2012 always on Step by step configuration – Prerequisite to configure always on – 1. Domain accounts for SQL Server services should have local admin   access 2. Two IP addess One is for Cluster Other one is for always ON listener Note – These IP address should be in…