If you renamed your PC, was it before or after the SQL Server was installed?  You may also need to do a sp_dropserver 'oldname' and an sp_addserver 'newname', 'local' to...

I go into SSMS and expand the Management folder and right click on the SQL Server Error logs and choose Configure.

I don't know that you can set it yet.  I have the very latest build and it does not let me set it, even with the GUI tools of SSMS.

I understand Perry all you have said. I was simply illustrating that I don't like going over 6 nodes in each WSFC and I typically have any FCI having at...

Sounds to me like you have a firewall issue on that node that does not let remote connections, especially if you can connect to the listener locally.

True, but 4 nodes would not be a large number in my opinion.  I typically like having a max of 6 nodes and typically have 2 failover targets per instance...

I would be interested in the configuration of the Listener too.  Is it in a multi-subnet environment? Which port is it listening on, etc.

The Key to TDE is the Encryption Hierarchy.

master database must have a MASTER KEY (CREATE MASTER KEY while in the master database)
master database certificate that when the...

The 2 articles are great references for this setting.
Remember that SQL Server Optimizer is cost based, so the Cost Threshold is for SQL to decide whether it needs to...

I just migrated a whole bunch of SQL Servers from 2008R2 to 2016 and things went well for the databases.  As Gail said the only thing you will want to...

I agree on the use of all 4 nodes and putting 2 FCIs in there.  It gives you multiple failover targets and no single point of failure on a 1:1...

I use that site as well.  But the basics of a connections are as they are listed there.

Server = "Data Source=server name" in the connection string.
Database =...

That's great. Glad you found it useful.

There is a new version in the new module for 2016. The old sqlps loads slowly because it does something that it doesn't need to do. So hang in...

Snapins are only available if you install SQL 2008 feature packs or tools. They are not installed with 2012 or 2014. They are replaced by the sqlps module.