81 reputation
3
bio website
location
age
visits member for 1 year, 9 months
seen yesterday

Sep
11
answered What is best way to storing geo coordinates related to planned route?
May
24
comment Exporting database Oracle 7.3 on Windows NT 3.51
Wow, it's been about 18 years since I've been near a server like that. Is this syntax more helpful? EXP73.EXE USERNAME/PASSWORD@INSTANCE FILE=OUTFILE.DMP FULL=Y LOG=LOGFILE.LOG
Jan
11
awarded  Supporter
Jan
11
comment WSUS for SQL server patching
Two interesting answers, adding to Aaron's answer: I wouldn't use WSUS for updating a SQL Server that is rev-locked by a 3rd party vendor application thus breaking the app's support agreement, or for updating a server with the WSUS database on it. However, I would consider it for a small db server in a dmz.
Nov
5
answered How can I get the correct offset between UTC and local times for a date that is before or after DST?
Oct
11
revised Grouping data checking against top values
added 423 characters in body
Oct
11
revised Grouping data checking against top values
added 23 characters in body
Oct
11
answered Grouping data checking against top values
Sep
27
answered Convert spatial points data to line data for use in Line Layer in SQL Server Reporting Services (SSRS)
Sep
24
awarded  Teacher
Sep
21
awarded  Editor
Sep
21
comment How do I monitor which Windows user is logging in as SA?
Great point Aaron, and sys.dm_exec_sessions is four times faster than master..sysprocesses (19 msec instead of 77 msec), I've edited the snmp trap query above.
Sep
21
revised How do I monitor which Windows user is logging in as SA?
added 3 characters in body
Sep
20
answered How do I monitor which Windows user is logging in as SA?