Eric Humphrey - lotsahelp

less info
3,505 reputation
1821
bio website erichumphrey.com
location Fort Worth, TX
age 33
visits member for 3 years, 3 months
seen Apr 21 at 18:30

I'm the database administrator for Six Flags Entertainment. I specialize in SQL Server with experience in several different programming languages and database platforms.

I am passionate about the SQL and .NET developer communities. I enjoy presenting SQL related topics and enticing users to see what is possible with technology.

You can also find me on Twitter via @lotsahelp


Mar
25
awarded  Good Answer
Jan
30
answered Migration from SQL Server 2008 to Postgres 9.2
Jan
10
awarded  Yearling
May
31
revised Linked Server Login Timeout but SqlCmd works
added 43 characters in body
May
31
revised Linked Server Login Timeout but SqlCmd works
added 106 characters in body
May
31
comment Linked Server Login Timeout but SqlCmd works
RDP to server A with linked server to B. Nothing in error log.
May
31
revised Linked Server Login Timeout but SqlCmd works
added 57 characters in body
May
31
comment Linked Server Login Timeout but SqlCmd works
Either submitting a query or testing the linked server. No IPSec, that I know of. No logon triggers. Increased connection timeout does not help. sqlcmd is instantaneous.
May
31
asked Linked Server Login Timeout but SqlCmd works
May
7
answered sleeping SPID blocking other transactions
Apr
7
awarded  Notable Question
Jan
10
awarded  Yearling
Oct
18
awarded  Taxonomist
Sep
26
answered Understanding MS SQL Server encryption and backups
Sep
21
awarded  Custodian
Sep
3
awarded  Nice Answer
Aug
7
comment Mapped drive for Microsoft SQL Server 2008
Why backup to a mapped drive when you can just backup to a UNC path directly?
Jul
5
comment Can I prove my database does not have memory issues?
If the transition from slow to fast was very rapid, then you most likely have out of date statistics. If it was a slow degrade, then it could be fragmented indexes.
Jul
5
answered FIFO queue table for multiple workers in SQL Server
Jun
17
awarded  Nice Answer