Viewing 15 posts - 31 through 45 (of 1,079 total)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 19, 2018 at 2:29 am
1) Even after 3) there still isn't a usable database because "mydatabase" on S2 (which had become the primary) could've had transactions on it that S1 doesn't know about yet? -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 18, 2018 at 11:02 pm
Firstly, speakers invest a lot of their own time, mostly unpaid to give back to the community, and anyone who fails to appreciate this should stop attending sessions. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 18, 2018 at 12:16 am
Start with Perry's Stairway to AlwaysOn, will answer all your questions: http://www.sqlservercentral.com/stairway/112556/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 19, 2018 at 1:14 am
Try the following. I set @myvalue to 6 as a test for a normal operation. Comment it out and you'll get a "-3" returned. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Build your other logic around/in it.
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 2, 2017 at 1:19 pm
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 2, 2017 at 10:28 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 2, 2017 at 8:52 am
Since the Quorum and FSW is a Windows Cluster Component, your best bet is PowerShell:
get-clusterresource -cluster sqlcluster | where-object {$_.ResourceType -like “File Share Witness”} | get-clusterparameter
To...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 2, 2017 at 8:16 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 2, 2017 at 7:52 am
If I understand your question correct, you should use ALTER AVAILABILITY GROUP:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 30, 2017 at 7:13 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 27, 2017 at 10:24 am
From your post, we can understand that:
1. Your Infrastructure Team wants a Failover Cluster with a FSW Quorum instead of shared Disk,
2. SQL DB Mirroring uses a Witness...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 27, 2017 at 10:14 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 17, 2017 at 7:28 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 17, 2017 at 6:23 am
Consider using the ReadOnlyRouting and the ApplicationIntent=ReadOnly switch in your connection string for the read-only readers.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 9, 2017 at 6:26 am
Viewing 15 posts - 31 through 45 (of 1,079 total)