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.
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 – How to Migrate Existing Database to Contained Databases
Most of the queries that land into my inbox are based on something I have already written or something people want to explore more on. When it comes to learning and exploring the skills, there is no better way compared to people asking me some tough questions. This blog is…
Read More
SQL SERVER – Adding File to Database in AlwaysOn Availability Group
Writing some typical interview questions have been on my list always. I look for new ways of tricking the person and most importantly, some of the interview questions are designed to make sure the person has strong fundamentals. This blog is one such attempt to understand the basics of the AlwaysOn Availability Group.
SQL SERVER – Inserting into Sparse Column Sets and Errors Associated With It
I have written tons of blogs in the past around using sparse columns. The best part and lesser known part of sparse columns is that we can write to the column sets directly too. In this blog let me take a tour of how this can be achieved. When sparse…
Read More
SQL SERVER – How to Find If Queries are Running in Parallel?
Let us learn today how to find if queries are running in Parallel? If a query runs in parallel it is a query that SQL Server thinks is expensive.
SQL SERVER – FIX – Property IsLocked is Not Available for Login
I play and experiment with SQL Server to the max. Sometimes I am not sure what I did and I land into something undesired. Then the reason to troubleshoot starts and I get to learn something new. Sometimes these learnings are based on error messages that you folks send me.…
Read More