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…