56 reputation
3
bio website
location
age
visits member for 10 months
seen 2 days ago
stats profile views 0

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?