Can’t connect from SSMS on your own machine to SQL Server in an Azure Virtual Machine? Here is the network-related error users see and what to check to fix it.
SQL SERVER – Fix – Error – Property MemoryAllocatedToMemory OptimizedObjectsInKB is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
The MemoryAllocatedToMemory OptimizedObjectsInKB error popped up while I was teaching a workshop. It is a permissions issue, and one command fixes it.
SQL SERVER – Activity Monitor – Active Expensive Queries
A DBA spotted an extra pane in my Activity Monitor during a health check. Here is where Active Expensive Queries shows up and which SSMS version has it.
SQL SERVER – SQL Vulnerability Assessment – Security Analysis
SQL Vulnerability Assessment, free in SSMS 17.4 and later, scans SQL Server 2012 and up for security issues and also suggests fixes. Here is how it works.
SQL SERVER – Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It
Creating a linked server failed its connection test: No connection could be made because the target machine actively refused it. Here is what to check.
SQL SERVER – How to Install New Sample Database WideWorldImportersDW.bak
A client noticed I had no post on the data warehouse sample. Here are the steps to download and restore WideWorldImportersDW, with a note for Standard Edition.
How to Identify Session Used by SQL Server Management Studio? – Interview Question of the Week #151
An interview candidate asked us: how do you identify session IDs that SQL Server Management Studio is using? Here is a simple answer with sp_who2.