158 reputation
4
bio website
location
age
visits member for 2 years, 3 months
seen Apr 11 at 9:04

Dec
9
awarded  Popular Question
Feb
19
comment Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2?
Thanks for sharing your experience. This tallies with what we've seen, and is somewhat reassuring.
Feb
19
asked Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2?
Jan
29
revised when can AG primary replica be a different host to WFC primary?
added 8 characters in body
Jan
29
asked when can AG primary replica be a different host to WFC primary?
Nov
21
comment SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
Yes, but mirroring was later removed. I'm interested in finding what remnants of that configuration there might be in places I haven't found yet. Yes the AG listener is configured for multi-subnet with a Windows failover cluster; it owns an IP address on both subnets.
Nov
16
awarded  Editor
Nov
16
revised SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
added 105 characters in body
Nov
16
comment SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
Yes, I ran that on both sides, and both reported that they were already not configured for mirroring.
Nov
16
asked SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
Apr
30
comment how does SQL Server know to lock view objects?
One question: we agree that using the view should block concurrent attempts to change the view definition. Then why take IS rather than Sch-S lock on this? Only difference between the two is behaviour on bulk updates. I would expect it to take the weakest lock it could that gave the required protection.
Apr
30
awarded  Scholar
Apr
30
accepted how does SQL Server know to lock view objects?
Apr
25
awarded  Student
Apr
25
asked how does SQL Server know to lock view objects?