Reputation
1,105
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 6 19
Impact
~132k people reached

Apr
4
comment How to script permissions for all logins/users/tables/schemas
Great couple of scripts! I use them a lot too, really handy pair of sp's. And been able to transfer password's and SID's, thumbs up for you Kenneth
Mar
7
awarded  Popular Question
Jan
9
comment How is an AAG listener implemented? Where does it run?
This page on MSDN should be useful to understand what an AOAG listener is, how is configured and how it works underneath.
Dec
24
reviewed No Action Needed Connect to LocalDB via SQLCMD in PowerShell
Nov
6
comment Trigger actions on database creation or attach
Next step, adding lot more actions inside the trigger, maybe new questions will arise
Nov
5
comment Trigger actions on database creation or attach
arggghhh!!! how come...thanks
Nov
5
accepted Trigger actions on database creation or attach
Nov
5
asked Trigger actions on database creation or attach
Sep
28
answered Should I backup a database with only temporary data?
Sep
24
awarded  Nice Answer
Sep
9
revised Convert C# logic/lambda's to T-SQL
code formatting
Sep
9
suggested approved edit on Convert C# logic/lambda's to T-SQL
Sep
8
revised Can we use alias name in LIKE statement?
format improving
Sep
8
suggested approved edit on Can we use alias name in LIKE statement?
Sep
8
comment DISABLE / DROP INDEX causing deadlock
Grab the sp whoIsActive from Adam Machanic, run it and see what is running on your box at the moment, this will help you to know what is blocking what, because as Aaron already commented, is impossible to have a "deadlock against nothing".
Sep
7
answered what are the costs of enabling extended events?
Aug
21
revised SQL Server 2012 Exclude a value
code formatting for better reading
Aug
21
suggested approved edit on SQL Server 2012 Exclude a value
Aug
17
awarded  Popular Question
Aug
3
awarded  Constituent