235 reputation
16
bio website twitter.com/dan3r3
location Sydney, Australia
age 34
visits member for 2 years, 11 months
seen Jul 25 at 11:04

Programmer (for a crust), player of pianos (for fun), entrepreneur (in my own lunchbox). Love data and my MSSQL :)


Nov
15
awarded  Yearling
Sep
8
comment Can I enable SQLCMD mode from inside a script?
But wouldn't the script just continue executing from the next GO?
Sep
8
accepted Determine last usage date of a linked server
Sep
8
comment Determine last usage date of a linked server
This is a great creative answer and for our environment it will give us a general idea of our linked server usage (most uses will be in plain SQL rather than views/functions). Appreciate the caveats you guys mentioned and we will still need to profile to be absolutely sure that they're not being used.
Sep
8
awarded  Teacher
Sep
8
asked Determine last usage date of a linked server
Sep
8
awarded  Autobiographer
Sep
8
answered Can I enable SQLCMD mode from inside a script?
Aug
24
awarded  Supporter
Aug
24
awarded  Scholar
Aug
24
accepted Is SQL Server Replication transactionally 'safe' across all published tables?
Aug
24
awarded  Student
Aug
24
awarded  Editor
Aug
24
revised Is SQL Server Replication transactionally 'safe' across all published tables?
added 7 characters in body
Aug
24
asked Is SQL Server Replication transactionally 'safe' across all published tables?