Being a DBA, I know the pain of a long running job creating performance issues for other jobs and user sessions. For my current organization, I have created
Recently I was working on a SQL query in my inventory database, and was greeted with below error message:- Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS”
I often see DBAs/developer struggling to find what’s wrong with query. The first step in troubleshooting queries is finding out information like batch text, query text, batch execution
Recently Brent Ozar team added yet another great feature of Power BI Dashboard on data collected from First Responder Kit. In case you are not familiar with what
Hi Friends, I often work on Performance Issues, and I found that developers use RECOMPILE option without even understanding it thoroughly. Instead of resolving the performance issue by
Hi Friends, I have seen DBAs to wait for user’s confirmation for long after providing access/permissions. This is not required since we have very easy way to verify
Recently I tried to setup Database Mail profile in SQL Server 2016 instance using 2-Step authenticated GMail account. Even after setting up mail profile as per standard configuration
There are many tools in market that can help you troubleshoot in specific situations. My personal favorite for finding out issue with SQL Server is SQL-Server-First-Responder-Kit created by