sql server
-
VMware
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 Memory Access. NUMA is extremely important when you are working…
-
Computers
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 known ways to test SQL connectivity including ODBC, a UDL…
-
Backup Software
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 your configuration database. One must think about this choice carefully…
-
SQL
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 a local server login to remote server login mapping which…
-
ActiveDirectory
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 context errors. In fact the exact error when trying to…
