Reputation
947
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 11 22
Newest
 Inquisitive
Impact
~64k people reached

  • 0 posts edited
  • 1 helpful flag
  • 64 votes cast
Apr
5
awarded  Inquisitive
Apr
4
asked Include HostName in ODBC System DSN Connection
Apr
1
accepted How can SQL Delete using a sub query
Apr
1
awarded  Nice Question
Apr
1
asked How can SQL Delete using a sub query
Mar
29
comment Copy SQL Logins and Permissions From One Server to Another
How are the databases on Server A and Server B kept in sync? If you're using mirroring or AAG's then the database level is already done
Mar
21
revised Should I use ReFS for a new SQL Server?
added 1 character in body
Mar
11
accepted Availability Group log_reuse_wait = Replication
Mar
11
revised Prevent Deadlocks in Vendor Databases
Added deadlock graph
Mar
3
comment Restore log backups to non-readable async AlwaysOn replica
You're right, I hadn't thought that all the way through. Is it possible to do it without breaking the AAG (although that probably isn't a big issue given that we'd be doing it because of a critical failure at our primary site)
Mar
3
asked Restore log backups to non-readable async AlwaysOn replica
Mar
2
awarded  Yearling
Feb
29
comment Prevent Deadlocks in Vendor Databases
It's no longer in the system_health XE. Since posing the question there hasn't been any deadlocks - always the way right? As per brentozar.com/archive/2014/03/extended-events-doesnt-hard I've setup XE to capture deadlocks for next time. Will update the question when I have answers
Feb
28
comment Prevent Deadlocks in Vendor Databases
Yep realise that. Was hoping that maybe it had a select that was blocking the update and the update blocking the select when the deadlock hit and so changing the isolation level might prevent the select from being blocked.
Feb
28
asked Prevent Deadlocks in Vendor Databases
Dec
2
awarded  Notable Question
Nov
25
awarded  Popular Question
Nov
24
accepted Default Backup to be Copy-Only
Nov
24
answered Default Backup to be Copy-Only
Nov
18
awarded  Popular Question