Reputation
27,594
Next tag badge:
364/400 score
84/80 answers
Badges
5 48 91
Newest
 Nice Answer
Impact
~1.2m people reached

Apr
30
awarded  Nice Answer
Apr
23
answered Dropping person while their connection sleeping in SQL Server
Apr
16
answered Copying SQL Server database
Apr
8
comment Alwayson cannot fail over using tsql
I think you are looking at this the wrong way. You shouldn't care which node owns the core cluster resource group (and resources). You care which node owns the SQL Server AG cluster resource group, which will most definitely be the same server/node that hosts the primary replica of the availability group.
Apr
8
comment Alwayson cannot fail over using tsql
What error(s) do you get when you attempt to failover via T-SQL?
Apr
7
answered AlwaysOn AG - CPU limitations
Mar
27
revised SQL AlwaysOn Availability 2 synchronous nodes on either side of an asynchronous link
edited tags
Mar
27
answered SQL AlwaysOn Availability 2 synchronous nodes on either side of an asynchronous link
Mar
14
comment reorganize and UPDATE
No data needs to be updated here. select * from TICKETS order by TicketID;
Mar
14
comment Log shipping and SIMPLE recovery mode
What you can do and should do is stop setting your database's recovery model to simple. What is the root reason for doing this?
Mar
14
comment Take action from extended event?
What you can do is hook into XEvents event stream and take action that way. Very powerful, the sky is the limit. Information on how to accomplish this can be found here: tstringer.azurewebsites.net/?p=821
Mar
11
awarded  Famous Question
Mar
4
comment Backup terminating abnormally
@AaronBertrand The command is in the input buffer, and the error is an access violation. RFSonders, my recommendation would be to open up a case with SQL support.
Mar
4
comment SQL Server: get meta-Info about LDF-File
See my answer below for more information, but what are you trying to accomplish with this data? What's the bigger picture?
Mar
4
answered SQL Server: get meta-Info about LDF-File
Mar
3
comment How can I speed SQLPS connection when I don't have WMI permissions at the server
Can you add to your question the PowerShell that you're running, as well as the verbose warning messages?
Mar
2
awarded  Announcer
Feb
27
comment Long running DBCC CHECKDB
Have you looked to see if the DBCC CHECKDB request is being blocked during this time?
Feb
27
awarded  Enlightened
Feb
27
awarded  Nice Answer