SQL Server Configuration Archives - Page 6 of 10

SQL SERVER – Changing Max Worker Count for Performance

August 9, 2019

CPU Threads, SQL CPU, SQL Server, SQL Server Configuration, SQL Wait Stats

I wrote a blog post about SQL SERVER – Best Value for Max Worker Count, after reading this blog post, I have received lots of emails.

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151

April 6, 2019

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration, SSIS, TraceFlags

Recently I was helping a client where SQL Server upgrade was failing with an error. If you have seen my blogs, there have been many blogs where I explain steps to fix upgrade-related issues. In this blog, we would learn about fixing another cause of script level upgrade for database ‘master’ failed.

How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217

March 24, 2019

Pinal Dave

SQL Interview Questions and Answers

SQL Scripts, SQL Server, SQL Server Configuration

Question: How Does QUOTED_IDENTIFIER Works in SQL Server?Answer: If you search on the internet, you may find quite lots of notes about it. So in this blog post, I will explain in very simple words.

SQL SERVER – Priority Boost and SSMS 18

March 11, 2019

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Management Studio, SSMS

Just the other day, I had a very interesting experience while using the latest SQL Server Management Studio 18.0 preview 7 (SSMS 18.0) during one of the Comprehensive Database Performance Health Check. My client said they have realized that SQL Server does not have settings of Priority Boost settings available in SQL Server anymore. Actually, this is not true, let us quickly understand the same.

SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.

March 2, 2019

Pinal Dave

SQL

AlwaysOn, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Configuration

Sometimes if the sequence is not followed correctly, we might see some weird errors. In this blog, we would learn how to fix always on an error while adding new replica “The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) node.”

SQL SERVER – SQL Server Configuration Manager Missing from Start Menu

March 1, 2019

Pinal Dave

SQL Tips and Tricks

Registry, SQL Server, SQL Server Configuration, Starting SQL, Windows

Earlier I wrote a blog on the same topic and today I found another way to do the same thing. In this blog, we would discuss the steps you can take to open SQL Server Configuration Manager when its missing from Start Menu in the Windows operating system.

SQL SERVER – FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop

January 5, 2019

Pinal Dave

SQL

Computer Network, SQL Azure, SQL Connection, SQL Error Messages, SQL Server, SQL Server Configuration, SQL Server Security

To keep up with the market trend, I have already done my hands-on with SQL in Azure Virtual Machine. In this blog, I would share my learning about a connectivity issue which I faced recently.