Reputation
27,849
Next tag badge:
372/400 score
85/80 answers
Badges
5 51 92
Newest
 Good Answer
Impact
~1.3m people reached

11h
answered Powershell functin to drop table(s) from SQL Server Database
12h
comment Powershell functin 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?
12h
revised Powershell functin to drop table(s) from SQL Server Database
added 120 characters in body
1d
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;
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