(Pinal Dave) There are so many ways to break things in the operating system. In this blog, we would learn about fixing error “The application has failed to start because its side-by-side configuration is not correct”.

(Grant Fritchey) What? Execution plans and the GDPR? Is this it? Have I completely lost it? Well, no, not on this topic, keep reading so I can defend myself.

(Michael J. Swart) Names for constraints are optional meaning that if you don’t provide a name when it’s created or cannot afford one, one will be appointed to you by the system.

(Pinal Dave) While preparing for a demo for my upcoming session, I encountered an interesting error. I thought I have written a blog about it, but I was wrong. My earlier blog was about a different error which looks very similar.

(Greg Larsen) When you are trying to tune a query, you can look at the query execution plan associated with the TSQL code. By looking at the execution plan you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the quer

(Simon Su) We all know that SQL server is a multi-threads and multi-tasks system and it has its own thread scheduling mechanism which is a small part of job of what we call SQLOS. If you are not familiar with SQLOS you can refer to below two links for the details:

(Denny Cherry) If you’ve tried using Universal Groups in Active Directory to access your SQL Servers, you may notice that the users who are members of these groups can’t access the SQL Server Instance.

(Nakul Vachhrajani) I was recently building up an all-in-one development environment for a project and ran into an unexpected error. I had already installed Microsoft Visual Studio 2017 and attempted to install SQL Server Data Tools (SSDT).

(Pinal Dave) Many times, there are some strange requests which I heard from my clients. I try to help my client with the answers and write a blog so that others can find the answers easily. Let us learn about SQL Server Native Client today.

(Kenneth Fisher) I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular the difference between it and DB_NAME.