This article covers the main features of ApexSQL tools that are involved with SQL source control. For the purpose of the article, we will use ApexSQL Source Control, ApexSQL Diff and ApexSQL Build.
Hey DBA – Do You Study Mistakes? – Notes from the Field #097
[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.