Reputation
28,235
Next tag badge:
92/100 score
25/20 answers
Badges
5 53 93
Newest
 Enlightened
Impact
~1.4m people reached

Jul
1
awarded  Enlightened
Jul
1
awarded  Nice Answer
Jun
28
awarded  Yearling
May
29
answered Powershell function to drop table(s) from SQL Server database
May
29
comment Powershell function to drop table(s) from SQL Server database
I know I recommended using this site to post your code, but for the rest of the viewers can you explain what your problem is and what is happening?
May
29
revised Powershell function to drop table(s) from SQL Server database
added 120 characters in body
May
28
awarded  Good Answer
May
26
awarded  Good Answer
May
15
comment How to capture Query Status(Sleeping, Background, Running) in SQL Server Profile trace
What exactly are you trying to do?
May
13
awarded  Nice Answer
May
11
awarded  Favorite Question
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;