Viewing 15 posts - 16 through 30 (of 90 total)
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...
February 9, 2017 at 9:58 pm
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.
February 9, 2017 at 10:28 am
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...
February 9, 2017 at 10:16 am
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.
February 9, 2017 at 10:06 am
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...
February 9, 2017 at 8:52 am
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...
February 9, 2017 at 8:38 am
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...
February 9, 2017 at 8:24 am
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...
February 9, 2017 at 8:20 am
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 =...
February 9, 2017 at 8:14 am
That's great. Glad you found it useful.
February 9, 2017 at 8:07 am
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...
June 28, 2016 at 6:48 am
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.
January 10, 2016 at 8:38 am
Thanks. I will file a bug on the article to get it fixed. I have a caption in my article, but on the web page it does not....
December 2, 2015 at 8:54 am
Yes, I use it as well. I used invoke-sqlcmd2 -As DataTable in this case, but I regularly use Out-DataTable for many things. Glad you get use out of it too.
December 2, 2015 at 8:53 am
I am not sure why you would not see the instances when you use the dir SQLSERVER:\sql\localhost.
Mine shows DEFAULT as the instance name. If I cd into DEFAULT then...
October 20, 2015 at 7:56 am
Viewing 15 posts - 16 through 30 (of 90 total)