A client’s security team removed SQL Server Management Studio from the server. Here are simple ways for beginners to run a query without it.
SQL SERVER – Empty Startup Parameter in SQL Cluster on One Node
Many problems lead to the same symptom. Here is another reason for an empty startup parameter in SQL Cluster, when it was not a registry permission issue.
SQL SERVER – Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations
SQL Server 2014 setup failed with an Install Error: standalone SQL Server on a WSFC cluster cannot have files on shared disk. Here is why and what to do.
How to Reduce High Virtual Log File (VLF) Count? – Interview Question of the Week #162
Found a high Virtual Log File (VLF) count in your database? Here are the steps I follow to bring the count down, starting with the log file details.
SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page
Adding Analysis Services to SQL Server 2014, the Installation Wizard hung on “Please Wait” at feature selection, even after my lunch. Here is what fixed it.
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
SQL Server Agent would not start, and the log said Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed. Here are the logs I check and the fix I found.
SQL SERVER – Unable to Start Jobs – Error: Enumerate Target Servers Failed for Job
They showed me below error when they were trying to run a job. Let us see how we can fix the error Enumerate Target Servers Failed for Job.