[Note from Pinal]: This is a 97th episode of Notes from the Field series. If you know Mike Walsh, he is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn something as a human. In this episode of the Notes from the Field series database expert Mike Walsh gives a challenge to all of us. He explains to us why we should study our mistakes. He is indeed very right that every mistake gives us opportunity to correct ourselves.
SQL SERVER – Column Alias and Usage in Where Clause
You can assign a new name for a derived column in the SELECT statement which is also known as an alias name. But you need to understand how column alias are assigned and its scope
SQL SERVER – SPID is KILLED/ROLLBACK state. What to Do Next?
I always recall my fun days after talking to my friends and blog readers. Recently killed/rollback discussion came back when my close DBA friend called me for help. Our discussion was worth blogging.
SQL SERVER – Database Mirroring login attempt failed – Connection handshake failed
The best way I have learnt about building SQL Server AlwaysOn Availability Group is by contacting my close friends who have written the only book on this topic. It is not common that I ping them for such technical queries, but that is what friendship is made off. Recently, while preparing a demo for the AlwaysOn Availability Group, I ran into interesting issue and was able to fix it as well. Let us learn about the Database Mirroring login error.
Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?
Question: How to Invalidate Procedure Cache in SQL Server?
SQL SERVER – Login failed for user . Reason: Token-based server access validation failed
This is one of the most common error searched on my blog search https://blog.sqlauthority.com/search-sqlauthority/ and lately I realized that I have not written any blog about the cause of such error and fixing that. Let us learn about how to fix the error login failed.
SQL SERVER – Unable to Bring SQL Cluster Resource Online – Online Pending and then Failed
Here is the situation which my client explained and I was asked for help about SQL Cluster Resource.
Hi Pinal,
We are having 2 node windows cluster having 3 SQL Server instances clustered running on Windows 2012 R2 on VMware. We have one instance that will start from the services.msc but not from the Failover Cluster Manager when attempting to bring the service online. In reality the services start because during the ‘Online pending’ I am able to connect and query the databases on that instance, although it is in the ‘Online pending’ state.
Do you know what could be the problem?