NUMA Affinity VMware Fling
When it comes down to the nitty-gritty performance details of CPU and memory with a modern hypervisor like VMware vSphere, you no doubt have heard a lot about NUMA, Non-Uniform…
Tag: sql server
Three lesser known ways to test SQL connectivity
In troubleshooting a SQL connectivity issue recently, I tried multiple tests in connecting to SQL to help troubleshoot the issue. In this post, let’s take a look at three lesser…
Veeam SQL Server 2014 Standard Installation
Veeam uses SQL as the backend for the configuration database. Â By default, if you choose no other option, the installer will install SQL Server Express 2014 as the backend for…
See what user you are connecting to linked SQL server
I wanted to share with you guys a really handy little SQL query that is extremely useful if you are troubleshooting SQL Server linked server connectivity. Â You may have setup…
SQL Server Cannot generate SSPI context Multiple Domains
Recently in working with a multi domain environment, IÂ ran into an issue involving SQL connectivity from a handful of client computers to a certain SQL server. Â The errors involved SSPI…