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…